Table of Contents
Whether you use Excel frequently or rarely, for work or for tracking in-game items, here are 5 tips and tricks that may help you save time in the future.
1. Inserting today’s date
You can very quickly insert today’s date into any cell simply by pressing “CTRL ;”
This little shortcut can be very helpful over time and more often than not be used on most spreadsheets if you want to track the day it was made.
2. Repeat… Repeat!
In Excel there often comes a time when you want to repeat the last formula/action you made, there is a shortcut combo for this, F4.
Just press F4 next time you want to repeat an action on another cell, just click the cell and F4.
3. Search in Excel?
If you are stuck in a certain area or with a certain formula, press: “Alt Q”, this will let you search for what you are trying to do!
More often than not typing in the exact formula will bring up a formula wizard for you to use, providing clear and understandable instructions on what you need to do.
4. Keep it simple, Cut/Copy & Paste
You can drastically speed up your workflow with shortcuts, perhaps the best shortcut is Copy & Paste.
- To copy press “CTRL C”
- To cut press “CTRL X”
- Finally to paste press “CTRL V”
5. Excel’s autosum?
Excel has a shortcut that will automatically sum your rows or columns, this can help stop you from having to select the thousands of cells you might have before you can sum them.
To autosum just press “ALT =”
That’s all folks
That concludes the 5 tips and tricks for excel part 1, hopefully you find them useful, come back again soon for part 2.