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 Excel Training and help » Hiding rows
Hiding rows
Resolved · Medium Priority · Version 2003
Wed 25 Feb 2009, 16:40Delegate 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:00Trainer 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 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. |
Excel tip:Apply currency format quickly in ExcelTo 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 + $ |
