Locking certain cells in Excel 2007?

  • Thread starter Thread starter asynmyx
  • Start date Start date
A

asynmyx

I have excel 2007 and need to lock only certain columns. Does anyone know how
to easily do this? Thanks!
--
 
By default all cells in a worksheet are locked when sheet protection is
enabled.

It is up to you to decide which are to be locked or unlocked when the sheet
is protected.

Format>Cells>Protection is where you would change the "locked" or "unlocked"
status.

CTRL + a to select all cells and unlock them.

CTRL + click to select the cells to be locked and lock them

Then Tools>Protect>Protect Sheet.......add a password if you wish but these
are easily broken and will not stop a savvy user.

Note the selectable options under "allow users to" when protecting,


Gord Dibben MS Excel MVP
 
By default, CELLS are locked so if you protect the sheet they will be
locked. If you want unlocked select the columns to unlock>right
click>format>protection>unlock>set protection.save.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I can still select & manipulate locked & protected cells in '07 1
locking formulas in Excel 2007 so users can't change but can vieworiginal formula? 1
show a customised message when a trying to edit a locked cell 2
Unhiding rows in Excel 2007 3
Unprotect 2003 excel files when opening in Excel 2007 1
HOW DO I LOCK CERTAIN CELLS 2
Excel 2007 4
Cell protection short cut button 1

Back
Top