Author name: Umesh Manral

About This Shortcut Display Format Clls With Font tab Selected – This shortcut opens the Format Cells dialog box with the Font tab selected. Here, you can change the font type, font size, font color, and other font-related settings. Keybord Shortcut key Window: Ctrl + Shift + F Mac: Ctrl + Shift + F

About This Shortcut Format Cells – This shortcut opens the Format Cells dialog box, where you can change the formatting of the selected cells. You can change the number format, alignment, font, border, and background color of the cells. Keybord Shortcut key Window: Ctrl + 1 Mac: Cmd + 1

About This Shortcut Flash Fill – Ctrl + E helps to run flash fill manually. Keybord Shortcut key Window: Ctrl + E Mac: Ctrl + E Example:

About This Shortcut Display AutoComplete List – Press [Alt] + [Down Arrow] in the cell where you want to add a new entry to see a drop-down list of AutoComplete options. Keybord Shortcut key Window: Alt + ↓ Mac: Alt + ↓ Example:

About This Shortcut Insert Hyperlink – By pressing Ctrl + K, you can make a link to a certain part of the document. Keybord Shortcut key Window: Ctrl + K Mac: Cmd + K Example:

About This Shortcut Copy Formula From Cell Above (Formula is Exact Copy) – The formula in the cell above will be pasted into the active cell. Keybord Shortcut key Window: Ctrl + ( ‘ ) Mac: Cmd + ( ‘ )

About This Shortcut Copy Value From Cell Above – It puts the value from the cell above into the cell you’re looking at. Keybord Shortcut key Window: Ctrl + Shift + ( ” ) Mac: Ctrl + Shift +(  ” )

About This Shortcut Enter Same Data in Multiple Cells (After Copying, Then Selecting Cells) – In spreadsheet software such as Microsoft Excel or Google Sheets, you can use the Enter key to quickly copy and paste the same data into multiple cells. This can be useful if you have a large dataset that contains the

About This Shortcut Insert Current Date – It puts today’s date in the current cell. Keybord Shortcut key Window: Ctrl + ; Mac: Ctrl + ; Example:

About This Shortcut Insert Current Time – The keyboard shortcut command puts the time in the current cell. Keybord Shortcut key Window: Ctrl + Shift + : Mac: Cmd + ; Example: