![]() You can also use the Go To window to move to any range names or tables that have been created in your workbook. Note: The sheet name has to have an exclamation mark ( !) after it to indicate that it is a sheet. This moves you to the specified cell in the specified sheet. In the Go To window, enter the row you want to move to in the format sheetname!cell (e.g., Sheet3!A5) in the Reference box and click OK. To move to a cell on a different sheet, type the sheet name into the Go To window. This moves you from your current cell to Column D, which is selected in its entirety. In the Go To window, enter the row you want to move to in the format column:column (e.g., D:D) in the Reference box and click OK. Moving to a specific column follows exactly the same procedure. This moves you from cell A1 to Row 3, which is now selected in its entirety. In the Go To window, enter the row you want to move to in the format row:row (e.g., 3:3) in the Reference box and click OK. To achieve this, follow Step 1 from the previous section. This time, say you want to move from cell A1 and select Row 3. Just as with a cell, you can also move to and select an entire row using the Go To feature. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |