Excel Hide/Un-Hide Columns?

Anyway to toggle Hide/Show certain columns?
LVL 1
Jess31Asked:
Who is Participating?
 
zorvek (Kevin Jones)ConsultantCommented:
If using Excel 2007 or later, navigate to the View tab and click Custom Views. The rest is the same as 2003.

Kevin
0
 
zorvek (Kevin Jones)ConsultantCommented:
Without macros, you can select the column(s), right click in the column header, and select Hide. To unhide, select the columns to the left and right of the hidden column(s), right-click in the header, and select Unhide.

Kevin
0
 
zorvek (Kevin Jones)ConsultantCommented:
You can also use Views. Set the column widths for the first view, select the menu command View->Custom Views, click Add, enter the name of the view and click OK. Repeat with the columns hidden. To select one view or the other, select the menu command View->Custom Views and double-click the desired view.

Kevin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.