LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need value for spread sheet [email protected] Excel Worksheet Functions 2 April 28th 07 11:43 PM
how do i enter a bull call spread into the options spread sheet ? alvin smith Excel Worksheet Functions 0 November 27th 06 01:23 AM
Is there a limit to the number of rows in a excel spread sheet ? Bob's row limit question Excel Discussion (Misc queries) 3 June 30th 06 06:53 PM
Can faster CPU+larger/faster RAM significantly speed up recalulati jmk_li Excel Discussion (Misc queries) 2 September 28th 05 10:24 AM
How do I increase the number of additions etc.from 30 leonperrins New Users to Excel 4 June 27th 05 04:42 PM


All times are GMT +1. The time now is 07:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"