Insert or delete rows and columns - Microsoft Support
To insert a single column: Right-click the whole column to the right of where you want to add the new column, and then select Insert Columns. To insert multiple columns: Select the same …
Transpose (rotate) data from rows to columns or vice versa
If you want to rotate your data frequently to view it from different angles, consider creating a PivotTable so that you can quickly pivot your data by dragging fields from the Rows area to the …
Split data into multiple columns - Microsoft Support
Power Query splits the Sales Rep names into two different columns named "Sales Rep 1" and "Sales Rep 2". To change the default names, rename them to "Sales Rep First" and "Sales …
Freeze panes to lock rows and columns - Microsoft Support
To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can …
Change column width or row height - Microsoft Support
If you can’t see all the data in a cell, changing the row height or column width can help: To increase the width of a single column, such as column B in the picture below, drag the …
Sort data in a range or table in Excel - Microsoft Support
How to sort and organize your Excel data numerically, alphabetically, by priority or format, by date and time, and more.
Use calculated columns in an Excel table - Microsoft Support
Calculated columns in Excel tables are a fantastic tool for entering formulas efficiently. They allow you to enter a single formula in one cell, and then that formula will automatically expand to the …
Fit more text in column headings - Microsoft Support
Rotate text and borders in column headings You can angle text to fit long headings into small columns. Select the cells that you want to format. On the Home tab, click Format, and then …
Resize a table by adding or removing rows and columns in Excel
To insert a column, pick any cell in the table and right-click. In the example shown below for rows, a row will be inserted above row 3. For columns, if you have a cell selected in the table's …
Transpose data from rows to columns (or vice versa) in Excel for Mac
You can convert the table to a range first by using the Convert to Range button on the Table tab, or you can use the TRANSPOSE function to rotate the rows and columns.