Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel Formatting

  • 28-06-2006 1:59pm
    #1
    dave13
    Registered Users, Registered Users 2 Posts: 813 ✭✭✭


    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


Comments

  • #2
    Nosh*tsherlock
    Registered Users, Registered Users 2 Posts: 47 ✭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.


Advertisement