# adding a new Excel work sheet

Category: Geeks r Us

## Post 1 by vinbenji (Generic Zoner) on Friday, 02-Nov-2007 4:30:05

friends,i got ms ofice 2003, in that,excel,i when i want to create a new sheet in a excel book,it creats before the sheet which i am in,that is
if i want to creat a new sheet when i am in sheet 3 ,the new sheet creats in between sheet 2 and 3.as sheet 4,i want the 4th sheet next to sheet 3,can any one help me on that? and i am using JAWS 7 .

## Post 2 by Thom3of5 (Do the Doo.) on Friday, 02-Nov-2007 4:51:32

I'm not sure if there's a way to reorder the sheets. However, you could rename the sheet 4 to sheet 3 and sheet 3 to sheet 4. You know what I mean? To do that, it's in the format menu, under sheet.You can also name them things other than sheet...
Hope that helpped
Thom

## Post 3 by vinbenji (Generic Zoner) on Friday, 02-Nov-2007 12:16:38

tam,
thank you i have tried ,its useful,

## Post 4 by WillieTheWoof (I'll have the last word, thank you!) on Friday, 02-Nov-2007 21:05:58

Try the following:
press alt-e to go to the edit menu.
Press the letter m for "move or copy sheet"
you will then be in a list of the sheets in your work book and can use the up and down arrows to move the one you are on to whatever place you want it to appear in the book.
Press enter to complete the process.
Remember, Ctrl-page up and Ctrl-Page down move you back and forward through the work book and you will hear the titles of the sheets in the order you placed them.

## Post 5 by vinbenji (Generic Zoner) on Friday, 02-Nov-2007 23:26:48

thank you its great ,it worked well,but will it be the same for all the version of ms office,i meen 2000 and so on?,but thank you very much for your time,its very useful
benji

## Post 6 by Harmony (I've now got the silver prolific poster award! wahoo!) on Saturday, 03-Nov-2007 16:37:32

Go to sheet 1 and try inserting it there if you want it befre sheet 1, or if you want it before sheet 3, go to sheet 3 and create a new worksheet. I can't remember if it puts the workheet before or after that one, though.

## Post 7 by WillieTheWoof (I'll have the last word, thank you!) on Monday, 05-Nov-2007 20:46:43

I believe it's putting the sheet before. as far as the office question, guess I'll have to try this in office 2007 and find out. asside from that nasty ribbon I would think the concepts should be the same.

## Post 8 by wildebrew (We promised the world we'd tame it, what were we hoping for?) on Tuesday, 06-Nov-2007 4:29:04

Excel 2007 is somewhat accessible but I have found issues with it. For one thing the "edit formula" box (pressing f2 inside a cell to edit its formula) does not read properly, only sees the last letter. I didn't play with it much, just siwtched back to 2003 since I was at a conference but might give it a second shot later. Also some of the Jaws hot keys conflict with the Office 2007 key strokes. It is still surprisigly workable. Can't say the Accessibility group at MS is doing a particularly fantastic job, seeing as Office 2007 is just not very accessible. Also, apart from beefed up GUI and, in some ways, better integration with .net, there are very few advantages for using 2007 over 2003.

## Post 9 by Harmony (I've now got the silver prolific poster award! wahoo!) on Tuesday, 06-Nov-2007 14:21:03

In that case, if you want to inserta worksheet before the first, you have go up to the first worksheet, or go to the third worksheet and insert another one in there. You could then rename the worksheets and copy and paste the information from one worksheet into the other. I hope this helps you.

## Post 10 by vinbenji (Generic Zoner) on Wednesday, 07-Nov-2007 3:21:12

thanks all friends for your valeabletime,i have got the remedy.
thank you
benji