Start with a blank spreadsheet and enter your headers
Open Excel and you will see a grid of empty cells. The first row is where you put your column headers — the labels that tell you what each column contains. Click on cell A1 (the top-left cell) and type your first header. For example, if you are tracking a household budget, you might type "Date" in A1.
Press Tab to move to cell B1 and type your second header — perhaps "Category". Keep pressing Tab and typing headers across the row until you have named all your columns. When you finish the last header, press Enter to move down to the next row. You are now ready to enter data.
Key Takeaways
- Headers go in the first row and should describe what each column contains — use Tab to move between cells in the same row.
- Data starts in row 2 and goes down; each row is one record, and each column is one piece of information about that record.
- Selecting your data range and using the Format as Table button turns raw data into a table with sorting and filtering built in.
- Tables automatically expand when you add new rows below them, so you do not have to reformat every time your data grows.
- Freezing the header row keeps your column names visible when you scroll down through many rows of data.
Enter your data row by row, keeping one record per row
Each row below the headers holds one complete record. If you are tracking expenses, one row is one purchase. If you are tracking contacts, one row is one person. Click on cell A2 and type the first piece of data. Press Tab to move to B2 and enter the next piece of information for that same record.
When you reach the end of the row, press Enter to jump to the next row and start over. This pattern — Tab to move right, Enter to move down — is faster than clicking individual cells. Keep entering data until you have filled in all your records. Do not skip rows or leave blank cells in the middle of your data, because Excel's sorting and filtering tools work best when your data is solid and unbroken.
Select all your data and convert it to a formatted table
Once your data is entered, select the entire range from your first header to your last data cell. Click on cell A1, then hold Shift and click on the last cell that contains data. The whole range will highlight in blue. Alternatively, click on A1 and press Ctrl+Shift+End (on Windows) or Command+Shift+End (on Mac) to select to the end of your data automatically.
With your data selected, go to the Home tab at the top of the screen. Look for a button labeled "Format as Table" — it usually shows a small grid icon. Click it and choose a table style from the menu. Excel will ask you to confirm that your data has headers; make sure "My table has headers" is checked, then click OK. Your data is now a formatted table with built-in sorting and filtering.
Use the filter buttons to sort and find specific rows
When you format data as a table, Excel adds a small dropdown arrow to each header cell. Click any of these arrows to sort your data or show only certain rows. For example, if your table tracks expenses by category, click the dropdown arrow in the Category column and uncheck "Groceries" to hide all grocery rows temporarily. The rows are still there — they are just hidden from view.
To sort, click the dropdown arrow and choose "Sort A to Z" or "Sort Z to A" for text, or "Sort Smallest to Largest" for numbers. You can also click "Sort by Color" if you have colored cells. These sorting and filtering options save time when your table grows to hundreds of rows and you need to find or organize specific information quickly.
Freeze the header row so it stays visible when you scroll
When your table has many rows, scrolling down will eventually hide your headers. To keep the header row visible at all times, click on any cell in row 2 (the first data row, not the header). Then go to the View tab at the top and click "Freeze Panes". Excel will lock row 1 in place so that as you scroll down, the headers remain at the top of your screen.
If you want to unfreeze later, go back to the View tab and click "Freeze Panes" again — it will toggle off. This feature is especially useful for tables with many columns or many rows, because you can always see what each column represents no matter where you are in the data.
Resize columns to fit your content and improve readability
By default, all columns are the same width, which may be too narrow for some text or too wide for short entries. To adjust a single column, position your cursor on the line between two column letters at the top (for example, between A and B). Your cursor will change to a resize arrow. Double-click and Excel will automatically fit the column width to its content.
To resize all columns at once, click the select-all button (the small square in the top-left corner where the row numbers and column letters meet), then double-click any column divider. All columns will auto-fit to their content. You can also drag the column divider left or right to set a custom width. Readable columns make your table easier to scan and less prone to data-entry errors.
Add new rows and columns as your table grows
One advantage of a formatted table is that it expands automatically. If you click on the last cell of your table and press Tab, Excel will create a new row below and keep the table formatting. You can then type new data directly into that row without having to reformat anything.
To add a new column, click on any cell in the table and go to the Table Design tab (which appears when a table is selected). Click "Add Column" on the right side, or straightforward click on the blank column when ready to the right of your table and start typing a header. Excel will recognize it as part of the table and explore the same formatting automatically. This flexibility means your table grows with your data without losing its structure.
Frequently Asked Questions
What is the difference between a table and just data in cells?
A formatted table has built-in sorting and filtering buttons, automatic expansion when you add rows, and consistent formatting. Plain cells do not. Tables also make it easier to reference your data in formulas because you can use column names instead of cell letters.
Can I delete rows or columns from my table?
Yes. Right-click on a row number or column letter and select "Delete". The table will shrink and reformat automatically. Be careful — deleting is permanent and cannot always be undone if you have made other changes since.
How do I remove the table formatting if I change my mind?
Click any cell in the table, then go to the Table Design tab and click "Convert to Range". Your data will stay in place but will no longer be a formatted table, and the filter buttons will disappear.
Can I have multiple tables on the same sheet?
Yes. Each table must be separated by at least one blank row or column. Create the first table, leave a gap, then select your next data range and format it as a table. Excel treats each as a separate table with its own sorting and filtering.
What if I want to print my table?
Select your table, go to File, then Print. Excel will show you a preview. If your table is wider than one page, you can adjust the print settings to fit it on one page or to print across multiple pages. The header row will print on every page if you have frozen it.