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 |