Activates and selects the next visible Worksheet after the activeWorksheet

Activates and selects the previous visible Worksheet before the activeWorksheet

Activates the visible worksheet that is the last partially visible worksheet tab in view or next visible worksheet if the last visible item is fully in view.

Activates the next SpreadsheetPane if there are multiple panes and they are not frozen.

Activates the next visible Worksheet after the activeWorksheet

Activates the visible worksheet that is before the first worksheet tab in view.

Activates the previous SpreadsheetPane if there are multiple panes and they are not frozen.

Activates the previous visible Worksheet before the activeWorksheet

Adds a new Worksheet after the current active worksheet and activates it.

Changes the horizontal alignment of the cell formats for the current selection switching between Center and General.

Changes the horizontal alignment of the cell formats for the current selection switching between Justify and General.

Changes the horizontal alignment of the cell formats for the current selection switching between Left and General.

Changes the horizontal alignment of the cell formats for the current selection switching between Right and General.

Changes the vertical alignment of the cell formats for the current selection to Bottom.

Changes the vertical alignment of the cell formats for the current selection to Middle.

Changes the vertical alignment of the cell formats for the current selection to Top.

Updates the WorksheetColumn.width based on the size of the content in the columns associated with the activeSelection so that it will be resized based on the size of the contents.

Updates the WorksheetRow.height to be -1 for rows associated with the activeSelection so that it will be resized based on the size of the contents.

Exits the renaming of a worksheet without committing the changes to the name

Navigates to the cell above the active cell.

Navigates to the cell below the active cell.

Activates the first cell in the next cell range of the SpreadsheetSelection

Activates the first cell in the previous cell range of the SpreadsheetSelection

Navigates to the cell above within the selection if multiple cells are selected otherwise navigates to the cell above.

Navigates to the cell below within the selection if multiple cells are selected otherwise navigates to the cell below.

Navigates to the previous cell within the selection if multiple cells are selected otherwise navigates to the cell to the left.

Navigates to the next cell within the selection if multiple cells are selected otherwise navigates to the cell to the right.

Navigates to the cell to the left of the active cell.

Scrolls up one page and activates a cell in the same column and relative visible row.

Scrolls down one page and activates a cell in the same column and relative visible row.

Scrolls left one page and activates a cell in the same row and relative visible column.

Scrolls right one page and activates a cell in the same row and relative visible column.

Navigates to the cell to the right of the active cell.

Navigates to the cell above the active cell that has data or the first cell in the column if there are none with data.

Navigates to the cell below the active cell that has data or the last cell in the column if there are none with data.

Navigates to the cell to the left of the active cell that has data or the first cell in the row if there are none with data.

Navigates to the cell to the right of the active cell that has data or the last cell in the row if there are none with data.

Checks the validity of all the cells in the current activeWorksheet based on their associated DataValidationRule if it has one.

Clears the value of the selected cells.

Resets the cell format for the cells associated with the selection including the row and column cell format for rows and columns that are entirely selected.

Removes hyperlinks from the selected cells without removing the formatting.

Clears any invalidation circles that are cached for the current activeWorksheet

Attempts to exit the renaming of a worksheet and committing the changes to the name.

Copies the information from the selection to the clipboard.

Copies the information from the selection to the clipboard and clears the contents.

Decreases the size of the font for the cell format of the current selection based on the current state of the active cell.

Decreases the Indent of the cell format of the current selection based on the current state of each cell and potentially changing other properties such as horizontal alignment to one that supports indentation.

Deletes the cells associated with the current selection and shifts the cells based on where data is in adjacent cells.

Deletes the cells associated with the current selection and shifts the cells that exist on the right of the selection to the left.

Deletes the cells associated with the current selection and shifts the cells that exist below of the selection upward.

Removes columns associated with the current selection.

Removes rows associated with the current selection.

Removes the selected worksheets from the associated Workbook.

Navigates to the farthest contiguous cell with data above the active cell. If the active cell has no data or the cell above does not have data, it will navigate to the start of the next cell that has data in that direction or the first cell in the column if there are no more cells with data.

Navigates to the farthest contiguous cell with data below the active cell. If the active cell has no data or the cell below does not have data, it will navigate to the start of the next cell that has data in that direction or the last cell in the column if there are no more cells with data.

Navigates to the farthest contiguous cell with data to the left of the active cell. If the active cell has no data or the cell to the left does not have data, it will navigate to the start of the next cell that has data in that direction or the first cell in the row if there are no more cells with data.

Navigates to the farthest contiguous cell with data to the right of the active cell. If the active cell has no data or the cell to the right does not have data, it will navigate to the start of the next cell that has data in that direction or the last cell in the row if there are no more cells with data.

Starts in place editing of the activeCell starting with the current value

Starts in place editing of the activeCell starting with an empty value

Changes the isInEndMode to true

The cell adjacent to the active cell in the direction indicated by the enterKeyNavigationDirection should be activated.

Ends edit mode of the activeCell and updates all the cells within the selection with an array formula from current edit value.

Ends edit mode of the activeCell and discards any changes made while editing.

Ends edit mode of the activeCell and updates the active cell's value based on the current edit value.

Ends edit mode of the activeCell and updates all the cells within the selection with the cell's value based on the current edit value.

Changes the isInEndMode to false

Navigates to the first cell in the row

Navigates to the upper left cell in view.

Changes the activeCell to be the upper left most cell in view within the active selection range.

Navigates to the first cell in the Worksheet.

Navigates to the cell of the first scrollable column in the row. This is the same as FirstCellInRow unless there are frozen panes and then the first scrollable column is based on the number of frozen column.

Navigates to the cell for the first scrollable row and column in the Worksheet. This is the same as FirstCellInView unless there are frozen panes and then the first scrollable row and column are based on the number of frozen rows and columns.

Navigates to the leftmost unlocked cell of the topmost row.

Changes the DisplayOptions of the active worksheet so that the first currently visible column will be frozen at the left and the right area can scroll from the next column until the last column.

Changes the DisplayOptions of the active worksheet so that the first currently visible row will be frozen at the top and the bottom area can scroll from the next row until the last row.

Sets the RowColumnBase.hidden to true for the columns associated with the activeSelection.

Sets the RowColumnBase.hidden to true for the rows associated with the activeSelection.

Increases the size of the font for the cell format of the current selection based on the current state of the active cell.

Increases the Indent of the cell format of the current selection based on the current state of each cell and potentially changing other properties such as horizontal alignment to one that supports indentation.

Inserts cells based on the current selection and shifts the cells based on where data is in adjacent cells.

Inserts cells before the cells associated with the current selection shifting the existing cells down.

Inserts cells before the cells associated with the current selection shifting the existing cells to the right.

Inserts columns before the columns associated with the current selection. If multiple columns are selected then multiple columns will be inserted.

Inserts a new Worksheet for each selected Worksheet before the active worksheet and activates the first new sheet.

Inserts rows before the rows associated with the current selection. If multiple rows are selected then multiple rows will be inserted.

Navigates to the lower right cell in view.

Changes the activeCell to be the lower right most cell in view within the active selection range.

Navigates to the rightmost unlocked cell of the bottommost row.

Navigates to the last row and column for which data or formatting have been provided.

Navigates the column of the end of the used range but stays within the current row of the active cell.

Merges the selected cells into one cell.

Merge the selected cells in one row into one cell.

Combine and center the contents of the selected cells into a new larger cell.

Executes the hyperlink associated with the selection when a single cell is selected.

Updates the selection based on the information in the clipboard.

Used to re-execute the last change operation that was undo, if possible.

Removes the vertical split and sets the LeftPaneWidth of the UnfrozenPaneSettings to 0.

Removes hyperlinks associated with the selected cells.

Removes the horizontal split and sets the TopPaneHeight of the UnfrozenPaneSettings to 0.

Removes both the horizontal and vertical splits so that there is only a single scrolling region remaining.

Enters edit mode on the tab associated with the active worksheet.

Resets the NameBoxWidth to its default value.

Scrolls the active pane's row scroll region down by 1 row.

Scrolls the active pane's column scroll region left by 1 column.

Increments the WorkbookWindowOptions.firstVisibleTabIndex to the next visible worksheet

Scrolls the active pane's row scroll region up by the size of the viewable area.

Scrolls the active pane's row scroll region down by the size of the viewable area.

Scrolls the active pane's column scroll region left by the size of the viewable area.

Scrolls the active pane's column scroll region right by the size of the viewable area.

Decrements the WorkbookWindowOptions.firstVisibleTabIndex to the previous visible worksheet

Scrolls the active pane's column scroll region right by 1 column.

Scrolls the tab area such that the first visible worksheet tab is in view

Scrolls the tab area such that the last visible worksheet tab is in view

Scrolls the active pane's row scroll region up by 1 row.

Changes the selection such that it only contains the ActiveCell.

Replaces the selection range containing the active cell with a selection range that encompasses the entire worksheet.

Selects all the visible worksheet tabs within the workbook

Selects from the active cell to the cell above the active cell.

Selects from the active cell to the cell below the active cell.

Selects from the active cell to the cell to the left of the active cell.

Scrolls up one page and selects from the active cell to a cell in the same column and relative visible row.

Scrolls down one page and selects from the active cell to a cell in the same column and relative visible row.

Scrolls left one page and selects from the active cell to a cell in the same row and relative visible column.

Scrolls right one page and selects from the active cell to a cell in the same row and relative visible column.

Selects from the active cell to the cell to the right of the active cell.

Selects from the active cell to the cell above the active cell that has data or the first cell in the column if there are none with data.

Selects from the active cell to the cell below the active cell that has data or the last cell in the column if there are none with data.

Selects from the active cell to the cell to the left of the active cell that has data or the first cell in the row if there are none with data.

Selects from the active cell to the cell to the right of the active cell that has data or the last cell in the row if there are none with data.

Replaces the selection range containing the active cell with a selection range that encompasses the columns for that range.

Selects the region associated with an array formula that is applied to the active cell.

Selects the cells adjacent to the active cell that have data or selects the entire worksheet if the current region is already selected or the current cell range selection isn't contained within the calculated current region.

Selects from the active cell to the farthest contiguous cell with data above the active cell. If the active cell has no data or the cell above does not have data, it will navigate to the start of the next cell that has data in that direction or the first cell in the column if there are no more cells with data.

Selects from the active cell to the farthest contiguous cell with data below the active cell. If the active cell has no data or the cell below does not have data, it will navigate to the start of the next cell that has data in that direction or the last cell in the column if there are no more cells with data.

Selects from the active cell to the farthest contiguous cell with data to the left of the active cell. If the active cell has no data or the cell to the left does not have data, it will navigate to the start of the next cell that has data in that direction or the first cell in the row if there are no more cells with data.

Selects from the active cell to the farthest contiguous cell with data to the right of the active cell. If the active cell has no data or the cell to the right does not have data, it will navigate to the start of the next cell that has data in that direction or the last cell in the row if there are no more cells with data.

Selects from the active cell to the first cell in the row

Selects from the active cell to the upper left cell in view.

Selects from the active cell to the first cell in the Worksheet.

Selects from the active cell to the cell of the first scrollable column in the row. This is the same as FirstCellInRow unless there are frozen panes and then the first scrollable column is based on the number of frozen column.

Selects from the active cell to the cell for the first scrollable row and column in the Worksheet. This is the same as FirstCellInView unless there are frozen panes and then the first scrollable row and column are based on the number of frozen rows and columns.

Selects from the active cell to the lower right cell in view.

Selects from the active cell to the last row and column for which data or formatting have been provided.

Selects from the active cell the column of the end of the used range but stays within the current row of the active cell.

Replaces the selection range containing the active cell with a selection range that encompasses the rows for that range.

Chnages the selection such that it only does not contain any hidden rows or columns.

The cell adjacent to the active cell in the reverse of the direction indicated by the enterKeyNavigationDirection should be activated.

Adjusts the width of the left row scroll region such that it is aligned to the edge of a column.

Adjusts the height of the top row scroll region such that it is aligned to the edge of a row.

Adjusts the height of the top and left scrolling regions such that they are aligned to the edge or a row and column respectively.

Changes the selectionMode to AddToSelection.

Changes the selectionMode to ExtendSelection.

Changes the selectionMode to Normal.

Changes the bold state of the cell format of the current selection based on the bold state of the active cell.

Used while in edit mode to change the cellEditMode and switch between the modes that control how the arrow keys are handled.

Changes the underline state of the cell format of the current selection based on the underline state of the active cell.

Changes the DisplayOptions of the active worksheet to add or remove frozen areas. If the worksheet currently has frozen areas then they will be removed. If the worksheet currently has unfrozen splits then they will be converted to frozen splits. Otherwise it will create frozen areas based on the current active cell.

Changes the italic state of the cell format of the current selection based on the italic state of the active cell.

Changes the DisplayOptions.showFormulasInCells of the selected worksheets.

Changes the DisplayOptions of the active worksheet to add or remove resizable split areas that are separately scrollable. If the worksheet currently has split areas then the splits will be removed. If the worksheet has frozen areas they will be converted to splits. Otherwise it will create split areas based on the current active cell.

Changes the strikethrough state of the cell format of the current selection based on the strikethrough state of the active cell.

Changes the subscript state of the cell format of the current selection based on the subscript state of the active cell.

Changes the superscript state of the cell format of the current selection based on the superscript state of the active cell.

Changes the underline state of the cell format of the current selection based on the underline state of the active cell.

Changes the wrap state of the cell format of the current selection based on the wrap state of the active cell.

Used to reverse the last change operation.

Sets the RowColumnBase.hidden to false for the columns associated with the activeSelection.

Sets the RowColumnBase.hidden to false for the rows associated with the activeSelection.

Split the current cell in multiple cells

Clears the selected worksheet tabs such that only the active tab is selected.

Changes the magnification of the currently selected Worksheet of the Spreadsheet to a higher value in increments of 10%

Changes the magnification of the currently selected Worksheet of the Spreadsheet to a lower value in increments of 10%

Changes the magnification of the currently selected Worksheet of the Spreadsheet to 100%

Changes the magnification of the currently selected Worksheet to display the currently selected cells.