Google Sheets Formatting Tips: A 10-Minute Pass

To make a Google Sheet look professional in about ten minutes, work in one fixed order: fix the shape of the data, then set number formats, then set fonts and alignment, then size the columns, then style the header, then add any conditional formatting, then clear away the empty grid, then freeze the header row, and protect what matters last. The order is the whole trick. Most people format a sheet by clicking whatever bothers them next, which is why the same sheet gets its columns resized three times: every change to a number format, a font or a wrap setting changes how wide a column needs to be, so any width you set early gets thrown away.

What follows is that pass, with a minute budget per step, plus the places where Sheets genuinely behaves differently from Excel. It works on a sales export, a budget, a project tracker, or whatever you have to send someone by Thursday.

What's the right order to format a sheet in?

Here is the sequence. Ten minutes, nine steps, arranged so that nothing you do early gets undone by something you do later.

#	Minutes	What you do	Why it sits here
1	0:00 to 1:00	Fix the shape: one table per tab, headers on row 1, no blank rows or columns inside the data	Every later step targets a range. Change the range afterwards and you repeat all of it.
2	1:00 to 3:00	Set number formats column by column: currency, dates, percentages, counts	Formats change how wide the text renders. Do this before you touch widths.
3	3:00 to 4:00	Set the font and size once for the whole sheet, then alignment and text wrap	Also changes rendered width. Same reason as step 2.
4	4:00 to 5:30	Size columns and rows to fit	The first step where the rendered text is final, so the widths you set now survive.
5	5:30 to 7:00	Style the header row and pick a single accent colour	Needs finished columns, because a header's wrapping depends on its column width.
6	7:00 to 8:00	Add conditional formatting, if any earns its place	It sits on top of the palette, so you want the palette settled first.
7	8:00 to 9:00	Clear the empty grid: gridlines off, delete or hide unused rows and columns	Cosmetic and destructive at once. Do it after the data area is final.
8	9:00 to 9:30	Freeze the header row, and the first column if the table is wide	Freezing while you are still inserting rows means freezing twice.
9	9:30 to 10:00	Protect ranges, then look at the sheet the way the reader will	The last honest check before it leaves your hands.

1. Fix the shape first (1 minute)

Before anything visual, make the data a rectangle. One table per tab, a single header row at the top, no blank spacer rows, no stray notes parked three columns to the right of the data. This costs a minute and saves the whole rest of the pass, because every step below applies to a range, and a range that grows or moves invalidates the work.

If the file is genuinely messy rather than just plain, this is where the real time goes. The twelve-item pre-send checklist covers the specific repairs: numbers stored as text, trailing spaces, inconsistent dates, hidden columns. Run that first and come back to this pass afterwards.

2. Number formats, column by column (2 minutes)

This is the step with the largest return and the one people skip, because a column of raw numbers looks fine until you put it next to a column that has been formatted properly.

Select the whole column, not the cells you can currently see. In Sheets, click Format, then Number, then pick the format. For anything the presets do not cover, the same menu ends in Custom number format, which is exactly where Sheets diverges from Excel: there is no single multi-tab dialog behind Ctrl+1, just this one focused box. Google's help page on formatting numbers in a spreadsheet documents the path, and it lists separate instructions for Computer, Android and iPhone, which is a useful reminder that the mobile apps carry a much smaller formatting menu than the web editor.

Four decisions cover most sheets:

• Currency columns get a currency format with a fixed decimal count, applied to every cell in the column
• Dates get a real date format, not text that happens to look like a date
• Percentages get a percent format, so 0.14 reads as 14% and still sums correctly
• Counts and IDs get zero decimals, and IDs should not carry a thousands separator

The format-code grammar itself, the # versus 0 distinction, the four-section syntax and the trailing comma that scales to thousands, is the same idea in both products and is covered in the number formatting guide. You do not need to relearn it for Sheets. You only need to know that the door is in a different place.

3. Font and alignment (1 minute)

Select everything with Ctrl+A, set one font and one size, then apply alignment by column type: text left, numbers right, dates right. Turn on text wrap only for the columns that genuinely hold sentences, because wrap changes row height and row height changes how much of the table fits on one screen.

One font for the sheet is the default answer. If you want the reasoning behind which one, that is its own question, and the short version is that the choice matters far less than the consistency.

4. Size the columns (1.5 minutes)

Now, and only now, size the columns. Double-clicking a column border fits it to the widest cell, which is right most of the time and wrong for one specific case: a header longer than any value beneath it, which produces a column of numbers floating in white space. In that case shorten the header instead of widening the column.

Do rows too if you have turned on wrapping anywhere. A table with one 90-pixel row in the middle of 21-pixel rows reads as a mistake.

5. Header row and one accent colour (1.5 minutes)

Bold text, a solid fill, and nothing else. The full argument for restraint here, one accent colour plus greys and a strict budget for everything else, is in the seven rules for a professional-looking sheet, and it applies identically in Sheets.

The one thing worth checking rather than assuming: contrast. A mid-tone fill with white text is the most common failure, and it fails in a way you will not notice on your own bright monitor. The W3C's Contrast (Minimum) success criterion sets 4.5:1 for normal text and 3:1 for large text, defined there as 18 point or 14 point bold. A dark fill with white text or a pale fill with black text both clear it easily. A medium blue with white text often does not.

Banding is a separate decision, and Sheets makes it unusually easy to get wrong precisely because it is so easy to apply. It is worth the width test before you reach for it, which is what the post on alternating row colours is for.

6. Conditional formatting, if any (1 minute)

Add rules only where a reader would do something differently because of the colour. Sheets puts this at Format, then Conditional formatting, which opens a sidebar rather than a rule-manager dialog. The choice between data bars, colour scales and icon sets, and the reason a three-colour scale usually makes a table harder to read, is covered in conditional formatting that actually helps.

The reason this step comes after the header and the accent colour is simple: conditional formatting is the layer that sits on top. If you add it first and then pick a palette, half your rules will clash with the palette and you will edit them twice.

7. Clear the grid (1 minute)

Covered below in its own section, because Sheets handles the empty grid in a way Excel cannot.

8. Freeze the header (30 seconds)

Select the header row, then click View, then Freeze, then choose how many rows to freeze. Google's documentation on freezing, grouping, hiding and merging rows and columns gives the same path, and the same page notes that merging lives under Format, then Merge cells, which is a good moment to remember that merged cells break sorting and filtering. Excel's usual escape hatch for a centred title, Center Across Selection, has no obvious counterpart in the Sheets alignment options, so in Sheets the safer answer is to keep the title in its own row above the table rather than merging across it.

Freezing comes near the end because it is the only step that changes how the sheet scrolls, and you want to be done inserting and deleting rows before you pin anything.

9. Protect, then look at it (30 seconds)

Covered below. Then scroll the sheet from the top, at the zoom level a normal person uses, and read it as a stranger would.

Which Sheets features have no Excel equivalent?

The honest list is short, and the honesty matters, because plenty of advice presents renamed equivalents as exclusive features.

Genuinely different in Sheets:

• Alternating colours as a built-in. Google documents it as part of changing a cell's fill colour, so you reach it from the fill-colour control and pick Alternating colors; it also appears in the Format menu in current desktop builds. Excel has no single equivalent. There you either convert the range to a table or write a MOD(ROW(),2) conditional rule, and those two behave differently when the data is sorted.
• A grid that is actually finite. A Sheets tab has however many rows and columns you leave in it. Delete the empty ones and the sheet ends where your data ends. Excel worksheets are always the full grid.
• Version history you can format against. Because every change is versioned, you can try an aggressive palette, hate it, and roll the file back without keeping a "backup copy final v3" beside it.
• A collaborator's cursor. Formatting decisions in a shared file are made in front of an audience, which is a real constraint on how much you should change in a file other people are actively using.

Not exclusive, whatever you may have read:

• Paint format is Format Painter with a different name, down to the double-click behaviour for applying to several ranges.
• Conditional formatting exists in both. The rules behave differently enough to matter, but neither product invented it.
• Freeze panes exists in both, with a friendlier menu in Sheets.

The one place where Sheets is meaningfully behind is the custom number format dialog, which is a single text box rather than a full formatting workspace, and the alignment options, which give you no clean way to centre a title across columns without merging them.

How do you set number formats that survive collaborators?

A number format applied to the cells that currently hold data is a format that lasts until the next person pastes a row underneath it. Three habits fix that.

Apply to the column, not the selection. Click the column letter, then apply the format. New rows inherit it, including rows added by someone else at 11pm.

Paste format only, or paste values only, never a plain paste. A plain paste carries the source file's formatting into your carefully formatted column, which is how a sheet ends up with three date styles. Google's copy and paste documentation covers the paste-format-only option along with the paint format shortcuts, Ctrl+Alt+C and Ctrl+Alt+V on Windows, ⌘+Option+C and ⌘+Option+V on Mac.

Say what the unit is in the header. A column formatted as currency still does not tell anyone whether it is USD or AUD, or whether the figures are thousands. Put it in the header text. This is the cheapest protection there is against a collaborator "fixing" a format because they misread the numbers.

If a column absolutely must not be reformatted, that is a protection problem rather than a formatting problem, and the next section covers it.

What should you do about the endless empty grid?

Two moves, and Sheets supports the more aggressive one.

Turn the gridlines off. The View menu carries a gridlines toggle. It is display-only, it does not touch your data, and it makes the sheet read as a document rather than as a worksheet. What to add back afterwards, one rule under the header and one line above the totals, is covered in the professional-looking sheet rules.

Then actually shrink the grid. This is the Sheets-specific part. Select the first empty column to the right of your data, select through to the last column, and delete them. Do the same for the rows below your data. In Excel that would be pointless, because the worksheet is always its full size. In Sheets the tab genuinely ends where you tell it to, and there is a practical ceiling to work against: Google's stated Drive limits put a spreadsheet at up to 10 million cells or 18,278 columns, whether it was created in Sheets or converted from Excel. A tab you have trimmed to its data is a tab that costs almost nothing against that budget.

Deleting is better than hiding here. A hidden column reads to the next person as something you were concealing, and it will be found. Deleting is honest, and version history means it is reversible.

If you would rather keep the extra rows for future data, delete the columns and leave a modest number of rows. The visual noise comes mostly from the horizontal sprawl.

How do you protect the formatting when others edit?

Sheets has a real answer for this, and it is under Data, then Protect sheets and ranges, then Add a sheet or range. Choose a range or a whole sheet, then Set permissions. From there you get two genuinely different tools, and picking the wrong one is the usual mistake:

• Show a warning when editing this range lets anyone edit, but makes them confirm. This is the right setting for a formatted table that people legitimately need to update. It stops accidents without creating a bottleneck.
• Restrict who can edit this range blocks everyone except the people you list. Use this for the header row, a totals row, or a rate table that must not move.

Google's help page on protecting a sheet or range documents both, and it carries one caveat worth knowing before you go looking for the menu: if Protect sheets and ranges is not visible at all, the file is probably open in Office editing mode rather than as a native Sheet. Converting it to Sheets format brings the feature back.

A note on scope. Protection is a Sheets-side control over who can change what inside Google's editor. It is not a guarantee about what a downloaded copy of the file does in someone else's hands. If the file's next life is an .xlsx that someone opens on their laptop, verify the downloaded file rather than assuming the protection travelled with it.

What changes when the file is opened in Excel?

Most formatting survives an .xlsx export. The things that do not are predictable, and all of them are worth checking once rather than discovering in a client's inbox.

The grid comes back. Every row and column you deleted to make the sheet end neatly is restored, because an Excel worksheet is 1,048,576 rows by 16,384 columns by definition. Gridlines-off is a view setting that generally carries across; a trimmed grid is not a setting at all, it is a property of the Sheets file, and it has nothing to map onto.

Custom number formats mostly carry, but check the odd ones. Both products use the same four-section grammar, positive, negative, zero and text, separated by semicolons, which Microsoft sets out in its guidelines for customizing a number format. Standard currency, date and percent codes move without incident. Anything unusual is worth eyeballing in the export.

Fonts substitute. If you picked a font that is available in Sheets but not installed on the recipient's machine, Excel picks something else, and your column widths were set against the font you used. This is the single most common reason a file that looked right in the browser looks slightly wrong on someone else's screen.

Formatting has a ceiling. A workbook tops out at 65,490 distinct cell formats and cell styles, per the same Microsoft specifications page. You will not hit this by formatting a sheet by hand. You can hit it by applying formats to entire columns across dozens of tabs, so if a converted file starts behaving oddly, that limit is worth remembering.

The practical rule: download the .xlsx once and open it before you send it. Ninety seconds, and it catches all four of the above.

Or skip the pass entirely

The ten-minute routine is genuinely ten minutes once you know the order. If you would rather not run it, there is a shortcut for the specific case where the file's destination is Excel anyway.

Export the sheet as .xlsx or .csv, drop it into SuperSheet's Excel formatter, and it reads the file in your browser, infers a type for every column, and proposes a plan: real number formats, right-aligned numeric columns, an accounting-style format on currency, a live totals row written as real SUM formulas, a frozen header row and a theme. You untick anything you disagree with before it applies. Nothing is uploaded, there is no account, and your original file on disk is never touched. You get a new download.

It is worth being clear about what it deliberately does not do. It will not unmerge merged cells, and it will not split two tables sharing one tab. Both of those need a decision about what the structure should be, and a tool that guesses at that produces a worse file than one that leaves it alone. If your sheet has that shape, step 1 of the pass above is still yours to do. Everything after it is not.

If you are starting from a raw export rather than a Sheet, CSV to Excel converts and formats in one pass, and the templates page shows the five themes applied to a sample so you can see what each one does before you commit.

Frequently asked questions

How do I make Google Sheets look professional quickly?

Run the nine steps above in order and it takes about ten minutes on a typical sheet. If you only have two minutes, do three things: set the number formats on every numeric column, bold the header row with a single fill colour, and freeze the header row. Those three account for most of the difference between a sheet that reads as finished and one that reads as a scratchpad. Turning gridlines off is the fourth, and it is free.

Where are custom number formats in Google Sheets?

Select the cells or the whole column, click Format, then Number, then Custom number format at the bottom of that menu. This is one of the clearer differences from Excel, where the same feature is a tab inside the larger Format Cells dialog reached with Ctrl+1. Sheets has no equivalent multi-tab dialog, so if you go hunting for one you will not find it. The format codes themselves are broadly compatible between the two.

Does Google Sheets have Format Painter?

Yes, under the name Paint format. It is the paint roller icon in the toolbar. Select a cell with the formatting you want, click Paint format, then select the destination. Double-click the icon instead of single-clicking it to keep the tool active across several ranges, then click it again to stop. The keyboard route is Ctrl+Alt+C to copy formatting and Ctrl+Alt+V to apply it on Windows, or ⌘+Option+C and ⌘+Option+V on Mac.

Will my Sheets formatting survive an Excel export?

Mostly. Number formats, fills, borders, fonts, freeze panes and conditional formatting generally carry across into .xlsx. Three things do not survive cleanly: the trimmed grid, since an Excel worksheet is always its full 1,048,576 by 16,384 size, any font that is not installed on the recipient's machine, and unusual custom format codes. Download the file and open it once before sending. That single check catches essentially everything, and it takes less time than answering the email you would otherwise get back.