You might want to insert the current date or time in Excel. Two easy shortcuts for this is: Ctrl + ; is a shortcut key to enter the current date in a cell. Ctrl + : or Ctrl + Shift + ; are shortcut keys to enter the current time in a cell. It should be noted though that once you have entered a date or time, these values are fixed. Should you wish to enter a date or time that will constantly update each time that the Excel file opens or when Excel refreshes calculations, you will then rather want to […]
Copy, Paste, Cut Ctrl + C is a shortcut key to copy; alternatively click on the Home tab, Clipboard, and Copy. Ctrl + V is a shortcut key to paste; alternatively click on the Home tab, Clipboard, and Paste. Ctrl + X is a shortcut key to cut; alternatively click on the Home tab, Clipboard, and Cut. Undo and Redo Ctrl + Z is a shortcut key to Undo the previous key stroke. Ctrl + Y is a shortcut key to Redo or restore the previous Undo. Moving to the next or previous window Ctrl + Tab is a shortcut […]
Excel Shortcut to select a Row or Column: To select a column of an active cell, press Ctrl + Spacebar or click on the column border. To select a row of an active cell, press Shift + Spacebar or click on the row border. Excel Shortcut to hide a Row or Column Ctrl + 0 hides the column of the active cell. Ctrl + 9 hides the column of the active cell However, I found that these keys only work when pressing the 0 above the Qwerty keyboard. Those in the numerical pad does not work.