protection and filters

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

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

Protection and filters

resolvedResolved · Urgent Priority · Version 2007

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?

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.

Regards

Jacob

Tue 5 Oct 2010: Automatically marked as resolved.


 

Excel tip:

Generate randon numbers

Some types of analysis require you to use randomly generated numbers. You can also use randomly generated numbers to quickly populate an Excel spreadsheet. There's an easy function you can use to do this automatically. Here are a few of the ways you can use it:

Type =RAND() in a cell to generate a number between 0 and 1.
Type =RAND()*100 to generate a number between 1 and 100.

View all Excel hints and tips


Server loaded in 0.09 secs.