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 number of …
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 Columns area …
Apply color to alternate rows or columns - Microsoft Support
Here's how: Select the range of cells that you want to format. Go to Home > Format as Table. Pick a table style that has alternate row shading. To change the shading from rows to columns, select the …
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 rightmost column, …
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 Split panes …
Change the column width and row height - Microsoft Support
If you find yourself needing to expand or reduce Excel row widths and column heights, there are several ways to adjust them. If you're working in Page Layout view (View > Workbook Views > Page Layout), …
Repeat specific rows or columns on every printed page
If a worksheet spans more than one printed page, you can label data by adding row and column headings that will appear on each print page. These labels are also known as print titles.
Present your data in a column chart - Microsoft Support
To create a column chart: Enter data in a spreadsheet. Select the data. On the Insert tab, select Insert Column or Bar Chart and choose a column chart option. You can optionally format the chart further: …
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 Rep Last".
Resize a table, column, or row - Microsoft Support
On the Layout tab, in the Cell Size group, click in the Table Column Width box, and then specify the options you want. To make the columns in a table automatically fit the contents, select your table.