In today's podcast, a quick way to hide the column headers, and a row height in inches. Episode #1186 shows you how.
...This blog is the video podcast companion to the book Learn Excel 97-2007 from MrExcel.
...This blog is the video podcast companion to the book Learn Excel 97-2007 from MrExcel.
Transcript of the video:
MrExcel podcast is brought to you by “Easy-XL”!
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Today here’s a great question sent in by Joan, I got a call from Joan, Joan had Excel up on her screen, I'm on the phone listening to Joan, and Joan says “I know how to change column widths, you drag, but it's driving me crazy.
I can't figure out, it's not letting me drag to change the column lists.” And I said “OK, you know, tell me what the top row that you can see is.” “I don't know, there are no row numbers.” I said “So above the top cell with data you have no column letters?” “No!” Like wow, that's really weird.
So I walked Joan through File, and then Excel Options, and then going to Advanced and, you know, we have to come down here and find where it is, you know, the headers and footers.
And it had been turned off, you know, and Joan’s like “Well, how did that happen?” I said “Did you go into Excel Options?” “No, I haven't been in Excel Options.” You know how it goes, alright, and so I started thinking, well, there must be some way, some shortcut key to turn those headers on and off.
So we started poking around, it's actually back here on the View tab, check this out, very cool way to turn headers and footers off very easily.
Now before I figured that out, I knew that Joan just wanted to change the information.
So I, you know, said “Hey, look, just basically go into Home, and then over here Format, and then Row Height.” And I said “It's probably going to have a row height of about 13 or so, and I need you to up that to 26.” And she said “No, I have 0.21 inches.” I said “What?” You know, I actually thought she was crazy, 0.21 inches, there's no way, I've never seen it., there’s always, you know, some number of points or something like that.
I said “Well just put 26 in there and click OK.” Alright, the specified row height is too large, I could not figure out what's going on, have you ever seen anything like we just had there?
Format, Row Height reporting in inches instead of reporting in the, you know, the point value that we always do.
Well, it turns out that you get those row heights when you're in this Page Layout mode down here.
So next to the Zoom slider we have 3 modes, we have Normal, we have Page Break Preview which has been there forever, and then the new one in Excel 2007 is Page Layout.
And this is cool, because it lets you see where your headers and footers are going to be, where the margins are, you can actually change the margins right here on the screen, all very cool.
But one of the side effects of that, apparently, is that when we go into Format, Row Height, it's not showing us 26 or 13 or any of the numbers we're used to, it's showing us the number of inches.
So there you go, next time you're doing a tech support call with your mom or someone like that, and they start saying that they're seeing things in inches, and don't have the column headers.
Couple of cool things there in Excel 2007, things I'd never really kind of discovered on my own until someone called me up with a bizarre problem.
So, there you have it, thanks for stopping by, we'll see you next time for another netcast from MrExcel!
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Today here’s a great question sent in by Joan, I got a call from Joan, Joan had Excel up on her screen, I'm on the phone listening to Joan, and Joan says “I know how to change column widths, you drag, but it's driving me crazy.
I can't figure out, it's not letting me drag to change the column lists.” And I said “OK, you know, tell me what the top row that you can see is.” “I don't know, there are no row numbers.” I said “So above the top cell with data you have no column letters?” “No!” Like wow, that's really weird.
So I walked Joan through File, and then Excel Options, and then going to Advanced and, you know, we have to come down here and find where it is, you know, the headers and footers.
And it had been turned off, you know, and Joan’s like “Well, how did that happen?” I said “Did you go into Excel Options?” “No, I haven't been in Excel Options.” You know how it goes, alright, and so I started thinking, well, there must be some way, some shortcut key to turn those headers on and off.
So we started poking around, it's actually back here on the View tab, check this out, very cool way to turn headers and footers off very easily.
Now before I figured that out, I knew that Joan just wanted to change the information.
So I, you know, said “Hey, look, just basically go into Home, and then over here Format, and then Row Height.” And I said “It's probably going to have a row height of about 13 or so, and I need you to up that to 26.” And she said “No, I have 0.21 inches.” I said “What?” You know, I actually thought she was crazy, 0.21 inches, there's no way, I've never seen it., there’s always, you know, some number of points or something like that.
I said “Well just put 26 in there and click OK.” Alright, the specified row height is too large, I could not figure out what's going on, have you ever seen anything like we just had there?
Format, Row Height reporting in inches instead of reporting in the, you know, the point value that we always do.
Well, it turns out that you get those row heights when you're in this Page Layout mode down here.
So next to the Zoom slider we have 3 modes, we have Normal, we have Page Break Preview which has been there forever, and then the new one in Excel 2007 is Page Layout.
And this is cool, because it lets you see where your headers and footers are going to be, where the margins are, you can actually change the margins right here on the screen, all very cool.
But one of the side effects of that, apparently, is that when we go into Format, Row Height, it's not showing us 26 or 13 or any of the numbers we're used to, it's showing us the number of inches.
So there you go, next time you're doing a tech support call with your mom or someone like that, and they start saying that they're seeing things in inches, and don't have the column headers.
Couple of cool things there in Excel 2007, things I'd never really kind of discovered on my own until someone called me up with a bizarre problem.
So, there you have it, thanks for stopping by, we'll see you next time for another netcast from MrExcel!
