Excel Formatting

dave13

Hi
How do I delete all the unused columns in a spreadsheet.Say I'm only using six columns how can I get rid of the rest?I know it can be done I just can't find the answer. Deleting them one by one seems a bit ridiculous.

thanks

Nosh*tsherlock

Depends on what you mean by delete.

To delete any unused rows:
Move down one row from the last cell with data.
Hold the Ctrl and Shift keys, and press the Down Arrow key
Right-click in the selected cells, and, from the shortcut menu, choose Delete

To delete any unused columns:
Move right one column from the last cell with data.
Hold the Ctrl and Shift keys, and press the Right Arrow key
Right-click in the selected cells, and, from the shortcut menu, choose Delete

This clears all the data that might be in these cells but the columns/rows themselves will still be there. If you are just talking about what you can see, you can't change the numbers that are defaulted. You could always just hide them if you don't want to see them.