98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Project Training and help » Hidden Rows
Hidden Rows
Resolved · Medium Priority · Version 2007
Thu 27 Oct 2011, 10:17Delegate Clare said...
Clare has attended:
Excel Intermediate course
Excel Intermediate course
Hidden Rows
Is there any way to view only the hidden rows on your spreadsheet?
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
Mon 31 Oct 2011, 14:56Delegate Clare said...
RE: Hidden Rows
Hi Baz,
Its 155, including the hidden ones.
Regards
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
Wed 2 Nov 2011, 14:13Delegate Clare said...
RE: Hidden Rows
Ok. Thanks very much for your help.
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.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
MS Project tip:Inserting Task Durations QuicklyWhen entering durations for your tasks simply use the single letters - m for min, h for hr, d for day, w for week, but mon for month. If default is set for days, you need only type the number, for example 3 for 3days, or 0.5 for half a day. |
