Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I use to use easy calc (works spreadsheet) to add, etc to auto fill out the
totals in another cell, I cant figure out how to do it in Excel |
#2
![]() |
|||
|
|||
![]()
hi
if you're asking how to add up some numbers, e.g. the numbers in the range B3:B7 in B8 use =SUM(B3:B7) to autofil this formula across to C8, D8 etc move your mouse over the bottom right hand corner of B8, when you see an + hold your left mouse button down and drag right if you're copying down a column i.e. from H8 to H9 to H10 etc when you see the + double click on it - this will work if either column G or I has information in it. Cheers JulieD "titont" wrote in message ... I use to use easy calc (works spreadsheet) to add, etc to auto fill out the totals in another cell, I cant figure out how to do it in Excel |
#3
![]() |
|||
|
|||
![]()
JulieD You are the MAN or ummm.....WOMEN!??!?!?!?
Thank you very much, i love ya!! Chad K "JulieD" wrote: hi if you're asking how to add up some numbers, e.g. the numbers in the range B3:B7 in B8 use =SUM(B3:B7) to autofil this formula across to C8, D8 etc move your mouse over the bottom right hand corner of B8, when you see an + hold your left mouse button down and drag right if you're copying down a column i.e. from H8 to H9 to H10 etc when you see the + double click on it - this will work if either column G or I has information in it. Cheers JulieD "titont" wrote in message ... I use to use easy calc (works spreadsheet) to add, etc to auto fill out the totals in another cell, I cant figure out how to do it in Excel |
#4
![]() |
|||
|
|||
![]()
lol :)
glad it worked Cheers JulieD "titont" wrote in message ... JulieD You are the MAN or ummm.....WOMEN!??!?!?!? Thank you very much, i love ya!! Chad K "JulieD" wrote: hi if you're asking how to add up some numbers, e.g. the numbers in the range B3:B7 in B8 use =SUM(B3:B7) to autofil this formula across to C8, D8 etc move your mouse over the bottom right hand corner of B8, when you see an + hold your left mouse button down and drag right if you're copying down a column i.e. from H8 to H9 to H10 etc when you see the + double click on it - this will work if either column G or I has information in it. Cheers JulieD "titont" wrote in message ... I use to use easy calc (works spreadsheet) to add, etc to auto fill out the totals in another cell, I cant figure out how to do it in Excel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) | |||
Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) | |||
lable ranges in Excell | Excel Discussion (Misc queries) | |||
Why can't we see or access MS Excell 2003 even though we have MS . | Setting up and Configuration of Excel | |||
EXCELL 2002 Glitch???? | Excel Discussion (Misc queries) |