Tech Tips Home
The Best Tech Tips And Daily Deals
Newsletter On The Internet!

WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Like what you see here? Subscribe to the Tech Tips newsletter!   Email: Subscribe

MS Excel: The F6 Key – Worksheet, Ribbon, Zoom, Worksheet, Ribbon, Zoom

Wednesday, July 6th, 2011 by | Filed Under: MS Excel, MS Office Help

Here’s a little trick for those of you who are dedicated to minimizing the amount of time you use with the mouse when working in Excel.

Today we’re looking at the F6 key and the tricks it has up its sleeve.

In Excel the F6 key rotates between 3 areas of your window… the worksheet itself, the Ribbon and the Zoom controls in the bottom right corner of the status bar.

Like you couldn’t have guessed that from the title… moving on…

Using the F6 key between these items is a fast way to gain control of that area to then use the keyboard to accomplish the task you need done.

It’s obvious that rotating to the worksheet will let you continue to work but let’s look at the other two.

First let’s examine what you get when you use the F6 key to activate the Ribbon.

Yep, that Ribbon definitely looks different from what we usually see. It’s the little numbers and letters above all the commands.

Once the Ribbon is activated like this you can simply use the Alt key with whatever number/letter is listed to access first the tab of the ribbon or a command from the Quick Access Toolbar. Then you’ll use the keys again to use a command from a tab.

You’ll find that instead of plastering all the letters at once Excel will change them as you navigate down towards the command you need making it a much easier to use feature.

When we use the F6 key to navigate to the Zoom controls you’ll be sent to this areas of your status bar.

Here you use the arrow keys to navigate to the part of the controls you need and the use Enter to select it.

This means that you can change the View of the worksheet (the 3 icons to the left of the slider) or arrow over to the + and buttons to increase or decrease the zoom by 10% each time you hit the Enter key.

That’s really all there is to it… the F6 key can be used to access virtually anything you may need to use.




Tags: , , , ,

Leave a Reply

Like these tips? Get them for FREE in your email!

WorldStart's Tech Tips Newsletter

  • Tech Tips Daily - Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

  • Tech Tips Weekly - If you don't want our Tech Tips newsletter every day, then sign up for this weekly newsletter to get the best information of the week. Sent on Fridays.

Other Newsletters

  • WorldStart's Daily Deals - Every week, we send out great deals in our Daily Deals newsletter. Many of these deals are exclusively for our Daily Deals newsletter subscribers and can't be found with our regular specials.

  • Just For Grins - Each issue includes a couple clean jokes, some funny quotes, and a hilarious reader's story. Newsletter is sent five days a week.

Enter Email Address:


Your e-mail address is safe with us!
We only use it to send you the newsletters you request. It is NEVER disclosed to a third party for any reason, ever! Plus, if you decided you don't like our newsletters (don't worry, you'll love them), unsubscribing is fast and easy.

Free Newsletter Signup

Tech Tips Daily

Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

Tech Tips Weekly

The week's best in tech and computer help. Get your issue sent to your email every Friday!

WorldStart's Daily Deals

The very best deals on the Internet! Get a new set of incredible sales every day of the week!

Just For Grins

Clean jokes, funny quotes, and hilarious comics. Sent 5 times a week straight to your email.


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive