sodcalculator

10 Tech How-To

How to Create and Format Tables in Google Sheets

Guide 10-50905 · Updated · Step by step

This guide walks you through building a clean, functional table in Google Sheets—from entering your data and applying table formatting to sorting, filtering, and styling. You’ll learn the essential steps to turn a plain grid of cells into a readable, professional-looking table that’s easy to update and share. No prior spreadsheet experience is needed, just a Google account and a browser.

What You’ll Need

  • A Google account (free) to access Google Sheets.
  • A web browser (Chrome, Firefox, Safari, or Edge) or the Google Sheets mobile app.
  • Your data ready—either typed directly or copied from another source.

Step-by-Step

  1. Open Google Sheets and create a new spreadsheet. Go to sheets.google.com and click the blank spreadsheet icon, or open an existing file where you want the table.
  2. Enter your data. Type your column headers in the first row (e.g., Name, Date, Amount). Then fill in the rows below with your data. Use one column per field, and one row per record.
  3. Select the entire data range. Click the top-left cell of your table (e.g., A1), then drag to the bottom-right cell (e.g., D20). Alternatively, click the first cell, hold Shift, and click the last cell.
  4. Apply the table style. With your range selected, go to the menu Format > Alternating colors. Choose a color scheme from the sidebar that appears. This adds banded rows, making your table easier to read. Click Done.
  5. Make the header row stand out. Still with the range selected, click Format > Bold (or press Ctrl+B / Cmd+B) to bold the header row. You can also add a background color: select the header row cells, click the paint bucket icon in the toolbar, and pick a fill color.
  6. Adjust column widths and row heights. Hover over the line between column letters (e.g., between A and B) until the cursor becomes a double arrow, then drag to resize. Repeat for rows if needed. For auto-fit, double-click the line.
  7. Format numbers and text. Select the cells you want to format (e.g., the Amount column). Use the toolbar: click the “123” dropdown to choose Number, Currency, Percent, or Date. For text alignment, use the alignment buttons (left, center, right).
  8. Add borders. To give your table clear cell boundaries, select the range, click the borders icon (a square with a grid) in the toolbar, and choose “All borders” or a custom style.
  9. Freeze the header row. If your table is long, keep the header visible: click View > Freeze > 1 row. This locks the top row when scrolling.
  10. Sort and filter your table. Select the header row, then click the filter icon (a funnel) in the toolbar. This adds dropdown arrows to each header. Click an arrow to sort A→Z or Z→A, or to filter by values.
  11. Name your table (optional). If you plan to reference the table in formulas or charts, give it a named range: select the range, go to Data > Named ranges, enter a name (e.g., “SalesData”), and click Done.

Common Mistakes

  • Leaving blank rows or columns. Gaps in your data can break sorting and filtering. Keep your table contiguous.
  • Mixing data types in a column. For example, having some cells as text and others as numbers in the same column can cause sorting errors. Keep each column consistent.
  • Not freezing the header row. When you scroll down, you lose track of what each column means. Always freeze the top row.
  • Using merged cells. Merged cells can interfere with sorting, filtering, and formulas. Avoid merging in the main table area.
  • Applying formatting to individual cells instead of the whole range. This creates inconsistent styling. Format the entire table range at once.

Tips

  • Use keyboard shortcuts. Ctrl+B (bold), Ctrl+Shift+1 (number format), Ctrl+Shift+4 (currency) speed up formatting.
  • Leverage the “Alternating colors” feature. It automatically updates if you add rows, keeping your table neat.
  • Create a table style with conditional formatting. Highlight cells that meet certain criteria (e.g., amounts above $100) by going to Format > Conditional formatting.
  • Use data validation for consistent entry. For columns with limited options (e.g., status), go to Data > Data validation and create a dropdown list.
  • Convert your range to a real table (Google Sheets “Table” feature). In newer versions, you can select your range and press Ctrl+Shift+T to create a Table object, giving you structured references and automatic filters.

Troubleshooting

  • Alternating colors won’t apply. Make sure you have selected a contiguous range. If you have merged cells or blank rows, the feature may fail. Remove merges and fill blanks first.
  • Sorting messes up the table. This usually happens when you sort only one column instead of the entire range. Select all columns in your table before sorting, or use the filter dropdown on the header (which sorts the whole range).
  • Filter arrows are missing. You may have turned off the filter. Go to Data > Turn off filter (or turn on). Also check that the header row is not part of a merged cell.
  • Numbers are being treated as text. If sorting puts numbers in odd order, select the column, go to Data > Split text to columns (or use Format > Number > Automatic). Sometimes you need to re-enter the numbers.
  • Formatting disappears when adding rows. Use the “Alternating colors” feature instead of manual row shading—it extends automatically. For borders, you may need to reapply after adding rows, but using a Table (Ctrl+Shift+T) keeps formatting consistent.

Frequently Asked Questions

Can I convert an existing range to a table in Google Sheets?

Yes. Select the range and press Ctrl+Shift+T (or go to Insert > Table). This creates a Table object with built-in filters, structured references, and automatic formatting.

How do I remove a table format but keep the data?

Select the range, go to Format > Clear formatting (or press Ctrl+\) to remove all formatting. This does not delete the data. If you have a Table object, right-click and choose “Convert to range.”

Why can’t I sort my table correctly?

Check for blank rows or columns within your range, and make sure all columns are selected. Also ensure that each column contains consistent data types (all numbers or all text).

How do I add a total row to my table?

You can add a row below your data and use formulas like =SUM(B2:B10). If you’re using a Table object, check the “Show total row” option in the table design menu.

Can I create a table on the Google Sheets mobile app?

Yes, the mobile app supports basic formatting, sorting, and filtering, but some features like alternating colors are limited. For full functionality, use a desktop browser.

How do I make a table print nicely?

Set the print area to your table range (File > Print > Set print area), choose “Fit to page” under scale, and enable gridlines or borders for clarity.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →