ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to unhide worksheet tabs in Excel 2007? (https://www.excelbanter.com/excel-discussion-misc-queries/156668-how-unhide-worksheet-tabs-excel-2007-a.html)

mfr

How to unhide worksheet tabs in Excel 2007?
 
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?

Ron de Bruin

How to unhide worksheet tabs in Excel 2007?
 
Hi mfr

Office buttonExcel Options
Advanced...Display options for this workbook

info on how using online help


Open Help
Click in the bottom right corner on Offline and change it


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"mfr" wrote in message ...
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?


mfr

How to unhide worksheet tabs in Excel 2007?
 
Thank you very much! That's exactly what I was looking for!

"Ron de Bruin" wrote:

Hi mfr

Office buttonExcel Options
Advanced...Display options for this workbook

info on how using online help


Open Help
Click in the bottom right corner on Offline and change it


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"mfr" wrote in message ...
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?




All times are GMT +1. The time now is 11:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com