Page 1 of 1
[Solved] Sheet Tabs
Posted: Wed Jan 19, 2011 1:12 am
by Marioz
I have lost the sheet tabs on my spreadsheet. The sheets still exist which I access through Edit-Sheet-Select. I would really appreciate it if someone could tell me how to restore my sheet tabs.
Thank You
Re: Sheet Tabs
Posted: Wed Jan 19, 2011 1:16 am
by Villeroy
Somewhere in Tools>Options>Calc>View
Re: Sheet Tabs
Posted: Wed Jan 19, 2011 4:32 am
by Marioz
Thank you for your effort but was not successful
Re: Sheet Tabs
Posted: Wed Jan 19, 2011 4:52 am
by Rugslug
Maybe Format, Sheet, Show
Then a dialog pops up showing the hidden sheets....(crossing fingers)
Re: Sheet Tabs
Posted: Wed Jan 19, 2011 7:08 am
by Marioz
No, that didn't work either. I did learn that I am able to navigate between sheets using CTRL- Page Up or Page Down. I do appreciate the responses - thank you.
Re: Sheet Tabs
Posted: Wed Jan 19, 2011 9:20 am
by Charlie Young
Marioz wrote:No, that didn't work either. I did learn that I am able to navigate between sheets using CTRL- Page Up or Page Down. I do appreciate the responses - thank you.
If it's not hidden sheets or the Tools>Options setting, try
resetting your user profile.
Re: Sheet Tabs
Posted: Wed Jan 19, 2011 1:35 pm
by JohnSUN-Pensioner
Maybe so?
- Animated GIF - Allow animated in your browser
- RestoreTabs.gif (7.12 KiB) Viewed 10911 times
Re: Sheet Tabs
Posted: Thu Jan 20, 2011 12:33 am
by johntait
Hi
Despite what you said above, it should be under Tools-Options-OpenOffice.org Calc (you need to expand this by clicking on "+" and it will give you further options including "View"). Click on this "View" and a menu starting with "Visual aids" will come up - on the bottom right there is a heading Windows and under that should be a tick box for Sheet Tabs. Tick this,then click OK and the tabs should come back.
Re: Sheet Tabs
Posted: Thu Jan 20, 2011 1:07 am
by Marioz
Thank you very much, Johntait, that worked beautifully. When I first went in "sheet tab" was checked so I unchecked it, enterd the new setting and went back in and restablished it with the "sheet tab" checked and I am back to normal. I really appreciate all the responses I received from everyone. What a great resource. Happy New Year Everyone.
Sheet tabs & editing
Posted: Thu Mar 17, 2011 7:08 pm
by jagsfish
I have no Sheet Tabs and I cannot edit my spreadsheet. I can only scroll through the pages. Any suggestions? I have been using this program for several months and have not had a problem.
Thanks
Re: [Solved] Sheet Tabs
Posted: Thu Mar 17, 2011 7:36 pm
by Marioz
Please see johntait reply above - it worked for me. Good Luck.
Re: [Solved] Sheet Tabs
Posted: Thu Mar 17, 2011 9:25 pm
by Hagar Delest
Watch carefully the pic, it's an animated gif.
Re: Sheet Tabs
Posted: Thu May 26, 2016 2:36 am
by chuimuro
JohnSUN-Pensioner wrote:Maybe so?
RestoreTabs.gif
THANK YOU FOR THIS!!!
Re: Sheet Tabs
Posted: Wed Nov 13, 2019 10:34 pm
by appletreasures
johntait wrote:Hi
Despite what you said above, it should be under Tools-Options-OpenOffice.org Calc (you need to expand this by clicking on "+" and it will give you further options including "View"). Click on this "View" and a menu starting with "Visual aids" will come up - on the bottom right there is a heading Windows and under that should be a tick box for Sheet Tabs. Tick this,then click OK and the tabs should come back.
I had the same problem.
I followed your steps.
Sheet Tabs was ticked.
I toggled it off, and clicked OK.
Next I toggled it on, and clicked OK.
My sheet tabs reappeared.
Thanks for posting the solution.