Home and Learn: Microsoft Excel Course
Your spreadsheet from the previous section should look like this one:
You have a title in cell A1, but nothing else. You'll now see how to use the AutoFill feature of Excell to quickly enter the days of the week. Off we go, then.
Click inside cell B3 of your spreadsheet, and type Monday, as in the image below:
The days of the week are going to be entered on Row 3 of our spreadsheet, from cell B3 to cell H3. Fortunately, you don't have to type them all out. You can use something called AutoFill to complete a known sequence like days of the week. In other words, Excel will do it all for us.
And that's all there is too it! AutoFill can be a handy tool to use, when you want to complete a known sequence like days of the week, months, and even formulas. We'll use AutoFill on a column of numbers, shortly. But let's crack on with our spreadsheet
Now that we've got a heading for the spreadsheet, as well as the days of the week, we can enter a few chocolate bars.
Time to enter some numbers.
To complete the numbers for the rest of the week, enter the following under each heading:
Tuesday: 2, 5, 3, 2
Wednesday: 1, 3, 2, 2
Thursday: 3, 2, 3, 2
Friday: 3, 4, 4, 2
Saturday: 2, 2, 1, 1
Sunday: 5, 4, 4, 1
When you're done, your spreadsheet will look like this:
Now that you have all those numbers typed out, we can move on to formulas, as you learn how to add up in Excel.
Entering Formulas in Excel 2007 to 2016 -->
<--Back to the Excel Contents Page
Email us: enquiry at homeandlearn.co.uk