Tabbing in Rows

[Worzel Gummidge]

The only active rows in my spreadsheet are rows B to K. The rest are not
being used.

What I want is for users to be able to click in cell B and then tab across
entering info in each cell in the row. When the user has finished entering
info in Cell K and they press tab, I would like for the cursor to move down
a row and into cell B for them to enter more info.

Any ideas?

 

[Dave Peterson]

Columns.

Select your range first (B3:K99, say). Then the tabbing will work the way you
want.

 

[Bernie Deitrick]

Worzel,

Select all cells, and use Format / Cells, and on the protection tab, click "Locked".

Select columns B to K, and use Format / Cells, and on the protection tab, unclick "Locked".

Then use Tools / Protection and select Protect Sheet, and check only "allow user to select unlocked
cells".

Then use Tools / Options... Edit tab, check "Move selection after enter" and select Right.

Then entry will act as you describe.

HTH,
Bernie
MS Excel MVP

 

[Worzel Gummidge]

Bernie,

Many thanks for your reply. Unfortunately I am having a problem; it may be
due to my version of Excel.

When I get to the below stage, it does not offer the option of 'allow user
to select unlocked cells.'

**Then use Tools / Protection and select Protect Sheet, and check only
"allow user to select unlocked cells".**

The only choices I have are "protect worksheet for a) contents b) objects c)
scenarios.

Can you help further?

Thanks again

 

[Bernie Deitrick]

Worzel,

You'll need to use the method that Dave described, which should work in earlier versions of Excel.

HTH,
Bernie
MS Excel MVP

 

[Worzel Gummidge]

How do I select the range though and make it remain selected when opening
and closing the spreadsheet? It will be used by multiple users and so I want
it to be set for them when they open the spreadsheet (if that's possible)

Many thanks once again for your replies

 

[Dave Peterson]

I'd give that range a nice name.
Select the range
insert|name|define

Then your users can select it manually (via Edit|goto and type that name)
or
you could use a macro that selects that range when you open the workbook.

This goes in a General Module:

Option Explicit
sub Auto_Open()
application.goto worksheets("sheet99").range("nicenamehere"), scroll:=true
end sub

Change the sheet name and range name to what you need.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm