Explanation

The Editing group contains tools for quickly working with and analyzing worksheet data.

AutoSum

AutoSum quickly inserts a SUM formula to calculate totals.

Example:

=SUM(B2:B10)

Fill

The Fill command helps copy data or formulas into adjacent cells.

Clear

Clear can remove:

  • Contents
  • Formats
  • Comments/notes or other supported elements

Sort

Sort arranges data in a specific order.

Examples:

  • A to Z
  • Z to A
  • Smallest to Largest
  • Largest to Smallest

Filter

Filter displays only the records that meet selected conditions.

Find

Find searches for specific text, numbers or other content.

Ctrl + F

Replace

Replace changes matching content with new content.

Ctrl + H

Go To

Go To allows you to quickly move to a specific cell or range.

Ctrl + G

Practice

Using a student marks table:

  1. Calculate total marks using AutoSum.
  2. Sort students by marks.
  3. Filter students with marks above a selected value.
  4. Find a student’s name.
  5. Replace a value.
  6. Use Go To to move to a specific cell.
PreviousNext