Learn How to Extend Selection to the Last Cell Down With Shortcut in Microsoft Excel

Extend Selection to the Last Cell Down With Shortcut in Microsoft Excel

Here we will show you how to extend the selection to the last cell down in Microsoft Excel. Like many other programs Microsoft Excel also uses similar key combinations while using shortcuts.

You can use the key combinations given below to extend the selection to the last cell down using the shortcut. In case the active cell is empty, Microsoft Excel will extend the selection to the first non-empty cell below the active cell. And, if the active cell is not empty, Excel will extend the selection on the last non-empty cell below the active cell. Mac users can use the command key "⌘" instead of the control key. So, here we go:

How to Extend Selection to the Last Cell down With Shortcut in Microsoft Excel?

It is used to Extend selection to the last cell down in Microsoft Excel. In case the active cell is empty, Microsoft Excel will extend the selection to the first non-empty cell below the active cell. And, if the active cell is not empty, Excel will extend the selection on the last non-empty cell below the active cell. Mac users can use the command key "⌘" instead of the control key. This way you can easily extend the selection to the last cell down using this shortcut.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel