Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Hiding columns and/or rows

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Hiding columns and/or rows

Resolved · Medium Priority · Version 2003

Reply Mon 24 May 2010, 20:39Delegate 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

For upcoming training course dates see: Pricing & availability

Reply Tue 25 May 2010, 06:13Trainer 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

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

RE: hiding columns and/or rows

Thanks Newson!

Excel articles

· Advanced Excel and PivotTable Reports
· Discover The Difference Between Line And XY Scatter Charts In Excel
· What's Better Than the Help Function in Excel? Microsoft Training
· Excel Offers A More Relaxing Way To Work Out
· More Tips From Excel's Rarely Used File

Please browse our web site to find out more about
exce+training and other Microsoft training courses.

Excel tip:

Add Text to Displayed Numbers in Excel 2010

To add text to a number in a cell, you need to go to the Home tab on the Ribbon, and click on the Cells group. Select Format Cells from the drop down menu then Custom from the Category list. In the Type box select General. After the word General, enter a space, then opening quotation marks, then the word you want to type and then closing quotation marks. Click on OK and you have your text!

View all Excel hints and tips