Formatting an Excel Worksheet Professionally

Professional Formatting of Excel Worksheets thumbnail

In this article we will show you how to give a good-looking initial formatting to an Excel spreadsheet.


Please feel free to download the spreadsheet files we will use in this article:


This is how a blank sheet looks like when you open a new Excel file.

Default Excel worksheet formatting

What we want to do is to render it as clear and professional-looking as possible from the beginning of our work. Therefore, let’s do the following.

Select the entire worksheet by clicking on this button (this can be done also by clicking Ctrl+ A).

Select all cells

And then assign a white color to the cells of the sheet.

All cells in the sheet become white.

Set white fill color

Let’s select Arial as font and 9 as a font size.

Select Arial as font and 9 as font size

The next step will be to reduce the width of the first column. This is done easily; we just have to select the column, right-click on it and choose “Column Width.” Let’s adjust it to 1.25.

Set first column width to 1.25

The final correction to be made is to create a title cell on the top of the page in cell B1. I’ll leave the Arial font, but will adjust the font size to 12 and put it in bold. Let’s change the color of the title text as well, picking dark blue. I’ll name the sheet as “Formatting a worksheet.”

Create a title cell

Here is our nice sheet, professionally formatted and ready for work.

Final professionally formatted worksheet

If you go through our next articles, specifically the one dedicated to macros, you will learn how to perform all these operations with a single click, but let’s not get ahead of ourselves.

Financial Auditing: Ultimate Guide

Financial auditing entails producing an opinion on the truth and fairness of the financial statements of a company. Only

Financial Auditing: Ultimate Guide

Financial auditing entails producing an opinion on the truth and fairness of the financial statements of a company. Only licensed accounting professionals (auditors) authorized by the relevant governing bodies for the territories they operate in can carry out the auditing of financial statements. Audits were first regulated with the...
Learn More

Clearinghouses and Custodians: Financial Intermediaries 101

Intermediaries are vital for a well-functioning financial system and allow their clients to solve the problems they face more

Clearinghouses and Custodians: Financial Intermediaries 101

Intermediaries are vital for a well-functioning financial system and allow their clients to solve the problems they face more efficiently than they could by themselves. We find several types: Brokers, Exchanges, and Alternative trading systems Dealers and Securitizers Depository Institutions Insurance Companies Arbitrageurs, and Clearinghouses and Custodians We shall...
Learn More

Long and Short Positions: Guide to Wall Street Lingo

Rather than an instance of duration, long and short positions are a reference to haves and have-nots. They touch

Long and Short Positions: Guide to Wall Street Lingo

Rather than an instance of duration, long and short positions are a reference to haves and have-nots. They touch on securities an investor really owns versus securities an investor owes. Basically, the terms “short” and “long” denote what “selling” and “buying” do respectively. Featured: What is a Long Position?...
Learn More