Stephen Tyrrell

Posts: n/a

What is the quickest way to hide a lot of rows and colums ?

I want to hide all but the first ten rows and ten columns of a worksheet. Is
there a quicker way than highlighting and scrolling through the rows/columns
I want to hide?

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Format to hide empty rows	tamato43	Excel Discussion (Misc queries)	4	May 10th 05 10:16 PM
Hide Rows	Steve	Excel Discussion (Misc queries)	2	February 9th 05 10:09 PM
how to hide rows in a protected sheet	Prakash	Excel Worksheet Functions	7	January 18th 05 02:42 PM
Why can't I show or hide rows in an outline on a protected sheet?	rwlass	Excel Discussion (Misc queries)	1	December 9th 04 04:38 PM
Excel - if cells = 0, how to conditionally hide rows in chart	fineimage	Excel Worksheet Functions	1	November 11th 04 09:45 PM

All times are GMT +1. The time now is 12:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us