Debbie Mayo-Smith international inspirational motivational how-to speaker technology, time management, improving business performance
Motivational Speakers, Sales, Marketing, Time Management, Productivity, Technology, Tips

Clever computing with Debbie

Here's two great tips to save you time

Outlook: Make calendar items stand out with colour. Try this, it's brilliant.
Why not create a band of colour to help you visually prioritise your calendar meetings, appointments and event? For example every time you type in the word committee meeting it can turn blue; type in staff meeting and have it coloured green.

It's simple to set up. Right click on any day. Select automatic formatting. Type in a name and select a colour. You can hone it very finely by selecting the condition button.

Excel: Keep your column heading from moving when you scroll
Isn't it most annoying when you're working with a big Excel spreadsheet the column headings move out of sight? Keep them immobile by "freezing them". Here's how.

If your column headings are in Row 1; Highlight the entire Row Two. Then go to the Window Menu, and select Freeze Pane. It's as simple as that. Now the headings will remain frozen while you scroll up and down to your hearts content. It's better than splitting the screen because splitting does not make any of the sections immobile.


Debbie Mayo-Smith called the Queen of Productivity is an International Motivational Business Speaker and best selling author! ( Let Debbie help you with easy practical ways to improve your business profitability, personal productivity and work life balance. Debbie lives in NZ and travels the world speaking, writing and training. Why not enrol for our free newsletter?

This article is copyright to Debbie Mayo-Smith & SuccessIS. You may use it for your newsletter, website or as an article. It can be reproduced - but in its entirety and with inclusion of Debbie Mayo-Smith as the author and the weblink


Free Quick Tips Newsletter
You'll love this succinct monthly tip newsletter focused on improving your business results and productivity.

View and sign up now!!!

Andrew Gardner; Investors Edge

"Get on her email list mate! She sends brilliant tips every month. It’s the one newsletter I love to get!"