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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
protecting confidential data

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Protecting Confidential Data

Protecting Confidential Data

ResolvedVersion Standard

Vivienne has attended:
PowerPoint Introduction course

Protecting Confidential Data

How do you protect data in a cell and only allow authorised staff to view

RE: Protecting Confidential Data

You can protect entire workbooks by going to tools>>protection>>protect workbooks. You can put a password in the sheet and only give the password to the staff you want. But you cannot protect a particular cell in the worksheet on its own and not let anyone see it. What you could try is hiding the column where the cell is. Then protect the worksheet with a password. Staff who knew the password would be able to take the protection off and then unhide the cells. Staff who didnt know the password cant take off the protection and then unhide the column.

Excel tip:

Manually wrapping text

To manually wrap text, use the shortcut key Alt+Enter.

To cancel manual text wrapping, simply delete the new line.

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.