Moving selection after enter

[paliman]

Hi all. I have a couple of questions to make.

1) I have a workbook with 2 sheets. In sheet1 I input data and sheet2 contains a pivot table report. I would like that when I press enter on sheet1 after I have completed a row, the cursor goes to the next row below. But I want it to do it ONLY in this sheet. Ok, may be in the whole workbook, but not in any other workbook that I could have opened at the same time. Is this possible?

2)In my data entry sheet I put formulas in col. C, D & G. Is there a way to "jump" over thiese columns? I mean, when I press TAB I'd like to go from col B to col E in one step.

As always, thanks for your time.

 

[ThePencilQueen]

When doing line by line data input like this I generally use enter and then the home key to get to the start of the line

As for the columns with formula's in, when you are inputting you could hide them by highlighting the columns, right clicking and selecting hide, this way you can tab straigh over them.

 

[Von Pookie]

Well for #2, you should be able to do that by protecting the sheet.

Just make sure the cells you want to enter data into are unlocked (select those cells, then go to Format|Cells|Protection tab and unselect the box next to "locked")

Edited to point out that PencilQueen's way works as well

Hope it helps,

_________________<font color="#3399FF" size="3">Kristy</font>

This message was edited by Von Pookie on 2002-10-23 11:51

 

[paliman]

Yes, of course. Simple, obvious. I guess I should have figured it out myself. It's not a good day I think

Thanks to both of you.