Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to do number additions in a spread sheet faster
I am doing research on numbers. I have been entering the numbers in a very
time consuming and potentially error ridden manner....the old fashioned way by scrolling through the colums and then when I come to the column I want to add a number to stopping at that column changing the number that was there to indicate another addition of that number then pressing enter and then on to the next number. THERE HAS TO BE A SIMPLER WAY, BUT I DON'T KNOW ENOUGH TO KNOW HOW TO DO IT! Column A B C D E F............xx December 1 2 3 4 5............22259 I am only entering in 10 numbers into each row under each number column, but I have to scroll all the way accross until i get to each number column's column . i.e. I could have to add #'s 1, 45,67,99,345,678,and 987 but I need to scroll from 1 to 45 then onto all the others. I want to be able to have my row look like this Column A B C D E F G H I J K December __ __ __ __ __ __ __ __ __ __ and then I simply type in the numbers I need in each column and then the numbers are "magically" added to the correct number columns. I hope this makes sense to someone and can help me. -- Thanks, Mobilenetmomma the eternal student |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need value for spread sheet | Excel Worksheet Functions | |||
how do i enter a bull call spread into the options spread sheet ? | Excel Worksheet Functions | |||
Is there a limit to the number of rows in a excel spread sheet ? | Excel Discussion (Misc queries) | |||
Can faster CPU+larger/faster RAM significantly speed up recalulati | Excel Discussion (Misc queries) | |||
How do I increase the number of additions etc.from 30 | New Users to Excel |