Make Some Fields Read Only in Excel
How to make jail cell as read merely in Excel?
In many cases, you lot may demand to prevent others from editing some specified cells in your worksheet. This article provides two methods to help yous make specified cells as read but, so that others cannot edit these cells except for reading.
Make prison cell as read only by protecting worksheet
Make prison cell as read only by VBA lawmaking without protecting worksheet
Make cell as read just past protecting worksheet
Yous can but lock the cells which y'all want to make them read-only, and then protect this worksheet to achieve information technology. Delight practise as follows.
ane. Click the 
push on the height left corner of current worksheet to select the whole cells.
ii. Printing the Ctrl + 1 keys simultaneously to open the Format Cells dialog box. In the dialog box, uncheck the Locked box under the Protection tab, and so click the OK button. See screenshot:
3. Now select the cells you want to make them as read but (here I select cells of range A1:C18). Press the Ctrl + 1 keys simultaneously to open the Format Cells dialog box, check the Locked box under the Protection tab and click the OK button.
four. Go ahead to click Review > Protect Sheet. See screenshot:
five. Specify and confirm your password to protect the worksheet as below screenshot shown.
Now cells in the locked range are read-only now. When yous try to edit these specific cells within the range, you will go a prompt box as beneath screenshot shown.
Microsoft Excel allows you to protect 1 worksheet with password at a time. Here you lot can use the Protect Worksheet and Unprotect Worksheet utilities of Kutools for Excel to rapidly protect or unprotect multiple worksheets or all workrksheets in current workbook with countersign at the same fourth dimension.
Download and try it at present! ( 30-day free trail)
Make jail cell as read only past VBA code without protecting worksheet
If you lot don't want to protect the worksheet to brand cell as read only. The VBA script in this section will assistance you to solve this problem easily.
1. Correct click the sheet tab you need to brand prison cell equally read only, and then click View Lawmaking from the right-clicking bill of fare.
2. In the opening Microsoft Visual Basic for Applications window, copy and paste the beneath VBA code into the Lawmaking window.
VBA code: Make cell as read only in Excel
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Column = 1 So If Target.Row = 3 Or Target.Row = 4 Or Target.Row = five Then Beep Cells(Target.Row, Target.Column).Outset(0, 1).Select MsgBox Cells(Target.Row, Target.Cavalcade).Accost & " cannot be selected and edited every bit it is a read-only cell", _ vbInformation, "Kutools for Excel" End If Finish If Cease Sub Note: This code can just make specified cells in one cavalcade as read simply. In this code, it will make cell A3, A4 and A5 equally read only in current worksheet.
3. Press the Alt + Q keys to shut the Microsoft Visual Basic for Applications window.
When clicking on cell A3, A4 or A5 in electric current worksheet, you will go a Kutools for Excel dialog box as beneath screenshot shown, and the cursor will movement to the correct adjacent jail cell automatically.
The All-time Office Productivity Tools
Kutools for Excel Solves Nearly of Your Problems, and Increases Your Productivity past 80%
- Reuse: Apace insert complex formulas, charts and anything that you have used earlier; Encrypt Cells with password; Create Mailing List and transport emails...
- Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit big numbers of cells); Paste to Filtered Range...
- Merge Cells/Rows/Columns without losing Data; Split up Cells Content; Combine Indistinguishable Rows/Columns... Preclude Indistinguishable Cells; Compare Ranges...
- Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Detect and Fuzzy Discover in Many Workbooks; Random Select...
- Verbal Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more than...
- Extract Text, Add Text, Remove past Position, Remove Space; Create and Print Paging Subtotals; Catechumen Between Cells Content and Comments...
- Super Filter (salve and employ filter schemes to other sheets); Advanced Sort by month/week/twenty-four hours, frequency and more; Special Filter by bold, italic...
- Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
- More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features xxx-twenty-four hours costless trial. 60-mean solar day coin dorsum guarantee.
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint , Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Source: https://www.extendoffice.com/documents/excel/4078-excel-make-cell-read-only.html
0 Response to "Make Some Fields Read Only in Excel"
Post a Comment