If you want to select all cells containing data, but you want to start from the bottom of the data and work your way up, you can use the Ctrl+Shift+Home shortcut. Ctrl+Shift+Home: Select all cells containing data (reverse direction) This shortcut will select all cells in the worksheet from the active cell to the last cell that contains data.ģ. If you only want to select cells that contain data, you can use the Ctrl+Shift+End shortcut. Ctrl+Shift+End: Select all cells containing data This shortcut will select all of the cells in the worksheet, including any blank cells.Ģ.

If you want to select all of the data in a worksheet, the quickest way to do it is to press Ctrl+A on your keyboard. In this article, we'll share 15 of the best keyboard shortcuts for selecting data in Excel.

After all, the more time you spend selecting data, the less time you have to actually analyze it and draw conclusions from it.įortunately, there are a number of keyboard shortcuts you can use to select data in Excel more quickly. If you work with data in Excel, you're probably always looking for ways to select it more quickly and efficiently.

Excel shortcut keys select all data