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 …

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 …

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 …

There are two ways to apply shading to alternate rows or columns —you can apply the shading by using a simple conditional formatting formula, or you can apply a predefined Excel table style …

To do this, you can use text functions to separate the parts of the cells, or you can use the Convert Text to Columns Wizard. For examples and more information, see Split text into …

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 …

Formulas you enter in Excel table columns automatically fill down to create calculated columns.

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.

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 …

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 …