excel training courses - block cells

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses - Block cells

excel training courses - Block cells

resolvedResolved · Low Priority · Version Standard

Vinay has attended:
No courses

Block cells

How do I block an excel cell so no-one can enter details with in the cell?

RE: block cells

Cells and worksheets can be locked using the TOOLS > PROTECTION > PROTECT WORKSHEET feature.

If you click on FORMAT > CELLS > PROTECTION, then you will see a setting to lock or unlock individual cells.


It works on two levels. All cells are locked by default, but the activation of that feature happens when you use PROTECT WORKSHEET from the tools menu.


 

Excel tip:

Select blank cells automatically

Get Excel to find any blank (empty) cells in a region for you by:

1. Selecting the appropriate region from your spreadsheet.

2. On the menu bar, go to Edit - Go to.

3. Click the 'Special' button, then select Blanks and click OK.

View all Excel hints and tips


Server loaded in 0.08 secs.