![]() ![]() ![]() In the screen shot below, cell E2 was active when the shortcut was used. If you use the Ctrl + A shortcut while an isolated or empty cell is selected, then the entire worksheet is selected. In this example, cell A1 was active, and range A1:A2 was selected with the keyboard shortcut. ![]() But how can you select actual used range in Excel sheet? The selection stops at the first blank row and blank column. That shortcut selects all the cells in the block that surround the active cell. It’s easy to select the current range in Excel – just press Ctrl + A. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |