Hiding Or Unhiding Columns in Excel 2010

Uploaded by HelpDeskTV on 12.07.2011

Thank you for joining us today. I’m Rudy Stebih and welcome to Episode 5 – Hiding
Or Unhiding Columns in Excel 2010 here on Help Desk TV.
Suppose you want to print or display a worksheet without certain information, but you want
to keep that information for future use. Excel lets you hide a column and later unhide it
when you need it. First, select the column you want to hide.
Then click the ‘Format’ drop-down arrow form the ‘Cells’ group, and click ‘Hide
& Unhide’ -> ‘Hide Columns’. The column is now hidden from displaying and printing.
To unhide the column, click the column names to select the columns on both sides of the
hidden column, click the ‘Format’ drop-down arrow. Then click ‘Hide & Unhide’ -> ‘Unhide
Columns’. Hiding rows works exactly the same except
instead of selecting a column, you select the row you want to hide. Then click on the
‘Format’ drop-down arrow -> ‘Hide & Unhide’ -> ‘Hide Rows’.
I hope you enjoyed todays Help Desk TV. If you have a comment about this program, a question,
or a shortcut you would like to share with me, send us an e-mail message to feedback@helpdesktv.ca.
You can also join us on our new Windows Live Group at helpdesktv.groups.live.com where
you can ask a question, find info, and talk with me one on one with your computer problems.
Thanks for watching!