Enter and edit data
Updated November 17, 2026
Type and edit
- Click a cell and type. Press Enter to go down, Tab to go right, Shift+Enter or Shift+Tab to go back.
- To change what’s in a cell, double-click it or press F2, then edit.
- Press Esc to cancel an edit.
Handy ways to enter data
- A new line in a cell: press Alt+Enter (Option+Enter on a Mac) while typing.
- The same entry in every selected cell: select the cells, type, then press Ctrl+Enter.
- Today’s date or the time: Ctrl+; puts in today’s date, Ctrl+Shift+; the current time.
- Fill down or right: select a range starting with the cell to copy, then Edit › Fill Down (Ctrl+D) or Fill Right (Ctrl+R). Home › Fill cells has these and more.
- Fill a series: drag the small square at the corner of the selection to continue numbers, dates or months.
- Flash Fill: type one or two examples next to your data, then choose Data › Flash fill (Ctrl+E) to fill the rest the same way.
More ways to fill
Home › Fill cells opens the Fill menu:
- Down, Right, Up and Left copy the row or column at one edge of the selection through the rest of it, formulas adjusted as they go. Down copies the top row, Right the left column, Up the bottom row and Left the right column.
- Across Worksheets… copies the selection to the same cells on the other sheets you’ve grouped.
- Series… fills a series you set exactly. Select the cells, starting with the first value, then choose:
- Series in: Rows or Columns.
- Type: Linear adds the step each time, Growth multiplies by it, Date steps by Day, Weekday, Month or Year, and AutoFill continues the pattern as dragging the corner square would.
- Step value, and an optional Stop value: the series ends before it would pass it, and the cells after that are left as they were.
- Justify joins the text in the selection’s first column and lays it out again to fit the width of the selected columns, one line to a row. If it needs more rows than you selected, it asks first and goes on into the cells below. It works on text only, not numbers or formulas.
- Flash Fill is here too.
One Undo (Ctrl+Z) takes back each fill.
Clear cells
- Press Delete to clear what’s in the selected cells. Their formatting stays.
Need more? Keyboard shortcuts.