When you press Ctrl+A in a worksheet, you are selecting the current range.
Selecting the Entire Excel Worksheet 3 Different Keyboard Shortcuts to Select “All” Data within a WorksheetĪ much easier method to select an entire Excel worksheet is to use the shortcut key Ctrl+A (the “A” stands for “All”). However, your selection may vary: If you have hundreds of rows of data, this method can be very tedious when needing to select all of the data within a worksheet. Many users learn early on the “click + hold + drag” method for selecting a range of data using Microsoft Excel.
