Click on the View tab on the toolbar. Click Page layout this will change the view to a single page view and enable you to add a heading easily.
Add Headings to your columns as required by clicking on a cell and then typing
Insert the data into the relevant cells by clicking into a cell and typing
Where you have data such as a date or a range of sequential numbers it is possible to auto fill the data. Click on the cell with the initial data then click on the small square in the bottom right of the cell border and drag either down or across to auto-fill the adjacent cells. Once you have auto-filled you can click on the arrow showing on the box bottom right of the list and change the auto-fill settings.
Inserting basic calculations into cells
Click onto the cell where you would like the answer to the calculation to appear and click Autosum on the Toolbar.
Excel will automatically select a group of cells to apply an addition to you can change this selection as follows.
For additions – Click onto the first cell then holding the Ctrl key down on the keyboard click on the remaining cells you wish to add once you have selected all the cells required press enter. You can double click into the cell with the total in and amend the selection by adding additional cells on, for additions you can use the + key or a comma
For divisions – Click autosum select the first cell as you did for additions then type / before selecting the second cell click return once completed
For multiplications – Click autosum select the first cell as you did for additions then type * before selecting the subsequent cell/s click return once completed
For subtraction – Click autosum select the first cell as you did for additions then type –before selecting the subsequent cell/s click return once completed
You can view the sum in any cell by clicking on the cell and looking just below the toolbar at the formula bar you can also make calculation amendments here.
You may wish to sort your data in a particular order once it has been entered to do this click on the Data tab.
From here you can select the type of sorting you would like to do and which column/rows you wish to sort
In our example we are going to sort by customer number (column B) from Lowest to Highest.
First we highlight all the data in our table by holding the Ctrl key down and typing A. Then click on on the toolbar. A dialogue box will then open giving you options for your data sort.
We have elected to sort by Customer on Values with Smallest to Largest then click OK and the sort will be applied to your data.
If you wish to only sort a single column you can click on the top of the required column to highlight the entire column. If you require an entire row click on the number next to the required row.
Formatting your spreadsheet
Under the home tab on the toolbar you can add formatting to each cell or the entire spreadsheet.
To add borders – highlight the cells you wish to have the same borders click on this will give you a list of options click on the option you require and those borders selected will be applied to all the highlighted cells.
To remove borders click on and choose no borders.
To change the font – highlight the cells you wish to have the same borders click on
Click on the arrow next to Calibri and select the font you require from the drop down list. You can change the size of the font by clicking next to the 11 and selecting the font size required or using the A buttons the large one will increase by 1 font size on each click and the small one will reduce by 1 font size on each click.
Change the colour of the text – Highlight the cells you wish to change the colour of the text in and click on the arrow from here select the colour you wish to apply.
Change the colour of the cell – Highlight the cells you wish to change the colour of and click on the arrow from here select the colour you wish to apply.
Resizing rows and columns
To make the columns and rows all the correct size for the largest data that they hold click on the top left of the sheet to select all or use Ctrl and A
Using your mouse scroll over the line between two of the column numbers until the pointer looks like then double click using the left mouse key. To adjust the rows hover between two of the row numbers.
You can change individual columns and rows by hover between the row numbers and then left clicking and dragging to the size required.
Tip – To insert a tick into a cell change the font to Windings 2 and type capital P in the cell.