BBC HomeExplore the BBC
This page has been archived and is no longer updated. Find out more about page archiving.

28 August 2014
Accessibility help
Text only
BBC Key Skills Go to ICT Home
Key Skills Home

BBC 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.

ABCDEFGH
1JanFebMarchTotal
2TypeNo.CostNo.CostNo.Cost
3CD25£274.7512£131.8810£109.90£516.53
4Video74£813.2623£252.7719£208.81£1,274.84
5Books12£71.889£53.914£23.96£149.75
6Total£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.

ABCDEFGH
1JanFebMarchTotal
2TypeNo.CostNo.CostNo.Cost
3CD25£274.7512£131.8810£109.90£516.53
4Video74£813.2623£252.7719£208.81£1,274.84
5Books12£71.889£53.914£23.96£149.75
6Total£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 BBC | Help | Terms of Use | Privacy & Cookies Policy