Import multiple Excel or CSV files in to Excel using Power Query
If you have multiple Excel files you need to combine in to one list, Power Query may have the...
Email your file without leaving Word or Excel or Other application
If whilst working on your document or spreadsheet and you need to email it to a colleague as an...
I need more space - Hide the Office toolbar with a keyboard shortcut
Have you ever been working on a Word document or a large Excel file or for that matter a big...
Zeros who needs them - hide zeros in Excel
Sometimes you don't want to see the zeros in your spreadsheet (This may help your Spreadsheet look...
Hip to be square - Draw perfectly symmetrical shapes
Holding down the “Shift” key while drawing shapes in Office applications makes them resize evenly....
Rinse and repeat - Quickly move or copy a worksheet
To quickly move a worksheet:
- left mouse click (And hold) on the tab you want to move
- Drag the tab...
The final countdown (Date Maths in Excel)
As long as a date is written in a form that Excel recognises as a date, you can quickly perform...
Ahhh, I can't type a phone number in to Excel
When you try to enter a phone number in to Excel you will find that Excel removes the Zero from the...
Add a comment to a cell using a shortcut
If you press shift and F2 on your keyboard when you have a cell selected this will add a comment to...
