Enter clean data
Put one kind of information in each column and one record in each row. Give each column a short heading. Consistent dates and number formats make sorting and calculations more reliable.
Format for clarity
Select the heading row and use bold text or a light fill to distinguish it. Widen columns so values can be read. Use number formats such as currency or date to show what a value means without changing the underlying number.
Try it
Enter three items in column A and their prices in column B. Format the heading row, then apply a currency format to the prices.
Key takeaways
- Keep each column to one kind of information.
- Use headings and readable spacing to clarify a table.
- Number formats change display while preserving numeric values.