Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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 that there is a missing letter E here. Now, I get data all the time from different sources and one of the first things I check for, is to see if there are any hidden columns.
You can also by the way, hide more than one column at the same time. If I'm about to print this and I don't want to print the Department column and the Salary column--columns C and H-- I'll click column C and then with the Control key held down, click column H. Both of those are selected, then I'll right-click and go to Hide. Right-clicking often is the fastest way to Hide a column. Now, we have a number of different hidden columns. If we're printing this data, we're not going to see any gaps. I'm going to press Ctrl+F2 here, a quick way to get a print preview.
And there we are, and we see the data there without the columns that are hidden. There's no gaping hole in the printing itself, so it doesn't draw attention to the fact that we're not printing all the data. Press Esc to get out of here and we're back to our normal view. Of course the question comes up, how do you get back the hidden column? If you simply want to bring back one of the hidden columns--I want to bring back column E--we can drag across the surrounding columns. Click and drag across columns D and F and then do one of two things, either right-click on Unhide-- --that's probably the most logical and reasonably fast way to get there-- let me undo that and show you another method.
After selecting the columns in question, double-click the boundary between them or in fact any column boundary that's visible up there. Double-click, and that brings back the data as well. Let me undo that again. What if we've got multiple columns hidden? And we do. Column C is hidden, column E is hidden. There could be some others. What if there are some other columns off to the right we're not sure of? I don't want to check them all out manually maybe. Click in the upper left corner to select the entire worksheet and then simply double-click any column boundary-- like this--double-click and all the hidden columns are back.
Let me undo that again. Another way is--after selecting the entire worksheet--simply right-click any column, and choose Unhide, and all hidden columns will return. There certainly will be times when we want to hide rows as well. Maybe in the list that we're about to print here, it just so happens that we know that Michael Ashley here has left the company, we still want to keep the record here; we don't necessarily want to show it as we print this. Same thing has happened with Heidi Barker here. So once again, we'll use the Control key to select both of those and then right-click and Hide; so we're not seeing those. And here too as I press Ctrl+F2, if we look at the printed data, we're not seeing those names in the list. Escape from here.
And so if we were to print the information, those names would not appear. As you might imagine, we can bring back the hidden rows by clicking the upper left-hand corner; simply right-clicking any of these and choosing Unhide; or as you might have guessed, we could simply have double- clicked on the boundary of any two rows. So, as we've seen, sometimes we want to hide columns, other times we hide rows. The feature is easy to get to, we do it for a number of different reasons. It's one more tool in controlling the display of our worksheets as we work with Excel.
Get unlimited access to all courses for just $25/month.Become a member
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.