Excel how to make a table look good ? MS Excel 2013

Wondering how to make a table look good in MS Excel 2013 ?

Here are a few steps to help you, with a full example below :

Format as table, using Excel predefined styles,

Copy formatting, from one cell to another,

Merge and center, when cell descriptions applies to several columns / lines,

Add borders, to visually distinguish easily important blocks,

Set text to bold, to visually notify important cells,

Format cells values, to properly display numbers, percentages, …

Resize columns to fit content.

You can always go further, but these easy and fast steps will quickly make your Excel table look better.

Starting from a non formatted table, as seen below, you can see there’s a lot to improve.

Excel how to make a table look good ? MS Excel 2013 : Raw unformatted table
Raw unformatted table

First step, apply some Excel table to distinct subtables. Select them, and use the Format as Tableoption from Styles box in the HOME menu.

Excel how to make a table look good ? MS Excel 2013 : Format subtables as table
Format subtables as table

You might use Medium formats for content, and Dark format for a heading subtable, as shown in example.

Excel how to make a table look good ? MS Excel 2013 : Use another table format for heading subtable
Use another table format for heading subtable

If you have extra cells, and want to apply the same style, select the cell from which the style should be copied, click on Format Painter from Clipboard box in the HOME menu, and then click on the cells on which you want to copy the format.

Excel how to make a table look good ? MS Excel 2013 : Format painter to copy cell format
Format painter to copy cell format

If several cells represent the same information, instead of copy pasting them, make sure the first cell of the selection (from the left for horizontal selection, or the top for vertical selection), select the contingent cells that should contain the same information, and apply the Merge & Center option from the Alignment box in the HOME menu.

Excel how to make a table look good ? MS Excel 2013 : Merge and center cells
Merge and center cells

To make some blocks of information more obvious, for example subtotals and totals, select the corresponding line or column, and apply a Border from the Font box in the HOME menu.

Excel how to make a table look good ? MS Excel 2013 : Apply borders to cell selection
Apply borders to cell selection

It might also be useful to format then in Bold from the same Font box in the HOME menu.

Excel how to make a table look good ? MS Excel 2013 : Format cells with bold text
Format cells with bold text

Some text might need to be reformatted, for example numbers only showing 2 decimals, or some numbers formatted as Percentage. Select the data you want to format, right click on the selection, and select the Format Cells… option.

Excel how to make a table look good ? MS Excel 2013 : Format cells as number / percentage …
Format cells as number / percentage …

In that option, select the category you want to apply, and change the options to fit your needs, in our case Percentage with 2 decimals.

Excel how to make a table look good ? MS Excel 2013 : Select cells format type (number, percentage, …)
Select cells format type (number, percentage, …)

Then, select the columns, and when having the icon as shown on picture by pointing at the intersection of two columns identifier, double click to resize them all automatically.

Excel how to make a table look good ? MS Excel 2013 : Resize columns to fit content
Resize columns to fit content

And voilà ! Your table should now look much better and you can now share it.

Excel how to make a table look good ? MS Excel 2013 : Table looking good in Excel
Table looking good in Excel

Similar articles

Comments (16)

Wilbert Riley, 2018-08-19
Отличная история, спасибо за обмен
Rebecca Hardy, 2018-08-19
Удивительно, теперь моя очередь попробовать!
Fannie Thomas, 2018-08-19
Dziękuję, bardzo pouczające
Alan Foster, 2018-08-19
Więc tak to robimy, świetnie wiedzieć
Kathleen Thompson, 2018-08-19
Liebe deinen Inhalt zu lesen, schreibe weiter
Dawn Hampton, 2018-08-19
나는이 세부 사항에 대해 몰랐다.
Candace Woods, 2018-08-19
มีช่วงเวลาที่ดีในการอ่านข้อมูลนี้ติดตามผลงานที่ดี
Salvatore Perkins, 2018-08-19
Simplu, clar și bine explicat, multe mulțumiri
Angela James, 2018-08-19
Bu benim için iyi çalıştı, daha fazla bakmaya gerek yok
Robert Bell, 2018-08-19
Size nasıl teşekkür edeceğimi bilmiyorum, ama bu saf dahi, teşekkürler
Emily Collins, 2018-08-19
Отличный сайт, пожалуйста, продолжайте
Lillian Rivera, 2018-08-19
Isso funcionou bem para mim, não há necessidade de procurar mais
RoachWord, 2018-08-19
Super site, continuez
Deskintric, 2018-08-19
您好,我看到了您的文章,它帮助我解决了我的问题,非常感谢
WeaveamsObsexS, 2018-08-19
Ik weet niet hoe ik je moet bedanken, maar dat is puur geniaal, bedankt
masaleenJ, 2018-08-19
Ik zal het nu proberen, bedankt voor het delen

Leave a comment