limited rows and columns

**Ranbir** · 05-18-2011, 05:41 AM

hi,

I want to restrict the cursor movement between Active Rows and Colums (Sample Screen Shot is attached). Kindly guideme how to do the same.

Thanks in anticipation.

Regards
Ranbir

**sweep** · 05-18-2011, 06:31 AM

Hi,

Select the range you wish to allow the user to access.
Right click, properties, protection, untick "locked"
On the review tab, click protect sheet, and untick "select locked cells", click OK

**Ranbir** · 05-21-2011, 07:28 AM

hi,

Thanks for your prompt reply.

Actually I want to do the way sample screen shot is attached means the rest of of rows and column are not visible to the user.

Thanks
Ranbir

**royUK** · 05-21-2011, 07:33 AM

Select the first empty column, yjen Ctr;+Shift + Right arrow to select all columns to the right. Then Right click on the Column Headers & choose hide.

Repeat this on the rows to hide

Then protect the sheet

**Ranbir** · 05-21-2011, 10:22 AM

Dear Mr. Roy,

Thanks a Lot for your guidance.

Regards
Ranbir

**harrisjdtx** · 03-02-2013, 07:17 PM

Thank you sweep and royUK. I was trying to get my cursor to move to the beginning of the next row down from the end of the previous row when I hit Tab (avoid an extra keystroke -- downarrow+home).

Works great!

[Just a monthly bill SS that I use to keep track of my regular bills.]

I'm brand new to the forum.

THANKS!