Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to show sheet tab bar in excel 2010

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 02-01-2011
Member
 
Join Date: Oct 2010
Posts: 59
How to show sheet tab bar in excel 2010

I have created few documents in the MS Office Excel 2003 and I has chosen an option for not showing the tabs in all of those documents. Now when I am opening them on another machine which has MS Office 2010 installed on it, then it is not showing any tabs and I am not able to find out the option from where I can make tabs visible. Please help me!

Reply With Quote
  #2  
Old 02-01-2011
Member
 
Join Date: May 2008
Posts: 860
Re: How to show sheet tab bar in excel 2010

It seems like the setting that you have made on MS Office 2003 while creating the documents has been saved in the documents so that wherever you open those documents, it would be showing in the same way as you have saved it last time. As you said that you were not having any show sheets option in Ms Office 2003 due to which it is not showing in the Ms Office 2010 as well. There must be an option to enable it in the Excel 2010 too but if you are not able to find out it then you can do it another way that is by enabling it in the Ms Office 2003 and then save it. Now try opening the saved document on MS Excel 2010 and check that it shows sheets tab or not.
Reply With Quote
  #3  
Old 02-01-2011
Member
 
Join Date: May 2008
Posts: 913
Re: How to show sheet tab bar in excel 2010

Here I have provided you the path by which you can enable the Show Sheet Tabs on your Ms Excel 2010. You need to first of all click on the File Menu and then go to an Options where you have to select for the Advance Options. Here you must be having Display Option for this workbook in which you have to select for the Show Sheet Tabs. Now check that it shows the Sheet Tabs or not.
Reply With Quote
  #4  
Old 02-01-2011
Member
 
Join Date: Apr 2010
Posts: 95
Re: How to show sheet tab bar in excel 2010

After several hours of fruitless searching, I turned towards you. Since yesterday evening I am annoyed with a PivotTable. With the configuration of the table, I get in boxes of adding the total value of more boxes, all in the format "Standard", with unrounded numbers to the nearest hundredth (size 0.00). The problem is that the result is not entirely accurate.
Reply With Quote
  #5  
Old 02-01-2011
Member
 
Join Date: Nov 2008
Posts: 1,192
Re: How to show sheet tab bar in excel 2010

That's it, I finally found a solution by force to scratch! Just truncate the values to two decimal places, and given that the outgoing false values are much lower at ten decimal places is enough. To do this, you must right click on the data (Sum of sthg in principle), click on "Settings ...", click on Field" Number ...", select the category "Number," then the number of decimal places "2" (or more if you wish). Finally click "OK" then "OK" and you're done! Voili voilou!!
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to show sheet tab bar in excel 2010"
Thread Thread Starter Forum Replies Last Post
How to use Mail Merge from one Excel Sheet to another Excel Sheet Abélard MS Office Support 2 23-02-2012 01:59 PM
Is it possible to get rid of circular reference in Excel sheet Iyyappan MS Office Support 2 21-02-2012 11:59 AM
What is the use of time sheet in excel Chini mao MS Office Support 1 08-01-2012 03:35 PM
Send unlimited SMS from Your Excel Sheet Maq.H Tips & Tweaks 2 25-07-2009 09:09 PM
Fax an Excel sheet From a Computer Addis Tips & Tweaks 1 24-10-2008 01:03 PM


All times are GMT +5.5. The time now is 01:24 AM.