Free Microsoft Excel 2013 Quick Reference

cannot see worksheet tabs

I made a spreadsheet for my sister and sent it to her in an email attachment. We both have Excel 2007 and all of the spreadsheet is displayed with the exception of the worksheet tabs. I had her go into the Excel options, advanced, display options and checked the box that says to show the tabs...it was already checked but still do not see the worksheet tabs. The vertical slide bar and horizontal slide bar are also "unseen" and I cannot figure out what the problem is. Any ideas? Did I advise her correctly or did I miss something pretty basic........................both of us are newbies to Excel. Appreciate any help you can offer...Thanks.


Post your answer or comment

comments powered by Disqus
Excel 2003. I have created an Excel workbook with multiple sheets. I can
see all the sheet tabs on my system without a problem. However, I am
emailing the workbook to someone with Excel 2003 as well, and he only sees
that last sheet when he opens it and cannot see the other sheet tabs. How
may I remdy this? Thanks for the help and God bless.
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org

Excel 2003. I have created an Excel workbook with multiple sheets. I can
see all the sheet tabs on my system without a problem. However, I am
emailing the workbook to someone with Excel 2003 as well, and he only sees
that last sheet when he opens it and cannot see the other sheet tabs. How
may I remdy this? Thanks for the help and God bless.
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org

Hi Guru or anyone who is more experience on Excel,
I've problem of reading Excel file in my PC now. My PC has Excel 2003 and PC spec. is common such as normal P4 computer.
When I open the attached excel file...

- I can open but cannot see any data on worksheet.

- Once open, cannot see any data on worksheet but can see the data in formula bar when I place cursor over data cell.

- But I can open and see all data in other people PC easily.

- I've reinstall the Excel 2003 also but no different.

What is the problem and help me asap?

Derek TL

With a specific worksheet, sometimes I cannot see the worksheet when I
open it unless "full screen" is toggled on.

Sometimes even with "full screen" toggled on, I cannot see the
worksheet when I open the worksheet.

I have not had this problem in the past.

The worksheet is 1 mg in size with multiple worksheets feeding into the
primary worksheet.

--
ckivela

I dio have a simple argument (Sum A17:L17). I cannot see the result in the
worksheet, however when I go through the function toolbar the result is
correct. Do you know what is causing this problem?

With a specific worksheet, sometimes I cannot see the worksheet when I
open it unless "full screen" is toggled on.

Sometimes even with "full screen" toggled on, I cannot see the
worksheet when I open the worksheet.

I have not had this problem in the past.

The worksheet is 1 mg in size with multiple worksheets feeding into the
primary worksheet.

--
ckivela

Microsoft Excel is no longer displayed at the top of the screen, and I can't
see my worksheet tabs at the bottom of the screen. Probably an easy fix but
I can't find it...

Does anyone know how to color code your worksheet tabs? Most of my workbooks may contain 20 worksheets & it gets very hard to see when they are all the same color. I would like to make my worksheet tabs stand out from other tabs. Is this possible??

hi Guys,

I've downloaded a file from another application, it's all good except that I can't see the tab at the bottom of the Worksheet. Even when I do Insert > Worksheet I can't see the tab. Any idea how can I display the tabs?

Thanks

I would like to see an option in Excel to put worksheet tabs in the left hand
column. With this arrangement one could see more woksheets at one time.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

In complex Excel spreadsheets, the current single line for worksheet tabs is
restrictive.

Instead, please consider including a second or third row option that will
allow for numerous worksheets to be accessible at one time.

This will save time instead of having to use the |< < > >| buttons.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Thanks, this was great and really easy.

"Chip Pearson" wrote:

> Vickie,
>
> You have to use a VBA macro to do this. See
> www.cpearson.com/excel/sortws.htm for example code.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
>
> "Vickie" > wrote in message
> ...
> > Is there a way to alphabetize Excel worksheet tabs without
> moving them all manually?
>
>
>

Allow for the worksheet tabs to be displayed on the vertical axis to allow
more tabs to be visiable at one time. Worksheets should be able to be
organized in an Outline format of tabs and sub-tabs that are expandable and
contractable.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

I'd like to be able to color code Excel worksheet tabs and be able to
highlight worksheet tabs.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

Using a formula, is there a way to display worksheet (tab names) in a cell?
For example, I have 3 worksheets with names One, Two and Three. In cell A1 in
each woksheet, I would want to see the worksheet name for whichever worksheet
I am viewing. I do not want the name to change in the cell each time I click
on one of the other two spreadsheets, similar to what happens with
=CELL("FILENAME"). I also do not want to see the entire path for the
worksheet.

I use multiple worksheets to track costs in my field. Sometimes with
multiple worksheets it can get cumbersome to track sheets that are
interdependent on one another. I thought it would be nice to be able to
color the worksheet tabs in a workbook with similar colors so as to be able
to more easily track which sheets work with one another.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

Excel should provide the ability to see multiple worksheets (tabs) at once.

I am currently using Excel 2003.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

I would find an interface similar to MS Words Document Map to be easier to
navigate than the worksheet tabs currently used.

While the tabs do have benefits (color coding, easy to reorganize, etc),
they are hard to navigate through to find the desired worksheet; especially
in a large workbook when the sheet names are long.

It would be easier if the tabs were organized into a list on the left side
of the screen (like the Document Map) rather than scrolling sideways through
a horizontal list. To save monitor real estate these could also be shown or
hidden through the use of the View menu on the Standard Toolbar.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...ic.excel.setup

I have several old Excel 2003 files in which all worksheet tabs are hidden.
In Excel 2003, this was easily turned on or off in the options dialog box. I
cannot find a way to turn these tabs back on in Excel 2007, nor could I find
info on how using online help. Has anyone found a way to do this?

I do not know if newer versions of Excel than I have have this function, but
in working with a budget in Excel, it sure would be a nice feature to be able
to "stack" in a hierarchy the worksheet tabs at the bottom, instead of
scrolling horizontally for hundreds of feet! In other words, I want to have
a Worksheet "Travel Budget" and instead of having each month's in a
horizontal tab, I could scroll up and down from a "Master" worksheet to
sub-worksheets ties to the master...instead of just adding worksheet after
worksheet in an ever growing hard to manage row.....

--
JMcC

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Hello,

it will be nice if i can format the Worksheet tabs in multiple rows.
Currently tabs of worksheets are linear and sometimes continue forever.

This results:
- searching for a worksheet hard.
- scrolling to a worksheet take multiple clicks
- does not allow organization of worksheet. as in sometime you may have a
set of tabs that fall under the same group. let's say Marketing information,
versus sales information in the same workbook. you may have multiple
worksheets under each one of these. it will be easier to understand the
structure of the workbook if one can put to rows of tabs: marketing and
sales. and under each one can have as many other as necessary.

thanks,

fawzi

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

I would like to be able to view worksheet tabs in multiple lines like in some
of the tool bar menus. That way one can view more sheets at the same time
instead of scrolling back and forth across the tabs all the time.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

I need to create a list in Word of the names on (20) Excel worksheet tabs. I
can find the list, but I cannot copy and paste.

I have a spreadsheet that is being used as an application to perform account
mapping conversions. I need to update, the source data which appears to be
in a hidden sheet. Normally I would unhide the sheet and updated the data,
but with this application the guy who wrote it has some how hidden the
worksheet tabs control at the bottom of the window.

I have viewed the VBA and see no reference to the tabs in it either...any
ideas?


No luck finding an answer? You could always try Google.