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 …

How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.

How to change the column width and row height, including how to use the AutoFit feature, in your Excel worksheet.

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 …

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 …

How to use Transpose in Excel to rotate columns and rows to rearrange your worksheet data.

You can adjust column widths in Excel so that every cell is wide enough to display its information, and so that you don't see the ##### sheet error.

Excel provides multiple techniques that you can use to count cells, rows, or columns of data. To help you make the best choice, this article provides a comprehensive summary of methods, a …

How to lock cells in Excel to protect your data. You can also unlock a range of cells and grant permissions to others to edit.

Select the column to the right of the column where you want to place the split, and use the Split command. You can also split on both a row and a column. by selecting the cell below and to …