Hiding rows

Resolved · Medium Priority · Version 2003

Wed 25 Feb 2009, 16:40 Delegate Luisa said...

Luisa has attended:
Excel Intermediate course

Hiding rows

If rows are hidden, but you want the reader reviewing the spreadsheet to be able to click on a button to see the details of the rows that were hidden, how this be done?

Wed 25 Feb 2009, 19:00 Trainer Cress said...

RE: Hiding rows

Hello Luisa
Thank you for your question

I would suggest you record a macro. Start with all the rows hidden and while recording, unhide all the rows. Stop recording and attach the macro to a button which says Unhide. You could also record a macro which hides all the rows and have another button to hide the rows. The simple macro recorder is under tools, macro, record new macro.

If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress

Tue 3 Mar 2009: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Apply currency format quickly in Excel

To quickly apply the currency format to cell in your spreadsheet, select (highlight) the cells you wish to apply currency format to, then use Ctrl + Shift + $

This will apply a pounds symbol even though the $ key is pressed.

View all Excel hints and tips