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

spreadsheets

ResolvedVersion 365

Geoff has attended:
Excel Intermediate course
Office 365 End User course

Spreadsheets

So I have to send monthly reports and one of the tables is for RASSO cases for all 3 police areas. My question is how to I tailor the report to close off the data from the other police areas so that only one set is showing?

RE: spreadsheets

Hi Geoff,

Thank you for the forum question.

The safest way of making sure that no one can see more information in a report that you want is to split the data set.

You can do this if you are working with Pivot Tables, the advanced filter, or Power Query. You can also do it manually,

You have more options but they are not 100% safe. You can, if you have the right knowledge, explore all the data, even that you try to protect the data, if all the data is in the file.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Fri 4 Mar 2022: Automatically marked as resolved.

Excel tip:

Quickly copy a formula across sheets

Suppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets.

Remember to ungroup the sheets afterwards! Right-click on any tab and choose Ungroup Sheets to do that.

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.11 secs.