Turn Your World Upside Down

Hints ant tips for Microsoft Excel Spreadsheets

Recently a client opened an expenses file, inherited from a former employee, and commented:

With 2 key strokes the data and chart were upside down.

It turned out this was a quick method to make the client laugh, relax and be quickly convinced that they can do anything with a little bit of training.

How to rotate your computer screen:

Here are some Excel shortcuts you might find more useful

• Ctrl + ; Enters the current date
• Ctrl + Shift + ; Enters the current time
• CTRL + D Enters the contents of the cell above
• Highlight some data and press F11 to instantly produce a chart
• Alt + Enter Can be used to wrap text in a single cell

Example:

1. Type Welcome To Excel Tips in a single cell
2. Position cursor before the word Excel
3. Press Alt + Enter

The text will be wrapped so it appears with Welcome To appearing above Excel Tips

Investigate other useful skills and techniques to improve your spreadsheets: Refresh your Spreadsheet Skills