ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hide Worksheet Tabs (https://www.excelbanter.com/excel-discussion-misc-queries/159137-hide-worksheet-tabs.html)

Beep Beep

Hide Worksheet Tabs
 
Is there a way to HIDE a few worksheet tabs and still show all the others. I
know you can hide all of them, however I just want to hide a couple.

Dave Peterson

Hide Worksheet Tabs
 
You can hide each sheet individually
select the worksheet tab
Format|Sheet|hide

But you can also group the sheets to hide first.
Click on the first tab
ctrl-click on subsequent
then
format|sheet|hide

At least one sheet has to be visible, though.

Beep Beep wrote:

Is there a way to HIDE a few worksheet tabs and still show all the others. I
know you can hide all of them, however I just want to hide a couple.


--

Dave Peterson

Jim Thomlinson

Hide Worksheet Tabs
 
Format|Sheet|Hide
--
HTH...

Jim Thomlinson


"Beep Beep" wrote:

Is there a way to HIDE a few worksheet tabs and still show all the others. I
know you can hide all of them, however I just want to hide a couple.



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

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