Sheet Selection Option - GONE

  • Thread starter Thread starter Lin
  • Start date Start date
L

Lin

I have a spreadsheet consisting of 4 sheets. But suddenly, I have lost the
ability to select sheets (Excel 2007: sheet selection used to appear at the
bottom of every sheet - now does not appear). Please tell me how to get
sheet selection back ... and many thanks.
Lin
 
Office button (top left),excel options, advanced (in the left pane) and
scroll to "display options for this workbook" and make sure "show sheet
tabs" is checked

--


Regards,


Peo Sjoblom
 
Hi Peo ...
Many thanks for quick response and accurate "fix".
I followed your directions exactly and find that the "show sheet tabs" is
already checked.
I hope you can spare a few more moments with another suggestion as I still
cannot select sheets and it is getting rather urgent. (First of the month,
you know ...)
Thanks again ...
Lin
 
Hi,

Since it seems very unlikely that you turned off the display of sheet tab
accidently, maybe you should maximize the workbook.

Cheers,
Shane Devenshire
 
Hello again ...
"Maximize" did not do it.
The last time I used this spreadsheet was one month ago and I gave up while
trying to priint. So - just now, I took a look at the print logic - and
there I found the following ...
FYI and a little help on a variation of the same problem: I chose the
"print" option from the Excel menu and then chose the top option from the
print pull down menu - I made sure it did NOT print but I did manaage to get
the Sheet selections back at the bottom of the screen by clicking on
"Normal" at the top of the Excel sheet. The sheet numbers came back at the
bottom of the sheet but ......Problem: it happened once for sure as I
describe it - but I can't make it happen again. I'm sure you know what is
happening and I hope you can tell me how to make it happen again and maybe
even how to get control of this thing.???
Many thanks for all your patience ...
Lin
 
Hey Peo ...
Please disregard the note preceding this one - I don't know how it happened,
but there are days when I do a truly superior job of screwing up.
Here is the solution to this nutty problem:
"View" tab at top of the Excel sheet
"Full Screen" also at the top of the Excel sheet - left end
What follows will take up the entire screen with the Sheet number tabs at
the bottom but there will be no obvious options to get back except for the
system commands along the very top of the display. Maximize will take us
back to original screen with Sheet numbers missing ...
Many thanks for your patience and your help ... I do appreciate it and will
come back soon with many other problems I find in Excel.
Lin
 
Just wondering what I did to offend somebody this time?
If I said somehting you don't like - APOLOGIES.
 
Back
Top