Hiding columns and/or rows

Resolved · Medium Priority · Version 2003

Mon 24 May 2010, 20:39 Delegate Ngozi said...

Ngozi has attended:
Excel Intermediate course
Excel Advanced course
Finance for Non-Financial Managers course

Hiding columns and/or rows

Hi all

I would like to hide rows within quite a long excel sheet selecting from row 1 to 5000. Am I able to select row 1 and then row 5000 without having to scroll down with the mouse?

Thanks

Ngozi

Tue 25 May 2010, 06:13 Trainer Newson said...

RE: hiding columns and/or rows

Hi in the name box the one that displays the activecell address to the left of the formula bar type

2:5000

and press enter. This will highlight all the rows.

Do not click anywhere otherwise you will lose the highlight

To hide the rows either

Hold down the Ctrl key and press the number 9 = Ctrl+9 this is the shortcut key to hide rows

OR

Go to the Home tab select format -Hide and unhide - Hide Rows

Wed 26 May 2010, 19:53 Delegate Ngozi said...

RE: hiding columns and/or rows

Thanks Newson!

Excel tip:

Remove unused toolbar buttons

Are there buttons on your Excel toolbars that you never use? Remove them from the toolbar by doing the following:

1. Go to Tools - Customise - Commands.
2. Select the toolbar button you wish to remove, then use your mouse to drag and drop the button into the Excel window. When you release your finger from the mouse, the button will disappear.

View all Excel hints and tips

Hiding columns and/or rows

Hiding columns and/or rows

RE: hiding columns and/or rows

RE: hiding columns and/or rows

Excel articles

Excel tip:

Remove unused toolbar buttons