In our last post, we have gone through some tips and tricks in operating Microsoft Word. Now, we are going to talk about the tips and tricks in using Microsoft Excel.
Which one is easier, reading lots of words or looking at an Excel table? While Microsoft Word might be the primary application that we use, it is always handy to know a little bit more about its sibling Excel.
1. Automatically SUM() with ALT + =
You don’t need to type “=E1:E5” and click Enter. Simply add an entire column or row by clicking in the first empty cell in the column (for example, in E6). Then enter ALT + ‘=’ (equals key) to add up the numbers in every cell above.
2. Formatting Keyboard Shortcuts: $ and %
Do you want to change a number (for example, 0.5) into percentage (50%) or dollar value ($0.5)? Simply click on the cell and enter CTRL + % or CTRL + $. Really, it’s that simple.
3. Jump to the Start or End of a Column Keyboard Shortcut
Say you’re working on a very large data and you are thousands of rows deep into your document. You would like to get to the first or last cell. Insated of scrolling, click CTRL + ↑ to jump to the top cell, or CTRL + ↓ to drop to the last cell before an empty cell.
Click SHIFT key as well if you would like to block all the cells as well.
4. Repeat a Formula to Multiple Cells
Don’t repeat a formula to each and every cell. Instead, create the formula you need in the first cell only. Then move your cursor to the lower right corner of that cell and, when it turns into a plus sign, double click to copy that formula into the rest of the cells in that column. That way, each cell in the column will show the results of the formula using the data in that row.
5. Copy a Pattern of Numbers or Even Dates
Excel is able to recognise patterns and allows you to copy it to other cells. For example, type “1” and “2” in the first and second row. Then highlight those two rows and drag down for as many cells as you want. Excel will put “3”, “4”, “5” and so on by itself!
This trick also works with days of the week and months.
6. Go back to the first cell
Simply click on CTRL + Home and you will get back to A1 straightaway. No need to scroll.
7. Go to the last cell
Not only you are able to go back to the first cell, you can also go to the last cell in your worksheet. Simple click CTRL + End.
8. Move to next sheet
Working with multiple sheets? Click CTRL + Page Down to move to the next sheet.
9. Move to previous sheet
Click CTRL + Page Up to move to previous sheet. This way you don’t need use your mouse at all.
10. Move to the next window
To move to the next window (open workbook) Click CTRL + Tab.
Want to learn more about working with Microsoft Excel? The Institute of Management offers an Advanced Microsoft Excel course. Visit our website to find out more.