រៀនពីរបៀបប្រើ Keyboard shortcuts in Excel

Excel Online commands

To do this	Press
Move between ribbon and workbook content	Ctrl+F6
Activate a different ribbon tab	Tab and then Enter
Move among ribbon commands	Tab
Execute the currently selected ribbon command	Enter

Work with worksheets

To do this	Press
Find	Ctrl+F, or Shift+F5
Repeat Find down	Shift+F4
Repeat Find up	Ctrl+Shift+F4

Move and scroll within worksheets

To do this	Press
Up one cell	Up Arrow, or Shift+Enter
Down one cell	Down Arrow, or Enter
Right one cell	Right Arrow, or Tab
Left one cell	Left Arrow, or Shift+Tab
Beginning of the row	Home
Go to A1	Ctrl+Home
Last cell of used range	Ctrl+End
Move down one screen	Page Down
Move up one block of rows	Page Up

Work with objects

To do this	Press
Open menu/Drill down	Alt+Down Arrow
Drill up	Alt+Up Arrow
Follow hyperlink	Ctrl+Enter
Open Comment pane	Shift+F2

Select cells, rows and columns, and objects

To do this	Press
Range of cells	Shift+Arrow keys
Entire column	Ctrl+SPACE
Entire row	Shift+SPACE
To beginning of row	Shift+Home
Up block of cells in current column	Shift+Page Up
Down block of cells in current column	Shift+Page Down

Move within a selected range

To do this	Press
From top to bottom (or forward through selection)	Enter
From bottom to top (or back through selection)	Shift+Enter
Forward through a row (or down through a single-column selection)	Tab
Back through a row (or up through a single-column selection)	Shift+Tab

Calculate data

To do this	Press
Calculate workbook (refresh)	F9
Full calculate	Ctrl+Shift+Alt+F9

Refresh external data

To do this	Press
Refresh	Alt+F5
Refresh all	Ctrl+Alt+F5

Edit cells

To do this	Press
Cut	Ctrl+X
Copy	Ctrl+C
Paste	Ctrl+V
Undo	Ctrl+Z
Redo	Ctrl+Y

Enter data

To do this	Press
Complete cell entry and select the cell below	Enter
Complete cell entry and select the cell above	Shift+Enter
Complete cell entry and select the next cell in the row	Tab
Complete cell entry and select the previous cell in the row	Shift+Tab
Cancel cell entry	Esc
Start a new line in the same cell	Alt+Enter
Insert hyperlink	Ctrl+K
Insert Table	Ctrl+L

Edit data within a cell

To do this	Press
Edit selected cell	F2
Clear selected cell	Delete
Clear selected cell and start editing	Backspace
Move right one character	Right Arrow
Move left one character	Left Arrow
Move right one word	Ctrl+Right Arrow
Move left one word	Ctrl+Left Arrow
Go to beginning of cell data	Home
Go to end of cell data	End
Select right by character	Shift+Right Arrow
Select left by character	Shift+Left Arrow
Select right by word	Shift+Ctrl+Right Arrow
Select left by word	Shift+Ctrl+Left Arrow
Select to beginning of cell data	Shift+Home
Select to end of cell data	Shift+End
Copy	Ctrl+C
Cut	Ctrl+X
Paste	Ctrl+V

Format cells

To do this	Press
Bold	Ctrl+B
Italics	Ctrl+I
Underline	Ctrl+U