ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Hide an entire tab. (https://www.excelbanter.com/excel-worksheet-functions/80069-hide-entire-tab.html)

ChuckF

Hide an entire tab.
 
I have a shared spreadsheet, which houses raw data on the second tab.
I don't want everyone to be able to see this data. I know that I can
hide the cells that contain the data, but I was curious to know if I
could hide the entire tab, and make it appear that the tab doesn't even
exist.

Any thoughts?


Peo Sjoblom

Hide an entire tab.
 
Formatsheethide


--

Regards,

Peo Sjoblom


"ChuckF" wrote in message
ps.com...
I have a shared spreadsheet, which houses raw data on the second tab.
I don't want everyone to be able to see this data. I know that I can
hide the cells that contain the data, but I was curious to know if I
could hide the entire tab, and make it appear that the tab doesn't even
exist.

Any thoughts?




Al

Hide an entire tab.
 
With the sheet active, click on Format, then sheet then hide.
Thanks!

"ChuckF" wrote:

I have a shared spreadsheet, which houses raw data on the second tab.
I don't want everyone to be able to see this data. I know that I can
hide the cells that contain the data, but I was curious to know if I
could hide the entire tab, and make it appear that the tab doesn't even
exist.

Any thoughts?



Duke Carey

Hide an entire tab.
 
With the data tab active use
FormatSheethide

"ChuckF" wrote:

I have a shared spreadsheet, which houses raw data on the second tab.
I don't want everyone to be able to see this data. I know that I can
hide the cells that contain the data, but I was curious to know if I
could hide the entire tab, and make it appear that the tab doesn't even
exist.

Any thoughts?




All times are GMT +1. The time now is 02:58 AM.

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