MajorGeeks Support Forums

Go Back   MajorGeeks Support Forums > ----------= PC, Desktop and Laptop Support =---------- > Software
Register FAQ Members List Calendar Casino Mark Forums Read

Software Software such as operating systems like Windows XP, Windows Vista, Windows 7 etc., or specific programs.


Reply
 
Thread Tools Display Modes
  #1  
Old 06-20-11, 12:23
sharpconnect sharpconnect is offline
Private First Class
 
Join Date: Sep 2004
Posts: 59
Thanks: 1
Thanked 0 Times in 0 Posts
Default Excel 2010 sheet tabs

At my work office I have Excel 2010. We all use Dell laptops. We have been using this version of Excel for 1-2 months now.

We are viewing a file in excel [sent via email from another coworker whose file is ok.]
Cannot see the sheet tabs in the lower left corner of the screen. How do we get them back?

Also, scrolling bars at bottom and right of screen have disappeared. How to make them visible agian?

Would appreciate any help you can give us to fix these 2 items. Thanks. can't get to all the info in the file without looking at the other sheets.
Reply With Quote
Sponsored links
  #2  
Old 06-20-11, 14:04
cachehiker's Avatar
cachehiker cachehiker is offline
Private First Class
 
Join Date: May 2011
Location: The Udaho Border
Posts: 47
Thanks: 2
Thanked 12 Times in 12 Posts
Default Re: Excel 2010 sheet tabs

I only have Excel 2007 at home. It's Excel 2010 here at work so I might be a little off with a little bit of this.

Is the page you can see a graph, a table, a report, an embedded object, or ? Are you looking at it in Normal View, Print View, Full View, or ? Are you opening the file as a local copy or as an attachment?

Can you see the close button (an X) and the maximize button (a square) in the top right hand corner of your spreadsheet? Does clicking on the maximize button help?

Go to File -> Excel Options -> Advanced and scroll about halfway down. What is checked where it says Display Options for this Workbook?
Reply With Quote
  #3  
Old 06-21-11, 07:16
sharpconnect sharpconnect is offline
Private First Class
 
Join Date: Sep 2004
Posts: 59
Thanks: 1
Thanked 0 Times in 0 Posts
Default Re: Excel 2010 sheet tabs

it is a table. was sent to us in email attachment. opened attachment to view. per person who sent it there should be about 4-5 tabs at the bottom labeled/named different dates. Was in Normal view. Tried page layout - nothing.

When I tried page break view, the tabs appeared. I then tried to save it to the desktop as copy of xyz. The first time I opened it, I saw all the tabs.

But we lost the bar at the top [file, home, insert, etc. and what is under these tabs on top]. Am unable to get that bar back. When tried to reopen file so K could work on it, the tabs were no longer there.

Display settings:
Recent docs 25
ruler inches
boxes checked are
show all windows in taskbar
show formula bar
show function screen tips
for cells w/ comments, show indicators only, and comments on hover
default direction: left to right.


Display options for this workbook:
show horizontal scroll bar
show vertical scroll bar
show sheet tabs
group dates in auto filter menu
for objects show all

display options for worksheet:
show row & column headers
show a zero in cells that have zero value
show outline sumbols if an outline is applied
show gridlines

The file opens on my computer correctly. I can see scroll bars and tabs at bottom.
I told K the problem was settings on her computer but I don't know which one is the problem.
Reply With Quote
  #4  
Old 06-22-11, 07:20
sharpconnect sharpconnect is offline
Private First Class
 
Join Date: Sep 2004
Posts: 59
Thanks: 1
Thanked 0 Times in 0 Posts
Default Re: Excel 2010 sheet tabs

Just to clarify, it more of a report, than a table, that combines figures from several different files. It opens correctly on my computer but not on K's. Again, the side and bottom scroll bars are missing. Also, the bar with commands across the top in Excel 2010 is not there. Unsure how to restore the bars.

Found but I can't use these instructions

"If you widen the horizontal scroll bar at the bottom of a worksheet, you may unintentionally hide some or all of the sheet tabs. If this happens, point to the button next to the left of the scroll bar: "

because the buttons next to the left and/or right of the scroll bar are missing on K's computer so can't do this until I find these buttons again.
Reply With Quote
  #5  
Old 06-22-11, 08:18
usafveteran's Avatar
usafveteran usafveteran is offline
Major Geek
 
Join Date: Aug 2004
Location: central Ohio
Posts: 3,364
Thanks: 43
Thanked 419 Times in 394 Posts
Default Re: Excel 2010 sheet tabs

Exactly what "button" are you talking about? On K's computer, is the horizontal scrollbar hiding some or all of the sheet tabs?

If you right click on the arrows in the lower left corner of Excel, it displays a list of the sheet tabs. From that list, you can select a tab. See attached image (from Excel 2007):
Attached Images
File Type: png ExcelTabs.png (14.4 KB, 3 views)
Reply With Quote
Sponsored links
  #6  
Old 06-22-11, 15:06
sharpconnect sharpconnect is offline
Private First Class
 
Join Date: Sep 2004
Posts: 59
Thanks: 1
Thanked 0 Times in 0 Posts
Default Re: Excel 2010 sheet tabs

That's the problem. The arrows have also disappeared!!!

The button I referred to was the one that make the scroll bar longer or shorter - there wa a little on left and on right before they disappeared with the arrows.


IT guy finally got here. He figured out that while Excel was maximized, the actual file was smaller [not minimized] and had been pushed partly off the screen to the right side. Once he brought it back, the other worksheets in the file appeared!
Reply With Quote
  #7  
Old 09-29-12, 22:18
beccapie beccapie is offline
Private E-2
 
Join Date: Sep 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Re: Excel 2010 sheet tabs

just in case you can also do View tab and click "new window"
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem installing Excel 2010 with SCCM with Office 2003 philson Software 0 03-11-11 15:51
Image shatter to postage stamp sheet? greybuffalo Software 2 09-01-07 05:17
general sheet TommyD Software 1 10-10-05 10:55
Style Sheet HTML Help, Please cato Software 5 01-21-04 19:52


All times are GMT -5. The time now is 13:17.

MajorGeeks.Com Menu

MajorGeeks.Com \ All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ NEW! PC Games \ System Tools \ Macintosh \ Demonews.Com \ Top Downloads

MajorGeeks.Com \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds


All content Copyright MajorGeeks.com source code Powered by vBulletin® Version 3.8.4
Copyright © 2009 vBulletin Solutions, Inc. All rights reserved.
Ad Management by RedTyger