Format, sort and filter
Format numbers and cells, sort and filter tables, add conditional formatting, and freeze rows and columns
Format numbers
On the Home tab, choose a Number Format: General, Number, Currency, Financial, Percent, Scientific, Date, Long Date, Time, Date and Time, Duration or Plain Text. The buttons beside it switch to currency or percent, and add or remove decimal places.
Format cells
The Home tab also has:
- the font, size, bold, italic, underline and strikethrough;
- Text Colour and Fill Colour;
- Borders, for any side, in thin, medium, thick, dashed, dotted or double lines;
- alignment, and Wrap Text to fit long text in its cell;
- Merge Cells: Merge All, Merge Across or Unmerge;
- Clear Formatting.
Rows and columns
- Insert or delete rows and columns from the Insert tab, or by right-clicking a cell or header.
- Drag the edge of a header to resize it, or double-click the edge to fit what's in it.
- Right-click a header to hide it, show hidden ones, or Fit to Data.
Sort
Select the cells and choose Data › Sort, then Sort A to Z or Sort Z to A. To sort the whole sheet by one column, right-click the column's header.
Filter
Select a table
Select a table that has a header row.
Turn on the filter
Choose Data › Filter. Each header gets a filter button.
Choose what to show
Choose a column's filter button. Sort it, choose Filter by Condition (such as "Text Contains" or "Is Between"), or tick the values to show under Filter by Values. Choose Apply.
To show a column's rows again, open its filter button and choose Clear Filter. To remove the filter, choose Data › Filter again.
Conditional formatting
Conditional formatting colours cells by their value, for example to show overspending in red.
Open the rules
Choose Data › Conditional Formatting, then Add Rule.
Choose the cells and condition
Choose the Range, then a Condition, such as greater than, text contains, duplicate values, top values or above average. You can also choose Colour Scale or Data Bars.
Choose a style
Pick a style, such as Red, Green or Red Text, then choose Add Rule.
Freeze rows and columns
Choose View › Freeze to keep the top rows or first columns in place as you scroll, such as Freeze Top Row or Freeze First Column.
The View menu can also turn off Show Gridlines, or turn on Show Formulas (Ctrl + `) to see every formula instead of its result.
Find and replace
Press Ctrl + F, or Ctrl + H to replace. You can match case, match the entire cell, search inside formulas, or search every tab.
Comments and images
- To comment on a cell, choose Insert › Comment, or press Ctrl + Alt + M.
- To add a picture, choose Insert › Image. Right-click it to bring it to the front, send it to the back, reset its size or delete it.
Last updated on 13 November 2026