98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
Resolved · Medium Priority · Version 2003
For upcoming training course dates see: Pricing & availability
RE: excel intermadiate
Thank you for your question and welcome to the forum.
You can apply protection to a spreadsheet using Tools - Protection - Protect Sheet. You can set a password if you wish; also you can check (tick) the actions that you want to allow people using the spreadsheet to be able to perform even when protection is applied.
I hope this helps.
Tue 25 Aug 2009: Automatically marked as resolved.
You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:
Welcome. Please choose your application (eg. Excel) and then post your question.
Our Microsoft Qualified trainers will then respond within 24 hours (working days).
Any suggestions, questions or comments? Please post in the Improve the forum thread.