98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel print of locked document
Excel print of locked document
Resolved · Urgent Priority · Version 2007
Tue 13 Nov 2012, 10:16Delegate Lucie said...
Lucie has attended:
Excel Intermediate course
Excel Advanced course
Excel print of locked document
Good morning,
I wanted to ask how can I print out an excel document. I need to print out only selected information on a spreadsheet that is locked. I do have the password for the spreadsheet so I did unlocked it but it wouldn't let me print all selected informations I need. It prints out only something e.g. Name and time in. Bu ti also need time out, group, etc...
Could you help me please?
Thank you,
Lucy
Tue 13 Nov 2012, 14:14Trainer Paul said...
RE: Excel print of locked document
Hi Lucy,
Have you checked the page breaks? and set print areas? It does not sound like a protection/locking issue.
Thanks
Paul
Tue 13 Nov 2012, 14:22Delegate Lucie said...
RE: Excel print of locked document
Hello,
Well the problem is that the spreadsheet has over 4000 names in but it is for past 3 years. So every year logged on one spreadsheet and now what we trying to do is to print out only some information from those 3 years. I also tried FILTER so I could get only info I need but it wouldn't filter all information I know on the spreadsheet is. It would only give me e.g 3 rows of the same person I'm looking for but I know there is at least 50 rows with the same name. Does that make sense?
Thank you.
Lucy
Tue 13 Nov 2012, 14:28Trainer Paul said...
RE: Excel print of locked document
can you email me the spreadsheet? paul@stl-training.co.uk
Tue 13 Nov 2012, 14:31Delegate Lucie said...
RE: Excel print of locked document
I'm afraid I can't do that as it is confidential medical document. Even though I know that would be the best option...
Tue 13 Nov 2012, 14:36Trainer Paul said...
RE: Excel print of locked document
You can hide columns and rows to make the printing more bespoke. Major issues normally include a "set print area" or pre-set page breaks. Also make sure you don’t have any blank lines in your data as that can make filters not work properly.
Tue 13 Nov 2012, 14:51Delegate Lucie said...
RE: Excel print of locked document
I will try. Also I already told my colleague to create a new spredsheet for this as when I saw it it is a mess.
Thank you so much for your help.
Have a nice day,
Lucy
Tue 13 Nov 2012, 14:57Trainer Paul said...
RE: Excel print of locked document
good luck Lucy ;)
Tue 20 Nov 2012: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Select only cell that contain text to lock formatFor selecting cells that only contain Text in Excel |
