Moving selection after enter

paliman

Active Member
Joined
Jul 7, 2002
Messages
254
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.
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

ThePencilQueen

Board Regular
Joined
Jun 26, 2002
Messages
109
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

MrExcel MVP
Joined
Feb 17, 2002
Messages
13,686
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>
kitten_smush2.jpg

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

paliman

Active Member
Joined
Jul 7, 2002
Messages
254
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.
 

Forum statistics

Threads
1,143,702
Messages
5,720,375
Members
422,281
Latest member
jantoooh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top