excel training uk - Excel

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

Resolved · Low Priority · Version Standard

Excel

Zana has attended:
Outlook Advanced course
Word Advanced course

by - delegate Zana [4 posts] (2007 Nov 2 Fri, 10:01) Reply

Is there any short cut keys to hide and unhide in Excel?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 9 Fri	Bloomsbury	1	book now	£240	£245
2007	2009 Jan 14 Wed	Bloomsbury	5	book now	£235	£245
2002/XP	2009 Jan 14 Wed	Tooting	0	FULL
2003	2009 Jan 16 Fri	Southwark	0	FULL
2007	2009 Jan 21 Wed	Bloomsbury	3	book now	£240	£245
2003	2009 Jan 21 Wed	Southwark	2	book now	£235	£240
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 31st March 2010.

RE: Excel

by - trainer Pete platinum contributer [867 posts] (2007 Nov 7 Wed, 11:22) Edited on 2007 Nov 7 Wed, 11:23 Reply

Hi Zana, Thanks for the post, I hope you have enjoyed the courses you have attended, in response to your post the keyboard combinations to Hide and Unhide are; Select the columns/rows then use ALT+O+C+H to hide and select either side of the hidden columns/rows and use keyboard combination: ALT+O+C+U to unhide. Hope that answers your question, Best regards Pete

· Microsoft Excel Training Advanced Courses - Making Data Validation Work For You
· Why Excel Training (Sometimes) Doesn't Work and What You Can Do About It
· Excel in the Home Office
· Do You Really Need Excel VBA Training?
· Microsoft Excel Cheat Sheet: Tips and Shortcuts

Excel tip:

Turn Function tooltips on and off

Excel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose OK.

View all Excel hints and tips

Rate this page: