Excel Online: How to Insert, Format, and Manage Tables

How-to basics · Updated November 18, 2026

To insert a table in Excel Online, select the range of cells containing your data, then choose Insert > Table. Check that the range is correct, indicate whether it includes headers, and confirm; Excel for the web will turn the range into a table with filter controls and table formatting.

What an Excel table does

An Excel table is a structured way to organize related rows and columns. It is more than a colored block of cells: Excel treats the selected range as a named object, which makes it easier to sort and filter records, apply consistent formatting, and work with data that grows over time. For example, a list of orders with columns for Order Date, Customer, Product, and Amount can become a table that users can filter by customer or sort by date.

A normal cell range can hold the same information, but it does not automatically provide all the table features. A table supplies filter buttons in its header row, applies a consistent style, and can extend when you add data immediately beside or below it. Excel can also use table and column names in formulas, which can be easier to understand than references to cell coordinates.

Excel Online is the browser version of Excel, also called Excel for the web. Its menus and table features are similar to those in the Microsoft 365 desktop app, though some ribbon details and available options can differ.

Insert a table step by step

  1. Open the workbook in Excel for the web and go to the worksheet containing the data.
  2. Select the full data range, including the header row if one exists. Include all columns and records that belong together, but avoid including unrelated notes or blank rows.
  3. Choose Insert > Table from the ribbon.
  4. Review the range shown in the dialog. Correct it if the selection omitted a column or included cells outside the data.
  5. If the first row contains column names, select the option indicating that the table has headers. If the range has no header row, leave that option unchecked.
  6. Confirm the dialog. Excel creates the table and displays filter controls in its header row.

If the worksheet is empty, first select the cells you want the table to occupy and use the same Insert > Table command. For a table that will hold records, it is usually clearer to enter the column headings before creating it, then select the headings and the rows beneath them. This helps Excel identify the intended header row.

As a concrete example, suppose A1:D4 contains a header row and three order records. Select A1:D4, choose Insert > Table, and confirm that the displayed range is A1:D4 and that the range has headers. The resulting table has four columns and three data rows. If you selected only A1:C4 by mistake, the Amount column would be left outside the table, so checking the range matters.

Prepare the range and headers

Tables work best when each column represents one kind of information and each row represents one record. Before inserting one, check that the data is rectangular: every record should use the same set of columns, without merged cells or decorative blank rows breaking up the list. A blank cell within a record is fine; a completely empty row between groups can make Excel interpret the selection as more than one block or include unwanted space.

Use one descriptive heading per column, such as Date, Region, or Quantity. Avoid leaving header cells empty or using the same label repeatedly. Clear headings help people understand the data and make sorting and filtering more useful. If the range does not have headers, Excel can create generic column headings, which you can replace afterward.

  • Keep each column consistent: store dates in a date column, not mixed with explanatory text.
  • Remove merged cells from the intended table range; merged layouts are designed for presentation, not tabular records.
  • Check for a totals line at the bottom. If it is part of the data rather than a calculated summary, decide whether it belongs in the table before creating it.
  • Include the full set of related columns. A table containing only part of a record makes filtering and analysis less reliable.

Headers, styles, filters, and totals

After creation, the header row identifies each column and provides a drop-down control for sorting and filtering. Use a column’s drop-down to sort its values or narrow the visible records. For instance, a Region filter can show only orders from one region without deleting the others; clearing the filter restores the hidden records.

Table formatting helps distinguish headings, data rows, and—depending on the chosen style—alternating bands. You can change the appearance using the table-formatting options available on the ribbon. Styles affect presentation, not the underlying values. If a workbook has a required visual design, choose a style with sufficient contrast and make sure the header labels remain readable.

Excel tables can also include a totals row. When available in the table options, turn it on and choose a summary operation for a column, such as a sum or count. The totals row is separate from ordinary data records, so it is useful for a summary that should not be sorted or filtered as though it were another order. Check the selected operation before relying on the displayed result.

When a formula is entered in a table column, Excel can extend it through the column as a calculated column. Table references may also use names such as the table name and column name rather than plain cell addresses. This can make a formula easier to follow when the table changes size, although readers should still check that the formula refers to the intended column and records.

Adding rows, columns, and changing table contents

To add a record, enter data in the row immediately below the table or use the table’s last row and continue into the next row. Excel commonly expands the table when new data is entered directly adjacent to it. After adding records, check that the new row received the table style and that filters and any calculated-column formulas cover it. Pasting a block with blank rows or unrelated columns next to the table may not produce the expansion you expect.

To add a field, enter a heading and values in the column next to the table. If Excel does not include that column, select the table range and adjust it through the table’s resize option if that option is available in the current ribbon. You can also correct the range by selecting the full intended data and creating a new table, but be careful not to create overlapping tables. Editing an existing heading changes the label used for that table column; it does not automatically change the meaning of the data beneath it.

To change an ordinary table cell, select it and type or paste the replacement value. Sorting and filtering do not erase records, but they can change which records are visible and their order. If a record seems to have disappeared, clear the active filters before assuming it was deleted.

Common problems and how to fix them

  • The header row shows generic names. The range may have been created without the headers option selected. Edit the visible headings, or recreate the table with the correct header setting if necessary.
  • A column is missing from the table. The selected range may have stopped short. Expand or resize the table so it includes the complete column, including its heading and records.
  • Some records are not visible. A filter may be active. Open the relevant header drop-down and clear the filter, or clear filters for the table.
  • New data is not styled or filtered. The new cells may not be part of the table. Add the data directly beside the table or adjust the table range, then verify that the header filters cover the intended columns.
  • Sorting puts values in an unexpected order. A column may contain mixed data types—for example, dates stored as text alongside real dates. Make the values consistent, then sort again.
  • Blank rows appear as records. The selected range may have included extra worksheet rows. Remove the unwanted rows from the table range or resize it to the actual data.

Undo can help if you have just made an accidental change, but it is not a substitute for checking a workbook’s shared or important data before making structural edits. If the table is used by other people, tell collaborators before changing its columns or removing records.

Excel for the web compared with desktop Excel

The core workflow—select the data and use Insert > Table—is available in Excel for the web and desktop Excel. A workbook with a table can also be opened in either environment, and ordinary table data, filters, and styles are generally useful across both. The desktop app may display additional contextual commands or arrange them differently from the browser ribbon, so follow the labels shown in the version you are using.

Excel for the web is convenient when you need to make a table in a browser or collaborate on a workbook stored online. The desktop app can be preferable for complex workbook maintenance or features that are not offered in the web interface. If a command is missing in the browser, opening the workbook in the desktop app may provide another route; it does not mean the table itself cannot be used online.

Keyboard shortcuts can also behave differently in a browser because the browser may reserve a key combination for its own controls. The Insert > Table ribbon command is a dependable method when you are unsure which shortcut applies.

Sharing and maintaining a table

Tables are often used in shared workbooks because filters and clear headings make records easier to inspect. Before sharing, give the table meaningful column names, remove test rows, and check that filters are not leaving an unexpectedly narrow set of records visible. A filter changes the view, not the underlying data, but another reader may mistake a filtered list for the complete dataset.

When a table feeds a chart, formula, or another part of a workbook, changes to its structure can affect those dependent elements. Renaming a heading, deleting a column, or moving records may change what a formula or report uses. Keep a copy or use the workbook’s available version history when a structural change could affect other users. For a small personal list this may be unnecessary; for a shared order or inventory register it is a sensible safeguard.

When a table is the right choice

Use a table for a list that has a header row and repeated records, such as expenses, contacts, survey responses, or stock items. It is especially useful when you expect to sort, filter, add records, or refer to columns in formulas. A table does not replace every worksheet layout: a formatted report with merged headings, subtotals between groups, or several unrelated blocks may be better left as ordinary ranges.

If you only want color or borders, applying cell formatting does not require creating a table. Conversely, selecting a table style is not the same as inserting a table: the table object is what provides structured headers and built-in filtering. Choose based on how the data will be used, not just on whether you want a shaded header.

Frequently Asked Questions

Can I insert a table in Excel Online for free?
Excel for the web is available through a web browser with a Microsoft account, subject to Microsoft’s current service and account terms. Table creation is a standard spreadsheet task in the web app. Account features and storage arrangements can vary, so check Microsoft’s current offering if you need details about a particular plan.

How do I make the first row a header in Excel Online?
Select the data range, choose Insert > Table, and select the option that says the table has headers before confirming. If the table already exists, edit its header cells to use clear column names.

How do I remove a table but keep the data?
Look for the table conversion or range option in the table-specific ribbon controls and choose the command to convert the table to a range, if it is available in your web interface. Confirm the prompt. The cells remain, but table behavior such as its structured table identity and built-in filter controls no longer applies in the same way; you can add ordinary formatting or filters separately.

Why can’t I see every row after inserting a table?
Check the filter controls in the header row. One or more columns may be filtered, hiding records without deleting them. Clear the active filters to show all rows again.

Can I add a table to an empty worksheet?
Yes. Select the cells you want the table to cover and choose Insert > Table. For a useful data table, enter column headings and records afterward, then check that the table range and header setting are correct.

Does a table automatically include new rows?
Excel commonly expands a table when you type or paste data directly next to it, particularly in the row immediately below. If the new cells are not included, resize the table or adjust its range and verify that the new records are covered by filters and formatting.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.