Tabs in MS Excel

Is there a way to display multiple tabs in MS Excel over two or more rows? I have many tabs and switching between them, while not seeing all of them at once, is cumbersome.


Would you like to answer or comment?

Sign up for a free account, or sign in (if you're already a member).
Answer this question
  • # Posted 2 years ago
  • 1063 views
Share Send to a friend Watch Report
 

Best Answer

 
EscApe
18 answers
27 thumbs up

As it is not possible in current Excel versions to get tabs in multiple rows, I would recommend the same solution that yoavdothan did.

But here's another solution, if you want to tinker and have free space in your sheets:

Make a hyperlink to Sheet2 (select Place in this document from left, select sheet you want this link to open and so on) to cell B65535, and link to Sheet3 to cell C65535 and so on.

After adding links, split screen so that you can see hyperlinks while using your worksheet.

Copy hyperlinks to other sheets. Remember to add link to Sheet1

Downside of this one is that if you use also many columns, hyperlinks will not be shown on screen when it has been scrolled to right and you can't add another horizontal split to your sheets.

Posted 2 years ago ( permalink )
In reply to drabsv's question
EscApe was invited by Yedda to answer this question.

Rated as
Best Answer
0
5
  Report Abuse  

Helpful?

line
line
line


 

All Answers

Order by
 
yoavdothan
618 answers
1147 thumbs up

Put your mouse on the lower left part of the excell screen then press the right button of the mouse.

You will see many tabs and you can choose any of them.

Good luck!
Posted 2 years ago ( permalink )
In reply to drabsv's question
Rated as
#2 out of 3
0
0
  Report Abuse  

Helpful?

line
line
line



 

I have tried that but it is still too inconvenient.

Posted 2 years ago ( permalink )
In reply to yoavdothan's answer
Rated as
#3 out of 3
0
0
  Report Abuse  

Helpful?

line
line
line



Sign in to participate

Got an answer for drabsv? Would you like to comment on the posted answers, or vote for the one which you think is the best?

Sign up for a free account, or sign in (if you're already a member).

Explore Related Questions

Other people asked questions on similar topics, check out the answers they received:


Excel: switching tabs with the keyboard

Is it possible to switch between tabs in excel without using the mouse? If it's not possible by default, can a key combination be ...
Submitted by Matthew 2 years ago
  • 4 answers
  • viewed 1943 times

Last answer posted 2 months ago by docster


Numbering Cells in Excel

Hello, I am using MS Excel and I need to create a column with consecutive numbering. That is in Cells A2-A102 I will have the ...
Submitted by webmanoffesto 11 months ago
  • 5 answers
  • viewed 873 times

Last answer posted 10 months ago by gradnin


Excel 2007 - currency format

Excel 2007 automatically converts numerical values into the currency format. Every time I set the cells to "general" format it ...
Submitted by drabsv 2 years ago
  • 2 answers
  • viewed 699 times

Last answer posted 2 years ago by drabsv



» More...

Explore Related Posts in Forums

Spreadsheets - Office 2000 Excel

to crash computers on a regular basis. And you can't plot multiple series on a logarithmic or semi destroying longer headers and footers that you created with previous software. Too many rows

Excel Spreadsheets

and insert one into a drawing. Is this normal? Also, why do the hidden columns and rows in my spreadsheet Re: Excel Spreadsheets what add-on are you trying to do without? -- Dean Saadallah...

spreadsheets on N810?

Can anyone tell me how I can do simple spreadsheet stuff on the 810? Apparently gnumeric does it but I can't get my head round how to install it. Ideally I'd like to import excel files and edit them
» More...
Powered by
Feed - Subscribe to changes to this Q&A Blog

Explore Related Videos

Computer Funding from BlueHippo, BlueHippo...

: BlueHippo, BlueHippo Computers, Bad Credit Computer Financing, Approval Guaranteed: Get computer funding with peace of mind at BlueHippo, BlueHippo Computers, Bad Credit Computer Financing, Approval Guaranteed visit http://www.BlueHippo.com . BlueHippo, BlueHippo Computers, Bad Credit Computer Financing, Approval Guaranteed is the nation’s leading direct response merchandiser. To get quality brand new merchandise delivered right to your door from BlueHippo, BlueHippo Computers, Bad Credit Computer Financing, Approval Guaranteed visit http://www.BlueHippo.com today. You are guaranteed to be approved with no credit check. BlueHippo, BlueHippo Computers, Bad Credit Computer Financing, Approval Guaranteed offers payment plans you can afford with no big upfront cost and hidden charges. BlueHippo, BlueHippo Computers, Bad Credit Computer Financing, Approval Guaranteed, BlueHippo, BlueHippo Computers, Bad Credit Computer Financing, Approval Guaranteed, BlueHippo, BlueHippo Computers, Bad Credit Computer Financing, Approval Guaranteed, BlueHippo, BlueHippo Computers, Bad Credit Computer Financing, Approval Guaranteed, BlueHippo, BlueHippo Computers, Bad Credit Computer Financing, Approval Guaranteed, BlueHippo, BlueHippo Computers, Bad Credit Computer Financing, Approval Guaranteed, BlueHippo, BlueHippo Computers, Bad Credit Computer Financing, Approval Guaranteed

Bluehippo funding complaints false...

: Bluehippo funding complaints false advertisement computers & accessories: Get computer funding with peace of mind at Bluehippo funding complaints false advertisement computers & accessories visit http://www.BlueHippo.com . Bluehippo funding complaints false advertisement computers & accessories is the nation’s leading direct response merchandiser. To get quality brand new merchandise delivered right to your door from Bluehippo funding complaints false advertisement computers & accessories visit http://www.BlueHippo.com today. You are guaranteed to be approved with no credit check. Bluehippo funding complaints false advertisement computers & accessories offers payment plans you can afford with no big upfront cost and hidden charges. Bluehippo funding complaints false advertisement computers & accessories, Bluehippo funding complaints false advertisement computers & accessories, Bluehippo funding complaints false advertisement computers & accessories, Bluehippo funding complaints false advertisement computers & accessories, Bluehippo funding complaints false advertisement computers & accessories, Bluehippo funding complaints false advertisement computers & accessories, Bluehippo funding complaints false advertisement computers & accessories

Street Team '08: Seal of Approval

We use computers a lot, and they use a lot of energy. Two recent grads have come up with a way to offset your power usage and show support for the green movement. Produced for MTV's Choose or Lose Street Team '08 at chooseorlose.com. (Sept. 29)

Bluehippo funding complaints false...

: Bluehippo funding complaints false advertisement computers & accessories: Get computer funding with peace of mind at Bluehippo funding complaints false advertisement computers & accessories visit http://www.BlueHippo.com. Bluehippo funding complaints false advertisement computers & accessories is the nation’s leading direct response merchandiser. To get quality brand new merchandise delivered right to your door from Bluehippo funding complaints false advertisement computers & accessories visit http://www.BlueHippo.com today. You are guaranteed to be approved with no credit check. Bluehippo funding complaints false advertisement computers & accessories offers payment plans you can afford with no big upfront cost and hidden charg