SpreadSheet Basics
Last updated
Last updated
To enter data into SpreadSheet, click an empty cell.
Type a text or a number in a cell and then press Enter or Tab.
You can select several cells in one of the two ways:
By clicking the first cell and dragging the cursor to the last cell;
By clicking the first cell, then pressing Shift and clicking the last cell.
To select all cells, click the triangle in the top left corner.
Use this shortcut
To do this
Enter
Open editor in a cell.
Esc
Close editor in a cell.
Arrow keys
Navigate across cells.
Tab
Move focus to the next cell in a sheet.
Shift+Tab
Move focus to the previous cell in a sheet.
Shift+Arrow key
Extend cells selection by on cell.
Ctrl+Shift+Arrow key
Extend cells selection to the last nonempty cell in the same column/row. If the closest cell is empty, selection is extended to the next nonempty cell.
Ctrl+C
Copy the content of a cell.
Ctrl+V
Paste the content to a cell.
Ctrl+X
Cuts the content of a cell.
Ctrl+A
Select all cells in a sheet.
Ctrl+Z
Undo an action.
Ctrl+Y
Redo an action.
Ctrl+B
Make the selected text bold.
Ctrl+I
Make the selected text italic.
Ctrl+U
Make the selected text underlined.
Ctrl+Alt+S
Make the selected text strikethrough.
Ctrl+P
Call the print dialog window.
Ctrl+`
Show formulas in cells instead of values.
Ctrl+plus sign(+)
Zoom in
Ctrl+minus sign(-)
Zoom out
Ctrl+0
Reset the zoom level
Delete
Remove the content of a cell, or the character to the right of the insertion point (in the editing mode).
Backspace
Remove the content of a cell, or the character to the left of the insertion point (in the editing mode).
Use this shortcut
To do this
Command+C
Copy the content of a cell.
Command+V
Paste the content of a cell.
Command+Z
Undo an action.
Command+Shift+Z
Redo an action.
Command+A
Select all cells in a sheet.
Command+B
Make the selected text bold.
Command+I
Make the selected text italic.
Command+U
Make the selected text underlined.
Command+Shift+X
Make the selected text strikethrough.
Command+P
Call the print dialog window.
Command+`
Show formulas in cells instead of values.
Command+plus sign(+)
Zoom in
Command+minus sign(-)
Zoom out
Command+0
Reset the zoom level
To undo recent changes, click the Undo button.
To reapply changes once again, click the Redo button.