SpreadSheet Basics

Entering Data

  • To enter data into SpreadSheet, click an empty cell.
  • Type a text or a number in a cell and then press Enter or Tab.

Selecting Multiple Cells

You can select several cells in one of the two ways:
  1. 1.
    By clicking the first cell and dragging the cursor to the last cell;
  2. 2.
    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.
Selecting All Cells

Keyboard Shortcuts in SpreadSheet

Windows OS

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.

Mac OS

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.

Canceling/Repeating Actions

  • To undo recent changes, click the Undo button.
  • To reapply changes once again, click the Redo button.
Undo/Redo buttons