formatting

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formatting

Formatting

resolvedResolved · Low Priority · Version 2007

Louise has attended:
Excel Introduction course
Excel Intermediate course

Formatting

What are the best ways of formatting tables to be most asthetically pleasing?

RE: Formatting

Hello
there are lots of ways to format a table. You can make the headings bold and give the headings row a background colour. You can also add borders to the table. Go to view>>toolbars>>Forms and this will give you another toolbar. If you click on the "toggle grid" button (the one with the 25 dots in it) then the grid on the sheet will be removed. You can add a column to the left and a row to the top. With the border on, this can look really good.
Regards


 

Excel tip:

Changing the Tab Colour of an Excel 2010 Worksheet

Did you know you could give the tabs in your worksheet different colours?

This is particularly useful when organizing all your worksheets relating to a particular period or year, for example.

Right click a tab
Select Tab Colour
And choose your favourite colour!

View all Excel hints and tips


Server loaded in 0.08 secs.