#1   Report Post  
Junior Member
 
Location: Vancouver
Posts: 8
Default Hiding tabs in Excel

Hi folks,

Looking to hide a few tabs in Excel. Quite simply, so they don't show up along the bottom of my worksheet. Is there any way of doing this?

Thanks :)
  #2   Report Post  
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by benallen105 View Post
Hi folks,

Looking to hide a few tabs in Excel. Quite simply, so they don't show up along the bottom of my worksheet. Is there any way of doing this?

Thanks :)
Yup. You should be able to right click the tab and select hide.
However, they can be unhidden by the user unless you protect the workbook too.

Hope that helps.

S.
  #3   Report Post  
Junior Member
 
Location: Vancouver
Posts: 8
Default

Quote:
Originally Posted by Spencer101 View Post
Yup. You should be able to right click the tab and select hide.
However, they can be unhidden by the user unless you protect the workbook too.

Hope that helps.

S.
Hi Spencer,

Thanks! Unfortunately I don't have the option to Hide when I right click on the tabs?
  #4   Report Post  
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by benallen105 View Post
Hi Spencer,

Thanks! Unfortunately I don't have the option to Hide when I right click on the tabs?
Which version of Excel are you using??
  #5   Report Post  
Junior Member
 
Location: Vancouver
Posts: 8
Default

Quote:
Originally Posted by Spencer101 View Post
Which version of Excel are you using??
Excel 2003


  #6   Report Post  
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by benallen105 View Post
Excel 2003
In that case, select the tab you wish to hide, then select the "Format" drop down menu, then "Sheet", then "Hide". Et voila! :)
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hiding Tabs newguy Excel Programming 14 September 16th 08 05:49 PM
Hiding Tabs jordanpcpre Excel Discussion (Misc queries) 7 July 7th 08 09:08 PM
Hiding Tabs jdawg Excel Programming 1 June 24th 05 03:53 PM
Hiding Tabs Nash Excel Programming 2 June 21st 05 06:20 PM
Hiding Tabs Greg B[_4_] Excel Programming 3 March 8th 05 02:08 PM


All times are GMT +1. The time now is 12:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"