Âé¶¹Éç

Explore the Âé¶¹Éç
This page has been archived and is no longer updated. Find out more about page archiving.

28 August 2014
Accessibility help
Text only
Âé¶¹Éç Key Skills Go to ICT Home
Key Skills Home

Âé¶¹Éç Homepage

Contact Us

Ìý
Using a spreadsheet
Changing the Look of Things
Ìý
Ìý

The appearance and layout of a spreadsheet can be changed quite easily, and formatting can be carried out in much the same way as for a word processing package.

key pointThere are a number of ways to change the look of a spreadsheet.

Here are a few you might have tried before:

Format:

  • You can change font styles/sizes
  • You can align the information in the cells
  • You can format cell numbers including changing: decimal places, dates and percentages
  • You can re-size columns and rows

Insert:

  • You can insert rows, columns and cells
  • You can insert pictures and symbols
  • You can insert diagrams, charts and objects


There are Formatting shortcuts that
can be carried out using the keyboard.
Take a look in the Help option of the
software package you are using,
to find the key combinations.

Alistair has produced another spreadsheet which compares different stock items sold between January and March. He has formatted his layout, so all he needs to do now is print it out.

Ìý A B C D E F G H
1 Ìý Jan Feb March Total
2 Type No. Cost No. Cost No. Cost Ìý
3 CD 25 £274.75 12 £131.88 10 £109.90 £516.53
4 Video 74 £813.26 23 £252.77 19 £208.81 £1,274.84
5 Books 12 £71.88 9 £53.91 4 £23.96 £149.75
6 Total £1,159.89 Ìý £438.56 £342.67 £1,941.12

Ìý

If you are unable to view the Flash movie above, click here for a non-Flash alternative.

Before Alistair prints it off, he needs to add the sales figures for April to the spreadsheet.

Ìý A B C D E F G H
1 Ìý Jan Feb March Total
2 Type No. Cost No. Cost No. Cost Ìý
3 CD 25 £274.75 12 £131.88 10 £109.90 £516.53
4 Video 74 £813.26 23 £252.77 19 £208.81 £1,274.84
5 Books 12 £71.88 9 £53.91 4 £23.96 £149.75
6 Total £1,159.98 Ìý £438.56 £342.67 £1,941.12

Ìý

If you are unable to view the Flash movie above, click here for a non-Flash alternative.

Go next to look at looking ahead.

Ìý
Ìý Ìý
Ìý



About the Âé¶¹Éç | Help | Terms of Use | Privacy & Cookies Policy
Ìý