2
votes
0answers
14 views

In Excel, Can I have two rows of (worksheet) tabs for my workbook?

I'm using Excel (2013). I have a workbook with numerous different worksheets, and would like to have them take up two rows of worksheet tabs rather than just one. Can I achieve this somehow? I can't ...
0
votes
1answer
62 views

Using the contents of a cell to refer to a worksheet name in a formula

I have the names of dealers along with the associated data located in various tabs in a particular workbook. I wrote a sumif formula for one and included the names of the dealers in the cell to the ...
1
vote
0answers
131 views

How do I create a master list in excel that displays the most recent entry from each tab on a worksheet?

I'm creating a workspace (on excel 2003) with three worksheets: active, inactive, and master-list. Tabs will move between active and inactive, based on whether or not I'm currently focused on them. I ...
3
votes
4answers
12k views

How can I set a keyboard shortcut to switch between Excel tabs?

I find the Ctrl+ PgDn/PgUpnot good enough. When I have a lot of tabs it's very annoying to get to the right tab, or move it and change the order, which is sometimes important. I need Excel to switch ...
0
votes
1answer
502 views

Tabs automatically from list

Excel 2007: I need to make tabs automatically and place the tab name in a cell on each new tab. What I have below, from a command button, will make the new tab. How can it read from a list of names ...
1
vote
3answers
3k views

Move the Worksheet Tabs in Excel 2010 to the top of the Window

It is standard that when you open MS Excel, the tabs for each worksheet appear along the bottom of the window (as "Sheet1", "Sheet2", "Sheet3", etc). I would prefer those tabs to be on top of the ...
0
votes
1answer
83 views

Add another worksheet in an Excel worksheet

Is it possible to include an additional set of worksheets (i.e. "tabs") into an already existing worksheet in Excel?