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

excel

ResolvedVersion 2003

Leanne has attended:
Excel Intermediate course

Excel

How to format a table.

RE: Excel

Hello Leanne

Thank you for your question and welcome to the forum.

There are preset table autoformats in Excel that can be quickly applied to data.

To apply an autoformat, select the cells you wish to apply formatting to, then go to Format - AutoFormat. Select an AutoFormat to apply, and click OK.

Otherwise you can select cells and apply your own formatting using borders, shading, fonts, font sizes, alignment etc.

Kind regards
Amanda

Thu 19 Feb 2009: Automatically marked as resolved.

Excel tip:

Apply currency format quickly in Excel

To quickly apply the currency format to cell in your spreadsheet, select (highlight) the cells you wish to apply currency format to, then use Ctrl + Shift + $

This will apply a pounds symbol even though the $ key is pressed.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.