Concerned about the latest vaccine mandate? Visit Pryor's free training resource page to learn more about the latest rulings on the national 100+ vaccine mandate.

How to Unlock Specific Cells in Excel

When using a shared document you may only want to allow specific cells to be changed. Here are some steps to help you keep certain cells unlocked while the rest of the document is protected.

Step 1: Select the cell(s) you would like to leave unlocked.

Step 2: Go to Format and select “Lock Cell” in order to keep that cell(s) unlocked.

Note: The lock icon should be highlighted when you select the format dialog box. By selecting “Lock Cell” you are DESELECTING the lock icon and it will no longer be highlighted.

Selected:

Deselected:

Step 3: Highlight the entire worksheet (Ctrl + A or select the highlight all square in the top left corner of your spreadsheet).

Step 4: Go back under Format and select “Protect Sheet.”

Step 5: Select OK in the protect sheet dialog box.

You will now only be able to type in the cell(s) you have left unlocked.


Choose a Seminar and Save $10:

Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small> Basics

Microsoft® Excel® Basics

LIVE ONLINE SEMINARS

Jan. 31

Central Time Zone

Feb. 2

Central Time Zone

Feb. 3

Eastern Time Zone

Feb. 7

Central Time Zone

Feb. 8

Eastern Time Zone

Feb. 10

Central Time Zone

Feb. 14

Central Time Zone

Feb. 16

Eastern Time Zone

Feb. 16

Central Time Zone

Feb. 22

Central Time Zone

Feb. 24

Pacific Time Zone

Mar. 1

Central Time Zone

Mar. 2

Eastern Time Zone

Mar. 7

Central Time Zone

Mar. 9

Central Time Zone

Mar. 14

Central Time Zone

Mar. 16

Central Time Zone

Mar. 17

Eastern Time Zone

Mar. 22

Central Time Zone

Mar. 24

Central Time Zone

Mar. 28

Eastern Time Zone

Mar. 29

Central Time Zone

Mar. 31

Pacific Time Zone

Apr. 4

Eastern Time Zone

Apr. 5

Central Time Zone

Apr. 7

Central Time Zone

Apr. 11

Central Time Zone

Apr. 12

Pacific Time Zone

Apr. 13

Eastern Time Zone

Apr. 19

Central Time Zone

Apr. 20

Central Time Zone

Apr. 21

Eastern Time Zone

Apr. 25

Eastern Time Zone

Apr. 27

Central Time Zone

Apr. 28

Pacific Time Zone

May. 2

Eastern Time Zone

May. 4

Central Time Zone

May. 5

Pacific Time Zone

May. 9

Eastern Time Zone

May. 10

Central Time Zone

May. 12

Central Time Zone

May. 16

Central Time Zone

May. 17

Pacific Time Zone

May. 18

Central Time Zone

May. 19

Eastern Time Zone

May. 24

Eastern Time Zone

May. 25

Central Time Zone

Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small>: Beyond the Basics

Microsoft® Excel®: Beyond the Basics

LIVE ONLINE SEMINARS

Feb. 1

Central Time Zone

Feb. 3

Central Time Zone

Feb. 4

Eastern Time Zone

Feb. 8

Central Time Zone

Feb. 9

Eastern Time Zone

Feb. 11

Central Time Zone

Feb. 15

Central Time Zone

Feb. 17

Eastern Time Zone

Feb. 17

Central Time Zone

Feb. 23

Central Time Zone

Feb. 25

Pacific Time Zone

Mar. 2

Central Time Zone

Mar. 3

Eastern Time Zone

Mar. 8

Central Time Zone

Mar. 10

Central Time Zone

Mar. 15

Central Time Zone

Mar. 17

Central Time Zone

Mar. 18

Eastern Time Zone

Mar. 23

Central Time Zone

Mar. 25

Central Time Zone

Mar. 29

Eastern Time Zone

Mar. 30

Central Time Zone

Apr. 1

Pacific Time Zone

Apr. 5

Eastern Time Zone

Apr. 6

Central Time Zone

Apr. 8

Central Time Zone

Apr. 12

Central Time Zone

Apr. 13

Pacific Time Zone

Apr. 14

Eastern Time Zone

Apr. 20

Central Time Zone

Apr. 21

Central Time Zone

Apr. 22

Eastern Time Zone

Apr. 26

Eastern Time Zone

Apr. 28

Central Time Zone

Apr. 29

Pacific Time Zone

May. 3

Eastern Time Zone

May. 5

Central Time Zone

May. 6

Pacific Time Zone

May. 10

Eastern Time Zone

May. 11

Central Time Zone

May. 13

Central Time Zone

May. 17

Central Time Zone

May. 18

Pacific Time Zone

May. 19

Central Time Zone

May. 20

Eastern Time Zone

May. 25

Eastern Time Zone

May. 26

Central Time Zone

Advanced Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small>-Macros, PivotTables, Charts and More

Advanced Microsoft® Excel®-Macros, PivotTables, Charts and More

LIVE ONLINE SEMINARS

Feb. 2

Eastern Time Zone

Feb. 4

Central Time Zone

Feb. 8

Pacific Time Zone

Feb. 9

Central Time Zone

Feb. 15

Eastern Time Zone

Feb. 18

Central Time Zone

Feb. 24

Central Time Zone

Mar. 3

Central Time Zone

Mar. 8

Eastern Time Zone

Mar. 11

Central Time Zone

Mar. 16

Pacific Time Zone

Mar. 21

Central Time Zone

Mar. 23

Eastern Time Zone

Mar. 31

Central Time Zone

Apr. 4

Central Time Zone

Apr. 6

Eastern Time Zone

Apr. 12

Eastern Time Zone

Apr. 14

Central Time Zone

Apr. 21

Eastern Time Zone

Apr. 22

Central Time Zone

Apr. 26

Central Time Zone

Apr. 27

Pacific Time Zone

May. 4

Central Time Zone

May. 5

Eastern Time Zone

May. 10

Central Time Zone

May. 12

Pacific Time Zone

May. 17

Eastern Time Zone

May. 20

Central Time Zone

May. 23

Central Time Zone

Related Excel® Articles

PRYOR+ 7-DAY FREE TRIAL


Experience 7-days of unlimited learning, then reap the benefits from a year of training at one low price. No credit card. No commitment. Individuals and teams.

Categories