![]() |
Protect cells
I want a cell like "Name" be locked, but the cell next to it to be open for
entering a name. How do I do it? |
Protect cells
Cell formats have a "locked" property that is actually locked by
default. If you protect a sheet it will engage all of the locks, so choose which ones you wish to unlock first (with Format/Cells/ Protection - version dependent!), and then protect the sheet. On Sep 3, 12:25*pm, Tag1948 wrote: I want a cell like "Name" be locked, but the cell next to it to be open for entering a name. How do I do it? |
Protect cells
Tag1948 wrote:
I want a cell like "Name" be locked, but the cell next to it to be open for entering a name. How do I do it? Open Excel. Hit F1 (or select Help / Microsoft Excel Help). In the box under "Assistance" that says "Search for:" type "protect cells". Hit enter. Or, click here... http://office.microsoft.com/en-us/ex...548251033.aspx |
All times are GMT +1. The time now is 04:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com