Tag

EXCEL KEYBOARD SHORTCUTS

Browsing
Move to Right Edge in the Dataset 2

The navigation shortcut key in the Excel END+RIGHT Arrow key helps the user to Move to Right Edge in the Dataset. i.e, the rightmost non-blank cell in the data.
When an empty cell is found in a data region and when the End+Right is applied from below it, it will stop below the empty cell.
To reach further up press End+Right arrow key.

Move to Right Edge in the Dataset
Move to Left Edge in the Dataset 4

The navigation shortcut key in the Excel End+LEFT Arrow key helps the user to reach the leftmost cell of that row.
However when an empty cell is found in a data region and when the End+Left Arrow Key is applied it stops in a cell containing data.

Move to Left Edge in the Dataset 5
Move to Top Edge in the Dataset 7

The navigation shortcut key in the Excel End+UP Arrow key helps the user to reach the topmost row.
When an empty cell is found in a data region and when the End+Up is applied from below it, it will stop below the empty cell.
To reach further up press End+Up arrow key.

Move to Top Edge in the Dataset 8
Move to Bottom Edge in the Dataset 10

The navigation shortcut key in the Excel END+Down Arrow key helps the user to reach the bottom-most row or column.
When an empty cell is found in a data region and when the End+Down Arrow Key is applied from below it, it stops before the empty cell.
To reach further down press End+Down arrow key.

Move to Bottom Edge in the Dataset
Copy Value From the Cell Above 12

Ctrl-Shift ” is used to copy the value from the cell above to the active cell below.
When we click Ctrl-Shift “ the cell value gets copied in the active cell. If there is any formula applied to the above cell, it copies only the values and not the formula. This shortcut only works for columns. You cannot copy the cell values horizontally.

Copy Value From the Cell Above 13
Copy Value From the Cell Above 14