| .. | ||
| _category_.json | 116B | |
| charts.md | 3.4K | |
| editing.md | 3.5K | |
| find-replace.md | 850B | |
| formatting.md | 8.5K | |
| locale.md | 6.0K | |
| macros.md | 6.5K | |
| notes-protection.md | 1.9K | |
| pivots.md | 4.2K | |
| README.md | 1.4K | |
| rules.md | 10.3K | |
| sheets-and-tabs.md | 1004B | |
| sort-filter.md | 1.3K | |
| tables.md | 5.2K |
title: "Working with sheets" sidebar_position: 1
Working with sheets
How to change what a sheet holds and how it looks, and the tools for working with its data.

| Page | For |
|---|---|
| Editing | Selecting, copy and paste, fill, undo, rows and columns, links |
| Formatting | Number formats, text styles, column and row formats, widths |
| Sheets and tabs | Several sheets: adding, moving, hiding |
| Freeze, sort and filter | Keeping headers on screen, sorting, filtering by values or conditions |
| Tables | Named ranges with a header row that formulas read by column name, and that grow with their rows |
| Find and replace | Searching one sheet, all of them or a range |
| Conditional formatting and data validation | Coloring cells by their values; dropdowns, checkboxes and entry rules |
| Pivot tables | Summaries of a table on a sheet of their own, and frequency tables |
| Notes and protection | Notes on cells; ranges that warn before an edit |
| Charts | Charts that float over the grid |
| Macros | Recording and running what you do |
| Locale | Decimal commas, date order, currency and ; in formulas, as a country writes them |