From the course: Excel 2013 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Hiding and unhiding rows and columns

Hiding and unhiding rows and columns - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Hiding and unhiding rows and columns

“

You can hide a column to simply get the data out of the way for a while because you don't use it very often, or maybe you're about to print data and you just don't need to print a certain column. And similarly, although less likely, you can do the same kind of thing with rows. We're looking at a worksheet called Hide -Unhide in the 05-Layout workbook, and maybe we are about to print this data and it's just not important for us, for example, to show the Hire Date. So, what can we do? We can get to the Hide-Unhide feature on the Home tab in the Cells group, under Format. This is not the fastest way, but for the record, on the Format button, you'll see the choice Hide & Unhide and we could then slide on to "Hide Columns". When you hide a column, there's a slight visual difference and this might not be clear on the movie as you're watching it right now, but the columns separated between D and F is slightly different. And of course, if you simply remember your alphabet, you'll recognize…

Contents