Excel

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

Resolved · Low Priority · Version 2003

Excel

Catherine has attended:
Outlook Advanced course
Excel Intermediate course

by - delegate Catherine [3 posts] (2008 May 20 Tue, 16:29) Reply

How do I unhide cells?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Aug 26 Tue + 27 Wed	Bayswater	4	book now	£475	£485
2003/XP	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003/XP	2008 Sep 18 Thu + 19 Fri	Bloomsbury	5	book now	£450	£485
2003/XP	2008 Sep 25 Thu + 26 Fri	Southwark	6	book now	£450	£485
2003/XP	2008 Oct 6 Mon + 7 Tue	Bayswater	5	book now	£450	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	7	book now	£345	£399
Full Schedule: See all 45 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel

by - trainer Amanda platinum contributer [945 posts] (2008 May 27 Tue, 13:32) Reply

Hi Catherine

Thank you for your question.

You can unhide cells by selecting the columns or rows either side of the hidden cells; then right-click within the columns or rows selected and choose Unhide from the options. The column or row of hidden cells should reappear.

I hope this helps.
Amanda

· Prepare for your MOS Certification with MS Excel Courses
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Reasons Why VBA for Excel Training Fails
· Advanced Excel Training - takes you to the next level
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training

Please browse our web site to find out more about
microsoft-excel-training and other Microsoft training courses.

Excel tip:

Return to the active cell after scrolling

When I scroll a long way down the screen from a selected cell, I can return to that cell with the Ctrl+Back Space shortcut. The active cell now appears in roughly the middle of the screen.

Shift+Back Space does something similar. Scroll down from the active cell and Shift+Back Space returns me to it and puts the active cell at the top of the screen; scroll up from the active cell and Shift+Back Space returns me to it and puts the active cell at the bottom of the screen.

Note also, that while Ctrl+Back Space will return me back to a selected range, Shift+Back Space only ever returns me to the active cell, which is normally at the top left-hand corner of any selected range.

View all Excel hints and tips