Hi All,
I am new to UrbanPro with a passion for learning and teaching analytical tools, MS Excel being the one of them. Excel is one of those master tools which seems untapped to its fullest potential; mastering it really helps you get insights into your data and helps you make meaningful decisions with raw data. Here I am listing out few shortcuts which are really helpful if you have been using MS - Excel day in day out.
Keys Description
Alt+Enter Useful when you want to continue writing text in the same cell
F7 to activate a spellcheck on your worksheet
CTRL+ ; to insert current date
CTRL+shift+; to insert current time
shift+spacebar select entire column
CTRL+spacebar select entire row
CTRL+F6 to toggle between open workbooks
ALT+h+m+m to merge cells
Hope you find this post useful.
Happy Learning!!