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

Until I know more about Excel in general, all I can say with 2007 version if
you haven't used it yet is that the right click menu is invaluable. The
ribbon takes some searching when you aren't used to the program much but the
right click menu often solves that problem.


"Don Guillett" wrote in message
...
I also have not yet installed my 2007. Have you tried the HELP index for
PROTECTION?

--
Don Guillett
SalesAid Software

"Diamontina Cocktail" wrote in message
...

"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.