Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Project Training and help » Hidden Rows

	98.1 % recommend us
	More live stats...

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

Training information:

Hidden Rows

Resolved · Medium Priority · Version 2007

Reply Thu 27 Oct 2011, 10:17Delegate Clare said...

Clare has attended:
Excel Intermediate course

Hidden Rows

Is there any way to view only the hidden rows on your spreadsheet?

For upcoming training course dates see: Pricing & availability

Reply Mon 31 Oct 2011, 13:14Delegate Barry said...

RE: Hidden Rows

Hi Clare, how many rows are we talking about all together including the hidden ones please?

Baz

Reply Mon 31 Oct 2011, 14:56Delegate Clare said...

RE: Hidden Rows

Hi Baz,

Its 155, including the hidden ones.

Regards

Reply Wed 2 Nov 2011, 13:53Trainer Paul said...

RE: Hidden Rows

Hi,

I have looked through all of the normal settings in Excel and I cannot find a way of doing that. You will be able to write some VBA code that can do this, but not the way you are looking at just seeing the hidden sheets.

Thanks
Paul

Reply Wed 2 Nov 2011, 14:13Delegate Clare said...

RE: Hidden Rows

Ok. Thanks very much for your help.

Reply Wed 2 Nov 2011, 14:40Trainer Paul said...

RE: Hidden Rows

I will double check with another VBA trainer and let you know if he knows of a way.

Thanks
paul

Tue 8 Nov 2011: Automatically marked as resolved.

MS Project articles

· Using Microsoft Project As Part Of Your Project Planning Strategy
· Save Time By Linking Tasks In Microsoft Project
· Differences Between Gantt Chart And Network Diagram View In Project 2007
· How To Use The New Timeline View In Project 2010
· Getting Your Project Off The Ground

Please browse our web site to find out more about
exchange server 2003 distant learning and other Microsoft training courses.

Ms project tip:

Formatting Bar Text

To display notes or resource initials on the Gantt chart bars, choose Format, Bar Styles and the Text tab. Select the position you want to show the text i.e. Top or Inside etc, then choose the field name you are looking for from the drop down arrow. Type the first letter of the name to get quickly to the top of the letter range. Click OK.

View all MS Project hints and tips