It might take a little time to get your worksheet laid out perfectly, but getting it exactly right is simple enough and very satisfying. You’ll probably need to rearrange some columns or rows, delete empty or useless columns or rows, or add new ones. You might need to make room for some data that you want to move. If you find that you need an existing row or column but that its current content is useless, you can simply delete the content but leave the empty row or column intact.
Add a Column
Right-click the column header at the right of where you want the new column.
Choose Insert from the shortcut menu.
Tip
To add or delete several rows or columns at one time, or to clear the contents of multiple rows or columns at one time, select multiple column or row headers before you right-click. To select nonadjacent rows or columns, hold down the Ctrl key as you click each row or column header.
Add a Row
Right-click the row header below where you want the new row.
Choose Insert from the shortcut menu.
Delete a Column or a Row
Right-click the column header or the row header.
Choose Delete from the shortcut menu.
See Also
"Hiding Columns and Rows" for information about hiding columns or rows without deleting them.
Delete Some or All Content of Cells
Select the cells to be cleared.
On the Home tab, click the Clear button and, from the submenu, choose what you want to delete.
Tip
To quickly clear the content of a selected cell or cells without removing any formatting, press the Delete key. Remember that you can use the Undo button on the Quick Access toolbar to restore any content that you deleted unintentionally.