ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   XP V Vista (https://www.excelbanter.com/excel-discussion-misc-queries/179422-xp-v-vista.html)

Arisaiglass

XP V Vista
 
How do i get multiple sheets in vista spreadsheet like i did in XP Excel? For
example, say i wanted to create months of the year each on a new sheet?

Jon Peltier

XP V Vista
 
It's not Excel Vista. Vista is the version of Windows that came out about
the same time. It's Excel 2007.

Can't you insert a new sheet? Down on the row of sheet tabs, there's a new
short tab thingie with an asterix. Click it to add a new worksheet after the
last one.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Arisaiglass" wrote in message
...
How do i get multiple sheets in vista spreadsheet like i did in XP Excel?
For
example, say i wanted to create months of the year each on a new sheet?




Arisaiglass

XP V Vista
 
Hi Jon,

Thanks for your response. Thats correct I have been using Excel on my XP
desktop pc but I have now got a laptop which has vista and wanted to copy
some documents over.

I don't really want to spend £100+ and buy word and excel so I copied my
documents over onto the vista versions of excel and word.

I don't appear to have a short tab at the bottom of the sheet, i have a zoom
function on the bottom left hand side of the horizontal scroll bar but thats
it..... I have looked through the headings ("insert" i would have thought
being the obvious one) but i am at a loss where to look next.

Lisa

"Jon Peltier" wrote:

It's not Excel Vista. Vista is the version of Windows that came out about
the same time. It's Excel 2007.

Can't you insert a new sheet? Down on the row of sheet tabs, there's a new
short tab thingie with an asterix. Click it to add a new worksheet after the
last one.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Arisaiglass" wrote in message
...
How do i get multiple sheets in vista spreadsheet like i did in XP Excel?
For
example, say i wanted to create months of the year each on a new sheet?





Bill Sharpe

XP V Vista
 
Arisaiglass wrote:
Hi Jon,

Thanks for your response. Thats correct I have been using Excel on my XP
desktop pc but I have now got a laptop which has vista and wanted to copy
some documents over.

I don't really want to spend £100+ and buy word and excel so I copied my
documents over onto the vista versions of excel and word.

I don't appear to have a short tab at the bottom of the sheet, i have a zoom
function on the bottom left hand side of the horizontal scroll bar but thats
it..... I have looked through the headings ("insert" i would have thought
being the obvious one) but i am at a loss where to look next.

Lisa


As others have noted there is no Vista version of Excel or Word. What
does the window title say when you open Excel by itself on your laptop?
On my computer it says "Microsoft Excel - Book1" when I am using Excel
2003 and "Book 1 - Microsoft Excel" when I am using Excel 2007. Both
versions show Sheet tabs directly below the spreadsheet. Excel 2007 has
an extra tab for adding another sheet. Excel 2003 does not have this
extra tab, but the Insert menu does have an option for adding another sheet.

If you are using Excel 2003 and you do not see the sheet tabs, do this:
On the Tools menu, click Options.
On the View tab, under Window options, select or clear the Sheet tabs
check box.

If you are using Excel 2007 on the home tab click the little triangle to
the right of "Insert" in the cells group and select "insert sheet."

Bill


All times are GMT +1. The time now is 06:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com