Navigates to the last cell used in the current worksheet.Įxtends the selection of cells to the last cell at the top edge of the current data region.Įxtends the selection of cells to the last cell at the bottom edge of the current data region.Įxtends the selection of cells to the last cell at the right edge of the current data region.Įxtends the selection of cells to the last cell at the left edge of the current data region.Įxtends the selection of cells up and to the left, to cell A1.Įxtends the selection of cells down and to the right, to the last used cell in the worksheet. Navigates to the bottom edge of the current column, in the current data region. Navigates to the top edge of the current column, in the current data region. Navigates to the left edge of the current row, in the current data region. Navigates to the right edge of the current row, in the current data region. Navigates to cell A1 of the given worksheet. Keyboard Shortcuts Navigating Worksheets Excel for Windows Remove multiple characters from a text string with nested SUBSTITUTE functions.Dynamically extract a person's first name with FIND and LEFT.Use TEXT to return the name of the current day of the week.Randomly sample data with RANDBETWEEN and INDEX.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |