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.