/en/excel-tips/absolute-references-with-the-f4-key/content/
Sometimes you may want to add a blank row to your spreadsheet. Luckily, there is an easy keyboard shortcut for this: Ctrl+Shift+Plus. Simply click a row number to select a row, hold down the Ctrl and Shift keys, and press plus (+). Excel will then add a row above the selected row.
Watch the video below to see this shortcut in action.
/en/excel-tips/use-an-entire-column-as-a-cell-range/content/
