Locking certain cells in Excel 2007?

A

asynmyx

I have excel 2007 and need to lock only certain columns. Does anyone know how
to easily do this? Thanks!
--
 
G

Gord Dibben

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
 
D

Don Guillett

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

Place picture in Excel cell 0
Copy addition formula of non-consecutive horizontal cells 2
Filtered view of Visio Chart 0
Format column widths from one table to a separate table on same page 1
VBA word change keys 0
Cell Auto Lock After Entering 1
Match table shading (color) to Visio color/Transparency 1
Paste to excel from word - auto format problem 1

Top