About Us

bala_vb

Quote:

Originally Posted by trip_to_tokyo[_3_]

EXCEL 2007

Click rows 4, 5 and 6 so that they are highlighted.

Right click / Hide.

TO UNHIDE

Click rows 3 to 7 to highlight them.

Right click / unhide.

If my comments have helped please hit Yes.

Thanks.

A method playing with heights of the rows:

Select rows 4 to 7 and right click, give row height equal to 0.1
now rows 4 to 7 are not visible (just hidden)

Next time to unhide them (to make visible)
follow the same procedure, select rows from 3 to 7 and right click, give row height equal to 15. (now they are visible).

PS: in this scenario, unhide wont work.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Search for data in Excel and hide rows	Bjarne Jensen	Excel Worksheet Functions	2	February 5th 10 02:20 PM
I want to use subtotals in Excel and hide all rows except total	Firemann59	Excel Discussion (Misc queries)	4	January 3rd 07 09:04 PM
How do I set up Excel to automatically hide certain rows?	Martin	Excel Discussion (Misc queries)	3	December 13th 06 08:07 PM
How do I delete columns and rows in Excel, not just hide them	Eddie	Excel Discussion (Misc queries)	2	November 23rd 05 05:11 PM
Why do my rows automatically hide in Excel?	jessgust	Excel Worksheet Functions	1	October 19th 05 10:01 PM

Menu

About Us