1---2title: "Working with sheets"3sidebar_position: 14---56# Working with sheets78How to change what a sheet holds and how it looks, and the tools for9working with its data.10111213| Page | For |14|---|---|15| [Editing](editing.md) | Selecting, copy and paste, fill, undo, rows and columns, links |16| [Formatting](formatting.md) | Number formats, text styles, column and row formats, widths |17| [Sheets and tabs](sheets-and-tabs.md) | Several sheets: adding, moving, hiding |18| [Freeze, sort and filter](sort-filter.md) | Keeping headers on screen, sorting, filtering by values or conditions |19| [Tables](tables.md) | Named ranges with a header row that formulas read by column name, and that grow with their rows |20| [Find and replace](find-replace.md) | Searching one sheet, all of them or a range |21| [Conditional formatting and data validation](rules.md) | Coloring cells by their values; dropdowns, checkboxes and entry rules |22| [Pivot tables](pivots.md) | Summaries of a table on a sheet of their own, and frequency tables |23| [Notes and protection](notes-protection.md) | Notes on cells; ranges that warn before an edit |24| [Charts](charts.md) | Charts that float over the grid |25| [Macros](macros.md) | Recording and running what you do |26| [Locale](locale.md) | Decimal commas, date order, currency and `;` in formulas, as a country writes them |