When you open a new file in Excel it is called a workbook. Workbooks are made up of columns which are labelled with letters, and rows which are labelled with numbers. Where a column and row intersect is called a cell. E.g the cell which is in the 3rd column across and the 3rd row down is called C3. When you click on it the row and column label are highlighted and the name appears in the white box, seen highlighted with a pink box in the picture below.
Adding information into cells
You can add text, numbers or a mixture of both into cells. If you wish to perform calculations you can only use numbers. To type into a cell, click on it to highlight it and type away
In the picture below the text has been entered into column A but as there is no text in column B it flows over it making it look as if it also contains text. When you click on a cell you can see in the white box above (labelled fx) all the information it contains.
When you add text it automatically aligns to the left. Numbers automatically align right.
Dates – to enter a date for the current year, all you need to add is this the date in this format 08/06 and it will display it like this:
Again when you click on it, the full date including the year will appear in the fx box
Unlike other members of the Office family, Excel doesn’t underline text you have spelt incorrectly as you go, you have to manually run a spell checker. To find this click on the ‘Review’ tab and the spelling button is on the left.
To learn how to do this and more in a classroom environment come along to our Excel Essentials training
This Microsoft Excel Essentials training course will introduce you to the basic skills needed […]Read more
This intermediate Microsoft Excel training course is suitable whatever version of Excel you use […]Read more