Thread: Sheet format
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.newusers
Diamontina Cocktail Diamontina Cocktail is offline
external usenet poster
 
Posts: 21
Default Sheet format

I had no choice, basically. I had 2002 version and went to Vista then found
Vista and Outlook 2002 don't get on - passwords not remembered and I have 27
email accounts - so had to update to 2007. Wasn't really a bad thing overall
as the price had been dropped enormously in the store I went to. Some sort
of promotion.

2007 version has some nice things in it that aren't in other versions but I
have to know more before I can really make comments more than that.


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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.