The Excel formatting mistakes that make grads look like beginners

When you start your first corporate graduate scheme, you want to make a great impression. You spend hours double-checking your math, confirming cell references, and writing formulas. Then you email your workbook to your senior manager.

If the layout looks messy, they will assume your work is sloppy. Presentation is the first indicator of quality in a corporate office. Avoid these four common formatting errors (and learn how to fix common Excel errors in seconds) to ensure your spreadsheets look polished and professional.

Mistake 1: Leaving default gridlines visible on a presentation tab

Excel gridlines are helpful while building sheets, but they clutter final presentation tabs, summaries, and dashboards. Leaving them on makes your sheet look like a draft instead of a finished document.

"If a manager opens your summary dashboard, they should see a clean report, not a sea of gray lines behind every chart."

Before sending your file, hide the gridlines. To do this using only your keyboard:

Mistake 2: Poor column alignment that ruins readability

Readable tables follow a simple rule: align text to the left and numbers to the right. Left-aligned numbers are difficult to compare visually, and right-aligned headers above left-aligned columns disrupt the layout.

Follow these alignment guidelines:

• Numbers: Align right. This lines up decimal points and digit places so managers can scan sizes easily.
• Text: Align left. We read text left-to-right, so this is natural.
• Codes & Dates: Center. Short strings of uniform length look best centered.

Mistake 3: Letting unfitted columns display ### errors

When columns are too narrow to show a numeric value, Excel displays ### errors. If a column containing text is too narrow, the text cuts off or overflows into the next cell. Both outcomes look unprofessional and force managers to resize columns themselves.

Never send a workbook that contains a single cell displaying ###.

Select your columns and use the auto-fit shortcut to adjust column widths instantly to fit the longest value:

Mistake 4: Over-styling with too many bold elements and colors

A spreadsheet is not a coloring book. Using multiple fonts, loud highlight fills, and excessive bolding makes data difficult to parse. Bold headers and subtle colors are more effective than high-contrast palettes.

Instead of manual styling, use a unified theme. Keep your text in a clean font like Inter or Arial. Use bold text only for headers and final total rows. Highlight key metrics with soft pastel backgrounds instead of saturated primary colors.