OK, but what if I'm entering new information into that cell where the total is? My columns are Name, Date, Title, Type, XHours and YHours. I'd put TOTAL in cells E5 and F5. Now I have to enter information in Row 6, including into cells E5 and F5. Are you saying that I should just drag the formulas from E5 and F5 down into E6 and F6 and so on, as I add data? I'm sorry, I can put stuff INTO spreadsheets, but I stink at creating them. Hence the course. :)
Reply from Alex Hedley:
Yeah you can do that
Another option is highlight a cell in data, Ctrl+L turns it into a Table/List, now when you tab to create a new row the formula will copy down automatically.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel 2010 Beginner 2.
