learning excel

learning excel - Hiding

Resolved · Low Priority · Version Standard

Hiding

Jethro has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Excel VBA course

by - delegate Jethro [2 posts] (2007 Feb 13 Tue, 09:42) Reply

How can i hide a column?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 8 Mon	Bayswater	2	book now	£224	£224
2007	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 9 Tue	Tooting	0	FULL
2003	2008 Dec 11 Thu	Southwark	7	book now	£188	£215
2007	2008 Dec 16 Tue	Bayswater	6	book now	£207	£215
2002/XP	2008 Dec 16 Tue	Tooting	0	FULL
Full Schedule: See all 108 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: hiding

by - trainer Tracy platinum contributer [586 posts] (2007 Feb 13 Tue, 12:45) Reply

Hi Jethro,

To hide a column you simply highlight the columns you do not want to see and go up to the window menu and down to Hide.

regards

Tracy

· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Microsoft Excel Training Advanced Courses - Making Data Validation Work For You
· Why Should I Learn Visual Basic in Excel?
· From the Classroom to the Corporate World
· A Beginners Guide To Formulas In Excel

Excel tip:

Select only cell that contain text to lock format

For selecting cells that only contain Text in Excel

By selecting cells that only contain text, you can delete, fill or protect cells of this type.

Use short cut to Go to box (F5) or Edit, Go to
In the dialog box, click special button & select Constants and only check text or any other desired type.

Click OK.

And text cells will all be highlighted for you to apply format. Please note only works on one sheet at a time.

View all Excel hints and tips

Rate this page: