Beyond the Help files . . .



Access    Excel  FrontPage  Outlook  PowerPoint   Word     Miscellaneous    Tutorials    Windows    Free Downloads



Cell Locking in Microsoft Excel

There's pretty much just two reasons for locking cells:

The points you should know are these:

Select All Cells

Just click the button above Row 1 and to the left of Column A. This selects all the cells on your worksheet.

Lock/Unlock Cells

Go to FormatCells. Choose the Protection tab. Lock or unlock the cells as desired.

You can quickly lock/unlock cells by locking or unlocking one or more cells, then continue by using the F4 button, which repeats the last command. So, while you may have 30 different cells on a worksheet that you want to unlock, you can select, F4, select, F4...


Back to top...



All contents copyright Anne Troy 2005-2006