Excel problems

libra10

I have Office 2011 Home and Student, running on Macbook Pro.

A worksheet I have contains several pages, unfortunately only the first sheet is visible. You can scroll down this page reaching thousands.

The tabs which indicate different pages seem to be missing from the bottom of the sheet, can anyone please advise how to make them return?

johnmc

http://blogmines.com/blog/2010/10/05/how-to-hide-the-sheet-tabs-in-excel-2010/
Google is your friend.

libra10

Thank you johnmc

I had googled but will check out your link.

Much appreciated.

jackomdj

Not sure about your version, but all the ones I have used just right click on the tab then select unhide and choose which hidden tab to unhide.

libra10

Thanks very much for replying..

Unfortunately there doesn't seem to be any tabs at the bottom of the screen to click on.

Looked at the links above, but all options seem to be ticked correctly.

I'm really stuck with this.

Can anyone else give options to try please?

The version of Excel is Office Mac 2011, Home and Student, and I'm using a Macbook Pro.

Thank you

Hazzanet

libra10

Thank you very much Hazzanet, really appreciate your images, they make very clear.

Unfortunately my spreadsheet doesn't appear to have a bottom line, it just scrolls into infinity .....

I have just scrolled down the worksheet which shows, and decided to stop at row 20000, am sure it goes on forever!

I haven't a clue what I've done, the data was saved on a USB stick, but that worksheet seems exactly the same as on computer.

A backup on older USB stick is not as up to date.

Should spreadsheets have a bottom line, or will they just keep scrolling?

Hazzanet

This option adds/removes the bottom line:

libra10

Thanks again Hazzanet, your help is very much appreciated.

Unfortunately Office 2011 seems slightly different to Office 2007 (the previous programme I used to use), and there doesn't seem to be a choice for Options on this copy.

Have searched in 'Help", and can only see 'Advanced filter". Searched in Help for the option to Show Horizontal scroll bar, but not appearing.

In Office 2007 there was the top left icon from where you could access many choices, unfortunately in Office 2011 I don't see this option.

johnmc

libra10 wrote:

there doesn't seem to be a choice for Options on this copy.

Select the "File" tab at the top of the spreadsheet.

In the left hand toolbar select "Options".

You will get a popup screen. In the left hand toolbar select "Advanced".

Select the options as previous.

libra10

Thank you.

There isn't a File option at the top of spreadsheet. Above the line reads Excel, File, Edit, etc. When I click File, there isn't an Options choice showing.

Not sure whether this is because I'm using Macbook instead of PC?