How to Create a Table in Excel

 

Step-by-Step Guide: Creating a Table in Excel

1. Open Excel and Start a New Workbook

• Launch Microsoft Excel.
• Click on Blank Workbook to start fresh.

2. Create Headings

• In the first row, type your column headings:

• Example: Date, Item, Category, Amount, Notes.

3. Make Headings Bold

• Select the heading row.
• Click the Bold (B) icon in the toolbar or press Ctrl + B.

4. Adjust Column Widths

• Hover over the line between column letters (e.g., between A and B).
• Drag to expand or double-click to auto-fit.

5. Apply Color Fill

• Select the heading row.
• Click the Fill Color icon (paint bucket) and choose a color.

6. Format Cells

• Select the Amount column.
• Right-click → Format Cells → Choose Currency.

7. Merge & Center Title

• Type a title (e.g., “Personal Budget”) above your table.
• Select the cells across the top row.
• Click Merge & Center in the toolbar.

8. Adjust Decimal Places

• Select the Amount column.
• Use the Increase/Decrease Decimal buttons to control precision.

9. Use AutoSum for Totals

• Click the cell below your Amount column.
• Click AutoSum (∑) → Press Enter to calculate the total.

Where to buy Microsoft Office:

Microsoft Office Home 2024 One Time purchase for 1 PC/MAC: 

https://amzn.to/4iy6672

https://amzn.to/41YTfnh

Microsoft 365 Personal | 12-Month Subscription | 1 Person | Office Word, Excel, PowerPoint | 1TB OneDrive Cloud Storage | PC/Mac Instant Download | Activation Required

https://amzn.to/4hCpazy

https://amzn.to/42ac7jl

Some links are affiliate links. Purchasing through these links gives me a small commission to support this channel, at no cost to you. Thanks for your support!