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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Protection and filters

Protection and filters

ResolvedVersion 2007

Thu 23 Sep 2010, 17:24 Delegate Liz said...

Liz has attended:
SharePoint course

Protection and filters

Hello

When we apply protection we seem to lose the facility to use data filters....is there any solution to this problem please?

Tue 28 Sep 2010, 14:20 Trainer Jacob said...

RE: protection and filters

Dear Liz

Further to your forum post we would need to see your working files and an itemised list of the issues you are facing.

We can then review and see if we can assist. If we can find a solution we will let you know the scope of work and any associated costs to complete.

Please feel free to send the files to me direct.

Tue 5 Oct 2010: Automatically marked as resolved.

Excel tip:

Add Text to Displayed Numbers in Excel 2010

To add text to a number in a cell, you need to go to the Home tab on the Ribbon, and click on the Cells group. Select Format Cells from the drop down menu then Custom from the Category list. In the Type box select General. After the word General, enter a space, then opening quotation marks, then the word you want to type and then closing quotation marks. Click on OK and you have your text!

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Protection and filters

Protection and filters

RE: protection and filters

Excel articles

Excel tip:

Add Text to Displayed Numbers in Excel 2010