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

excel training in london - protecting cells

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training in london - Protecting cells

excel training in london - Protecting cells

ResolvedVersion Standard

Karen has attended:
Excel Pivot Tables course

Protecting cells

I wish to send out a protected worksheet, but allow the user to change font and to widen or colour in certain columns when they return the worksheet to me. How should I do this please?
Thanks
Karen

RE: Protecting cells

USE THE FOLLOWING TO LOcK CELLS:

Cells are protected with a two stage process.

By clicking on format > cells, then navigating to the PROTECTION Tab, you will see a tick box saying locked.

All cells are locked by default, but are only activated once you switch the functionality on.
To do this, click on TOOLS > PROTECTION > PROTECT SHEET.

All cells are locked by default, so your would need to unlock the cells you do not want to protect.

HOWEVER:
before you confirm the password, tick the relevant box to enable the formatting functionality.

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.