microsoft excel keyboard shortcuts cheat sheet

Insert a Comment: Short cut key will be SHIFT + F2 (Note: Prior to performing this, double click on cell reference for edit mode). In some scenarios, we need to enter today’s date & time instead of looking into the calendar or time at the bottom, we can use the below-mentioned shortcut key.įor date: CTRL + or For time: SHIFT + CTRL + Insertion of Date or Time or Comments in Excel ALT + HOH (Column Height) & ALT + HOW (Column Width)ģ. When you are working on a huge data set, this column width adjustment and its resizing is important, here you have to select the multiple columns, then you need to hover your cursor of mouse towards the right side of the column where you want to resize it and double click on it to get the desired result, or you can use shortcut keys, i.e.

Selection of all the data with a single click or with the help of CTRL + A helps out to select a whole data range in a worksheet. You can download this Excel Hacks Template here – Excel Hacks Template Example #1 – Use of Important Keyboard Shortcuts

Microsoft excel keyboard shortcuts cheat sheet