/en/excel-tips/absolute-references-with-the-f4-key/content/
There are probably many occasions when you want to add a blank row to your spreadsheet. It just so happens that there is an easy keyboard shortcut for this: Ctrl + Shift + Plus.
Watch the video below to see this shortcut (and a bonus one!) in action.
It might take some time to remember these shortcuts, but once you do, you’ll find yourself doing them without thinking twice! Read on to learn how to use an entire column as a cell range.
/en/excel-tips/use-an-entire-column-as-a-cell-range/content/
About cookies on this site
Sharing your cookies helps us improve the site, optimize your experience, and understand the extent of our impact. By closing this banner, you agree to the use of cookies on this website (This option applies to users outside the United States and Europe). Learn more about how we use cookies by clicking on Cookie Settings.