Did not realize you were using 2007.

I do not have that version installed so cannot test nor offer any suggestions.


Gord

On Mon, 7 May 2007 22:57:57 +1000, "Diamontina Cocktail"
wrote:


"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
couple of ways to do this.

1. Select columns A:K and FormatCellsProtectionclear the checkmark in
"Locked"

Thanks, that worked but not exactly as you said it. I use Excel 2007.


ToolsProtectionProtect sheet.


There is no "Tools" menu in Excel 2007 that I could find.

You can Tab your way across and when you leave K1 you will drop to A2

2. Without protection...........Start in A1 and Tab your way across.
When
leaving K1 hit the ENTER key.

I actually always do that anyway and it didnt produce that effect.