Wednesday, February 11, 2015

Prime Productivity Pointer - Fitting an Excel Spreadsheet to a Single Page.

Each month I send out an email with a quick video tip or shortcut to increase productivity with Microsoft Office.

Often there are little frustrating things that happen in Word and Excel that, whilst small, if you have to do them regularly that 5-10 minutes adds up over time.

Did you know that if you fast tracked a task in Microsoft Office and saved 5 minutes a day, across the course of a year that equates to over 1000 minutes or 16hrs!

One of the common things we hear from clients is they simply don't have enough time to get everything done.  If this is you or your team, we'd love to have a conversation to see how we can help.

This month I cover an often overlooked tip in Excel, fitting your spreadsheet to a single page.
Too often I see users simply type in their data and expect Excel to do the rest.
I suggest you always do a print preview of your spreadsheet before you print it.

It’s also important to note that Excel automatically reduces the size of text, so if your spreadsheet has too many rows or columns, then whilst all your information may end up on one page, you may not be able to read it!

Fit To A Page
Once the Fit to a Page option is selected, you don’t need to adjust it again.
Your data will now automatically print to a page.

Download this month’s PDF relevant to your version of Excel and take a few minutes to watch the video.

Is there someone you know who could benefit from knowing about Fit to a Page?
Why not forward this pointer on??

Excel 2007
Excel 2010
Excel 2013

And here are the videos

Fit to a Page - MP4 Format
Fit to a Page- WMV Format

If you are interested in receiving these pointers with our compliments each month, visit www.primesolutions.net.au type in your details and we will be happy to add you to our list.


Hope you work SMARTER and not HARDER this month
Donna

No comments:

Post a Comment