excel training courses - Hidden Rows in Excel

The UK's most regular instructor-led training courses.
Training information: excel training courses · Excel course london · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Hidden Rows in Excel

Stavros has attended:
Excel Advanced course

by - delegate Stavros [1 post] (2007 Jun 29 Fri, 16:11) Reply

Hello

Can you tell me how to find rows that are hidden in Excel without using the left hand column. I have data with 1000 rows and need to know which ones are hidden. I do not want to use the show all hidden rows function, I want to know which ones are hidden

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	5	book now	£219	£235
2003	2008 Sep 17 Wed	Southwark	0	FULL
2003	2008 Sep 17 Wed	Bayswater	5	book now	£195	£205
2003	2008 Sep 19 Fri	Bloomsbury	6	book now	£214	£230
Full Schedule: See all 125 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Hidden Rows in Excel

by - trainer Carlos gold contributer [413 posts] (2007 Jul 2 Mon, 13:21) Reply

Hi Stavros

I don't know of a function in Excel that lists all hidden Rows/Columns.

However if you search in Google there are some 3rd party add-ins that can probably solve this problem for you.

Hope this helps.

Regards

Carlos

· Microsoft Office and the Small Business: Part 1 Excel
· How to Create Better Excel Spreadsheets: Part One
· How to Create Better Excel Spreadsheets: Part Three
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Benefits of learning about Excel charts