Skip to main content

Editing Spreadsheets

OfficeDocs includes a spreadsheet editor for working with Excel files and other spreadsheet formats. This guide introduces the main tools and features available when editing spreadsheets.

Spreadsheet editor overview

When you open a spreadsheet, the editor includes:

  • Toolbar: Formatting, formulas, and data tools
  • Formula bar: Displays and edits the contents of the selected cell
  • Column and row headers: Help identify cell locations
  • Cell grid: The main area for entering and editing data
  • Sheet tabs: Switch between worksheets
  • Status bar: Displays quick calculations and zoom controls

Working with cells

You can perform common actions directly in the spreadsheet.

Selecting cells

  • Click a cell to select it.
  • Click and drag to select a range.
  • Click a column header to select an entire column.
  • Click a row header to select an entire row.
  • Press Ctrl+A to select all cells.

Entering and editing data

  • Select a cell and start typing to enter data.
  • Press Enter to confirm and move down.
  • Press Tab to confirm and move right.
  • Press Esc to cancel editing.
  • Double-click a cell or press F2 to edit existing content.
  • Use the Formula bar to edit longer values or formulas.

Working with formulas

Formulas in OfficeDocs begin with the = sign.

Examples:

  • =A1+B1 to add two cells

  • =SUM(A1:A10) to total a range

  • =AVERAGE(B1:B20) to calculate an average

  • =IF(A1>10,"Yes","No") to apply conditional logic


For more advanced usage, refer to the Working with Formulas guide.

Formatting cells

OfficeDocs provides a range of formatting options, including:

  • Number formats such as currency, percentage, and dates
  • Font size, font color, and cell fill color
  • Borders and alignment
  • Text wrapping
  • Merging cells

Managing rows, columns, and sheets

You can adjust the structure of a spreadsheet as needed.

  • Insert or delete rows and columns
  • Resize rows and columns by dragging borders
  • Hide or unhide rows and columns
  • Rename, add, or remove sheets
  • Reference cells from other sheets in formulas

Data tools

OfficeDocs includes tools to help organize and analyze spreadsheet data.

  • Sort: Reorder data by column values
  • Filter: Show only rows that match selected criteria
  • Pivot Tables: Summarize larger datasets
  • Charts: Present data visually

Saving your work

Changes are saved automatically as you work. You can also press Ctrl+S to save manually. Spreadsheets can be downloaded in supported formats such as .xlsx, .ods, .csv, or .pdf.

Back to top