![]() Select the Used Range by Navigating Back Home Once you find the last cell, you can then hold the Shift key down and click cell A1 to select the entire range. Tip: Sometimes you can delete the seemingly extra rows and columns outside your data range and it will reduce the file size. The last cell may sometimes surprise, because Excel considers cell as being “used” so you may see blank cells that are way outside your data range. Click Special which will bring up the Go To Special dialog box. ![]() Just use the keyboard shortcut CONTROL + G to bring up the Go To dialog box. This “last cell” is not always apparent, but easily found. The used range on a worksheet starts with cell A1 and ends with the last used cell in the worksheet. However, using Excel on a Mac makes you keenly aware that there’s no Home button. ![]() I recently read a good about selecting the on an Excel sheet, both manually and with VBA. Second time: column data + column header. Behavior changes as the shortcut is used more than once. This shortcut selects one or more table columns in a table, when the cursor is in an Excel table. ![]() Jump to Select cells, columns, or rows - in the same column or row as the active cell.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |