Microsoft Excel can be a difficult program to master, so this article aims to provide you with some tips and tricks to improve your Excel competency and ensure you are as productive as you can possibly be.
Shortcuts:
| Choose a fill color | Alt+H, H |
| Cut | Ctrl+X |
| Go to Insert tab | Alt+N |
| Bold | Ctrl+B |
| Center align cell contents | Alt+H, A, then C |
| Go to Page Layout tab | Alt+P |
| Go to Data tab | Alt+A |
| Go to View tab | Alt+W |
| Format a cell from context menu | Shift+F10 |
| Add borders | Alt+H, B |
| Delete column | Alt+H,D, then C |
| Go to Formula tab | Alt+M |
Comments
A good workbook is one that others can read and work with, without the help of the creator. Presenting someone with a complex web of numbers and expecting them to get results is just unfair. Right click a cell you'd like to explain and select Insert Comment to attach a note to that cell; you can resize and reposition the comment box if required. A cell with a comment is marked with a red flash in its top-right corner, and hovering over the cell will display that comment.
It's a good idea to add comments to column or row headers, and use the spacing tools to move them around so they're not overlapping. The Show All Comments button in the Review tab will bring them all up at once.
Quick formatting
Drag to select a group of data, and look out for an icon appearing at the bottom-right hand corner of your selection area. This could be Excel's coolest feature: the quick analysis tool.
It gives you instant access to a bunch of useful formatting features, all the way from colouring up your cells based on their range to implementing sparklines, sums and charts. Hover over each option to see a preview and click it to lock it down. Use the same tool to clear formatting if it gets too much – you'll find the clear option listed under the Formatting heading.
Further reading
For more information, please visit: https://www.shortcutworld.com/en/win/Excel_2016.html