ASP.NET - Excel tabs - Asked By sachin s on 13-Jun-12 02:16 PM

hi,
How to hide all the tabs in the bottom of the excel sheet & also how to hide all the left hand row numbers in excel sheet.

Waiting for reply

Advanced thanks
Sachin S

In excel 2003, you would need to go to "Tools" menu. And then select "Options" and then go to "View" tab. 
Scrolldown to Windows options, and then you will find an option to select or deselect the "sheet tabs". 

However, in Excel 2007 and greater,  you will have to go to Excel options under the main ribbon, and then choose Advanced. To your right scroll down to the two options highlighted below. One is to hide the sheet tabs, and the second hides row and column headers. There is no way to hide the row header alone.



Hope this helps..

To hide the Tabs FOLLOW THESE steps-

go to

Tools->
Options->View

NOw  uncheck Sheet Tabs checkbox.

Try this and let me know.

HI...Sachin,


you just have to use the below shortcut key to hide or unhide the tabs from the bottom:

ALT + o,h,h to hide the active sheet.

ALT + o,h,u and select the sheet to unhide.

and to hide and unhide the left side Row numbers....

go to the page layout ---> and uncheck the heading view See the below screenshot:




It will be easy for you to hide or unhide...when you are working on it......

Thanks al lot

Sachin S