i need help with stupid excel! can anybody help? i am sure it's just a minor thing and i pressed the wrong key...
you know when you press the arrow buttons (up, down, left, right) in an excel sheet, you can move from cell to cell. that's what it always did. but now when i press one of the arrow buttons, i am actually moving the whole sheet up/down/left/right while the marked cell stays the same (so every time i want to go into a new cell, i have to click on it)
grrr!

Have you got the scroll lock on?

__________________
'You cannot direct the wind, but you can adjust your sails'

the what?????

On your keyboard usually on the right hand side somewhere there is a scroll lock normally where the Delete, Home, End buttons are

__________________
'You cannot direct the wind, but you can adjust your sails'

DOH! thanks, supersonic!!! see, i told you it'd be something simple and stupid... i'll go and hide in my room now out of embarrassment

Glad to be of help Honey

__________________
'You cannot direct the wind, but you can adjust your sails'

(i thought i might as well open a new thread for this, as i have questions occasionally and am sure you computer wizards can help!)

is there a way to copy a table automatically into every sheet of an excel book (rather than doing it manually by copying and pasting)?

I am no expert on Excel ...

Is it an empty table that you want to have on several sheets?

The way I would do it would be to copy the whole sheet, rather than just the table (depending on what else is on the sheet)

It depends which version of excel you have as to how you would do this - if you want to e-mail it to me I will have a look for you

__________________

yes, it's an empty (accounting) table - i use one per day, so at the end of every month, i use a new book that i fill with x amounts of sheets and i copy & paste the table into each sheet. i would think there must be a way of just automatically copying the table into every sheet.
let's see if anybody else can help before i'd bother you with emailing it to you. i'm on excel 2000, by the way, if that helps.

It will be very easy to do, you could just set a template book up with 31 sheets in it, each one with your table on it.

At the beginning of each month just open the template and save it as 'June2008' (or whatever) and start again

Its not a problem for me to do this for you if you would like, I will pm my e-mail to you.

__________________