

Creating Excel workbooks is often a long process: Setting up the structure, importing inputs, conducting the calculations and eventually tidying it up and sharing it. So once you are done organizing the contents, you have to make sure that the contents are delivered and received well. Therefore it’s crucial that the workbook shows a certain level of professionalism. In this article, we’ll explore 7 simple tricks for making your Excel workbook look professional.
Contents
Hide the gridlines with just two clicks.
One of the easiest steps: Hide the gridlines. Of course gridlines provide some help for reading the tables. What about this suggestion: Hide the gridlines and manually define borders. Maybe you could try not to use the standard 1pt border but instead go with some dotted lines?
You can hide the gridlines on the View ribbon: Just untick ‘Gridlines’ within the Show group. If you need more assistance, please refer to this article.
If the rows and columns are too narrow, your workbook easily looks crammed. Worst case, instead of values it shows ‘#####’ errors. Therefore, we got the following recommendations:
Hold on a second. Was this information helpful so far?
Why don't you subscribe to our monthly, free Excel newsletter?
Subscribe now! Your welcome gift: Our big 45 pages keyboard shortcuts package. In case the sign-up form above doesn't work, please use this page. Sorry for the inconvenience.
Of course, I'm also on other networks:
Twitter: Follow @professorexcel
Facebook:
There are some default fonts in Excel: For example, the later versions of Excel use the Calibri font. There are other fonts, which look more professional. Although boring – why don’t you try the Arial font family?
But even more important: Don’t use too many different fonts and font sizes. Stick with one font type and max. 2-3 different font sizes e.g. for highlighting headlines.
Example for a clean workbook structure. There are some quick steps for making your workbook look professional: Hiding gridlines, right use of space, use of colors, fonts and so on.
How many different colors do you use in your workbook? There is a general rule of thumb: The less, the better. Colors should help the user to understand your workbook and tables. Not to make him or her confused. So we suggest: Use max. 3-4 different colors, for example for symbolizing different cell types:
Apply the ‘Thousands’ number format with just one click
The format of the numbers in your workbook should support your data and analysis. Therefore please consider these points:
Also in this case the consistency is crucial. For the same data type you should use the same number format.
If necessary add some information about the values, for example the currency or indicating that values are percentage values.
Excel too slow? Speed it up. Get the book now!
Tired of waiting for Excel? Use the 30 best methods described in this book to speed up Excel calculations!
Learn more or get it on Amazon!
If you do complex calculations in Excel, usually you got some kind of input data, some kind of calculations and eventually outputs and results. We recommend separating each type into different worksheets. So for each input, each calculation step and each output you could have separated sheets. If that way your workbook becomes very large, you could insert separator sheets. For example, add a sheet called ‘Inputs–>’ in front of all your input data worksheets.
The workbook structure should be consistent and easy to understand.
Define the print settings. Here: Set print headers and footers easily
Many people are still printing out Excel workbooks. So unless you are sure that your workbook won’t be printed, better set a nice printing layout. That includes:
If your workbook contains more than – let’s say – 7 sheets you could consider adding a table of contents. You could add a table of contents as the first worksheet. On this table of contents worksheet you should have a list of all worksheets, possibly even with links to each worksheet. Furthermore you can add comments or instructions here.
In this article we describe 3 methods of how to insert tables of contents.
This function is included in our Excel Add-In 'Professor Excel Tools'
Learn more Download Free Trial
(No sign-up, download starts directly)
More than 10k people on Facebook can't be wrong.
When you read all these recommendations, please keep in mind: The most important guideline should be to help new users to understand your workbook as easy as possible. Usually don’t need any fancy design.
In many cases, these tricks can help with that but for all these points there are good reasons to disregard them.
To further simplify the process of applying professional layouts to workbooks, we’ve included many layout options – easy to find – in our Excel Add-In: Professor Excel Tools. Please try it for free!
'Professor Excel Tools': Add more than 60 amazing features to Excel!
Professor's Error Helper for Excel: Solve any error in Excel.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.