Ctrl+Shift+O: To select all the cells with comments. If there are no cells with contents then you will get ‘No cells found’ message.
Ctrl+[ : To show which are the related cells in the selected formula.
Ctrl+] : To show the related formulas of the selected cell.
Shift+Arrow key : The selection will be extended to one more adjacent cell.
Ctrl+Shift+Arrow key : The selection will be extended to the last cell with data either horizontally or vertically based on your current selection.
Shift+Home : The selection will be extended to the first cell horizontally.
Ctrl+Shift+Home : Selection will be extended to the first cell in the worksheet.
Ctrl+Shift+End: Selection will be extended until the last cell in the worksheet/.
Enter: Cursor will be moved to the next cell below the current cell.
Ctrl+[ : To show which are the related cells in the selected formula.
Ctrl+] : To show the related formulas of the selected cell.
Shift+Arrow key : The selection will be extended to one more adjacent cell.
Ctrl+Shift+Arrow key : The selection will be extended to the last cell with data either horizontally or vertically based on your current selection.
Shift+Home : The selection will be extended to the first cell horizontally.
Ctrl+Shift+Home : Selection will be extended to the first cell in the worksheet.
Ctrl+Shift+End: Selection will be extended until the last cell in the worksheet/.
Enter: Cursor will be moved to the next cell below the current cell.
No comments:
Post a Comment