data entry and jump to .....

**stevesunfold** · 10-12-2008, 05:50 AM

data entry and jump to .....

hi guys i have a sheet where i need to enter data all down one column from d1 all the way down to d26

but once ive entered the data in d26 i want it to jump directly to k1 rather than carry on down to d27

is this possible?

regards

**snasui** · 10-12-2008, 06:28 AM

Try this,

A. Unlocked your ranges and protect sheet.

1. Select your ranges > Right click > Format cells > Uncheck Locked winthin Protection tab.
2. Tools > Protection > Protect sheet > Uncheck Select locked cells > OK

B. Create Custom views.
1. Select your ranges.
2. View > Custom views.
3. Add > Enter name of view.

Before enter data.
Select menu view > Custom views > Select view's name > Show.

Hope this helps.