A keyboard shortcut is a combination of key presses ... contiguous and non-contiguous. If you select contiguous rows, Excel will insert the same number of blank rows as the selection.

Aside from the well-known Excel keyboard shortcuts, these are the ones I use the most often and save me the most time. Command Shortcut Notes Select cells manually Shift+arrow keys Select row If ...

Not only can you select columns and rows, but you can also extend your selections with key combinations. After you use the above shortcuts to make selections, you can format the cells with the ...

Step 1: Select blank cells in Excel Once you realize that your ... Fortunately, there is a way to delete blank rows using a combination of keyboard shortcuts. Instead of following the steps ...