ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to Unhide sheets (https://www.excelbanter.com/excel-discussion-misc-queries/35579-how-unhide-sheets.html)

pwermuth

How to Unhide sheets
 

How can I unhide hidden worksheets?


--
pwermuth
------------------------------------------------------------------------
pwermuth's Profile: http://www.excelforum.com/member.php...o&userid=24997
View this thread: http://www.excelforum.com/showthread...hreadid=387601


Alan

Format Sheets Unhide and select which sheet to unhide, assuming the
workbook isn't protected,
Regards,
Alan.
"pwermuth" wrote in
message ...

How can I unhide hidden worksheets?


--
pwermuth
------------------------------------------------------------------------
pwermuth's Profile:
http://www.excelforum.com/member.php...o&userid=24997
View this thread: http://www.excelforum.com/showthread...hreadid=387601




BenjieLop


pwermuth Wrote:
How can I unhide hidden worksheets?



Click on *Format/Sheet/Unhide*

Highlight the worksheet name that you want to unhide

Click *OK*

and now, you are all set to do what you want with the worksheet!!!

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=387601


pwermuth


Yes, I am a moron. I forgot that I had protected the workbook and was
wondering why "unhide" was shaded.


--
pwermuth
------------------------------------------------------------------------
pwermuth's Profile: http://www.excelforum.com/member.php...o&userid=24997
View this thread: http://www.excelforum.com/showthread...hreadid=387601


Alan

Glad it worked,
Regards,
Alan.
"pwermuth" wrote in
message ...

Yes, I am a moron. I forgot that I had protected the workbook and was
wondering why "unhide" was shaded.


--
pwermuth
------------------------------------------------------------------------
pwermuth's Profile:
http://www.excelforum.com/member.php...o&userid=24997
View this thread: http://www.excelforum.com/showthread...hreadid=387601





All times are GMT +1. The time now is 03:38 PM.

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