Excel Magic 2: Tame Those Columns!

MICROSOFT EXCEL 2003, 2007 and 2010:
Column Formatting Top 5

1. Insert Or Delete a Column:
Select column title next to location.
Right click - Select Insert

2. Adjust Column Width:
Manual: Click and drag column title border.
AutoFit: Double click column title border.

3. Turn Column Titles On or Off
2007 and 2010 only: View, Headings.
2003 - Tools, Options, Window Options -
uncheck Row and Column Headings.

4. Hide or Unhide Columns:
Hide: Select Column. Right Click - Select Hide.
Unhide: Select Columns Next To Hidden Column.
Right click - select Unhide.

5. Group Columns to Hide/Unhide Data:
2003: Select columns - Data, Group and Outline, Group
2007-2010: Select columns - Data, Outline, Group

Note: Click the outline, plus or minus symbols to toggle the columns.


The Microsoft certified professionals at Brandpointe can help you conquer FOE (Fear of Excel).

Quick guides, AdobeConnect sessions, Flash videos or Skype sessions with an instructor, we can provide successful tools.

Register to become a member of our online community. We provide a seamless learning experience anytime you need it, with our Topyx learning site. www.brandpointeonline.com