Total Pageviews

Followers

Search This Blog

Thursday 28 May 2020

Excel Key Board shortcuts: Excel Editing shortcuts

Happy morning students. Today let us learn keyboard editing excel shortcuts :
Keyboard shortcuts
Editing shortcuts
F2 Edit active cell
F3 Paste name into a formula
F4 Toggle references
ALT + ENTER Start a new line within the same cell
SHIFT + F2 Insert or edit cell comment
SHIFT + F10 Display shortcut menu (i.e. same as right click)
SHIFT + F11 Insert worksheet
CTRL + F3 Defne a name for a cell
CTRL + D Fill down (e.g. copy formula down in selected cells)
CTRL + R Fill right
CTRL + SHIFT + A Insert argument names and parentheses for a
function after typing a function name in a formula
SHIFT + SPACEBAR Select entire row
ALT + I + R Insert row
ALT + I + C Insert column

No comments:

Post a Comment