Microsoft Excel 2007 Quick Tips Unhide Hide a tab Zoom Home row cell
Posted: Tuesday, February 01, 2011
by James Banner
Open an Excel spreadsheet that you would like to work on & follow the tips below.
Hide a Tab
- Drag your cursor to the first tab and right click > select Hide
- Note *If you want to hide multiple tabs, hold CTRL key and left click the tabs you would like to hide.
- Drag your cursor between the hidden tab and right click > select Unhide
- If you want to unhide multiple tabs, use the CTRL key to select the first and the last tab > right click and selectUnhide
- To quickly zoom in or out, hold down the CTRL key and scroll the middle mouse button forward or backward. Really neat trick!
- If you’re at the end of your spreadsheet and you want to return back to A1 or the ‘default cell’, just simply hold the CTRL and Home keys and viola!!!
Some steps may be compatible with 2003 and previous versions.
This Article has been viewed 1,139 times. (Not updated in real-time.)
Top-level comments on this article: (5 total)Thanks, James, I learned something new - and you're right the quick zoom is a really neat trick!I am glad I could help. That's what I do.
Let me first install Microsoft Excel 2007, and then I will get back to you. He he!No problem. Take your time. I believe the instructions may be compatible with 2003.No problem. Take your time. I believe the instructions may be compatible with 2003.
I like well formatted click by click tutorialssHehe. It's the only way to virtually navigate.
Very nice info James. These tutorials are good I'm sure for anybody first getting started with excel, because when you first see it, it is very daunting, especially for older people that get scared easily.:-)Yes, you want to keep the audience in tune with what you're doing as well as providing simple, yet elegant tips and not overdue/fall short with your objective - which is to teach.
Thanks. I find it refreshing when something is made simple in this complex generation. God bless.I second that idea. I keep it simple and in lamens terms.
We want your comments! If you can read this, you don't have javascript enabled, so you can't use this comment system. Please enable javascript.