ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Protect cells (https://www.excelbanter.com/excel-worksheet-functions/201201-protect-cells.html)

Tag1948

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?

Reitanos

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?



Glenn

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