« Website editing tips: Shift+Enter and Paste as Plain Text | Main | Office 365 Mail Clutter Feature »

Working with Excel’s tabs

Excel-2010-logo

 Until recently, I had a pretty limited understanding of some of the options that are available with Excel’s tabs: add, remove and rename. Here are some new tab ‘tools’: color coding, quick pick list and making alltabs go away.

In the past, a typical set of tabs might look like what's below. The tabs had basic labeling. 

T0

 

What if you could color code your tabs? You can.

  • In Excel, select Format from the Home tab.
  • Select Tab color from the Organize Sheets section.
  • Select a color from the Theme Colors matrix
  • Note: You’ll only be able to see the results of your work after you make another tab the ‘active’ tab.

T1


What if you had a tab pop up list and you could just jump to a specific tab? You can.

  • Excel has a series of arrows in the lower left hand corner.
  • Right click any one of them and a tab pick list will pop up.
  • Select the tab of interest in the list and Excel will take you there.

T2


But wait, there’s more!

What if you wanted more Excel real estate and wanted your tabs to ‘go away’ completely. You can.

Select File, Options, Advanced and then remove the check from Show sheet tabs in the Display options for this workbook section.

T5

Comments

Feed You can follow this conversation by subscribing to the comment feed for this post.

The comments to this entry are closed.