Justin asks how to hide columns in Excel 2007. Finding the command on the 2007 ribbon is a little tough, but Episode 689 shows a way to invoke any Excel 2003 command in Excel 2007.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
Welcome back to the MrExcel netcast.
I'm Bill Jelen.
Today a question sent in by Justin and we're gonna start getting more and more questions like this as more and more companies start switching over to Excel 2007 this year.
Justin said yeah, I need to hide columns and unhide columns, it doesn't seem like it's in there and I admit in Excel 2007 it's frustrating when you're trying to find a command you trying to figure out there is no Edit tab of the ribbon, where you know where would they have put this is it under View.
Well, most of the important stuff is on Home.
Unfortunately, especially if you have a screen that's only 1024, why you're kind of stuck here with tiny little icons that lead to drop downs.
It turns out that we have to go to format which is kind of the old menu Format, Row hide and then Visibility, Hide & Unhide and then Hide Rows or Hide Columns.
So, you can get to this using that method.
Now, if you know where something was in Excel 2003, and you still have excel 2003 on the machine.
I want to show you a cool trick. We can go to Format and then Row and then Hide or Unhide and if you look the O in format is underlined, and then the R in row is underlined and then the H in hide is underlined.
So, that's 0, R, H was the old keyboard shortcut in Excel 2003, we could use Alt+O our h to do that well in 2007 it's the exact same thing even though there is no format anymore.
Just choose the rows and then Alt+O, and it says hey you're using one of the old keyboard shortcuts keep going R H will do the command of Format row hide.
To unhide Alt+O+R+U, for unhide and Excel implements that.
Works great if you knew the old keyboard shortcuts, sometimes when I'm just desperate I can't find it I'll go back to Excel and figure out what the old keyboard shortcut was and then Excel 2007 implement the new keyboard shortcut, not the best way, but certainly a way to figure out where those commands are hiding.
If you just simply can't find them. Oh there you have it.
Thanks for stopping by.
We'll see you next time for another netcast from MrExcel.
I'm Bill Jelen.
Today a question sent in by Justin and we're gonna start getting more and more questions like this as more and more companies start switching over to Excel 2007 this year.
Justin said yeah, I need to hide columns and unhide columns, it doesn't seem like it's in there and I admit in Excel 2007 it's frustrating when you're trying to find a command you trying to figure out there is no Edit tab of the ribbon, where you know where would they have put this is it under View.
Well, most of the important stuff is on Home.
Unfortunately, especially if you have a screen that's only 1024, why you're kind of stuck here with tiny little icons that lead to drop downs.
It turns out that we have to go to format which is kind of the old menu Format, Row hide and then Visibility, Hide & Unhide and then Hide Rows or Hide Columns.
So, you can get to this using that method.
Now, if you know where something was in Excel 2003, and you still have excel 2003 on the machine.
I want to show you a cool trick. We can go to Format and then Row and then Hide or Unhide and if you look the O in format is underlined, and then the R in row is underlined and then the H in hide is underlined.
So, that's 0, R, H was the old keyboard shortcut in Excel 2003, we could use Alt+O our h to do that well in 2007 it's the exact same thing even though there is no format anymore.
Just choose the rows and then Alt+O, and it says hey you're using one of the old keyboard shortcuts keep going R H will do the command of Format row hide.
To unhide Alt+O+R+U, for unhide and Excel implements that.
Works great if you knew the old keyboard shortcuts, sometimes when I'm just desperate I can't find it I'll go back to Excel and figure out what the old keyboard shortcut was and then Excel 2007 implement the new keyboard shortcut, not the best way, but certainly a way to figure out where those commands are hiding.
If you just simply can't find them. Oh there you have it.
Thanks for stopping by.
We'll see you next time for another netcast from MrExcel.
