Software

Ask something
Discussion Locked

Excel Settings

0 helpful
10 replies

by jimo

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi

Does anyone know away to disable or keep a user from being able to select multiple non adjacent cells or cell ranges in a spreadsheet? I only want them to be able select one cell.

Thanks

10 replies

by dklippert

It's called protection. By default every cell on the sheet is ready to be locked down. If you want just one cell, go to that cell and choose Format>Cells (or Right-click Format Cells). Pick the Protection tab and remove the check mark from the locked option. Click OK
Go to Tool>Protect Sheet...
You can then just click OK or give it a password.
Now the user can only use that cell. If you choose a number of cells to unlock, the user can tab and Excel will jump to the next unprotected spot.

by riedwaan gasnola

Actually all you have to do is Click on
Tools >> Protection >> Allow users to edit ranges

THen it will take you to the Spreadsheet and ask you which cells you would like locked.

Hope it helps

by riedwaan gasnola

Actually all you have to do is Click on
Tools >> Protection >> Allow users to edit ranges

THen it will take you to the Spreadsheet and ask you which cells you would like locked.

Hope it helps

This discussion is closed to new replies.