Skip to content
Sign inTry Sheets

Make every sheet easy to read

Number formats, fonts, colours and borders, and conditional formatting that colours cells by their values.

Conditional formatting

Style a cell when a condition holds: it's empty, contains some text, is a duplicate or in the top 10, or a formula of your own says so. Earlier rules win where they overlap.

Colour scales and data bars

Fill cells from one colour to another by value, or put a bar in each cell, its length by value.

Number formats

Currency, percentages, decimal places, dates and times, or a format code of your own. What you type is read as you'd expect: 12% is a percentage and $4.50 is money.

Fonts, colours and borders

Fonts and sizes, text and fill colours, borders, merging, wrapping and rotation. Paint format copies one cell's look to the next cells you select.

Rows, columns, sheets and printing

  • Freeze rows and columns

    Keep header rows or columns in place while the rest scrolls.

  • Resize and hide

    Resize rows and columns, fit them to their contents, or hide them.

  • Sheets as tabs

    Add, rename, reorder, colour, duplicate and hide the sheets in a file.

  • Print

    Print a sheet, the selection or every sheet, fitted to the page, with frozen rows repeated at the top of each page.

Work out the numbers together in Sheets

Every Business plan includes it, with Documents, Slides, Drive and the rest of your workplace.