Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel quick addition of many cells
Name: Jeremy Date: November 14, 2003 at 08:05:27 Pacific OS: win xp CPU/Ram: 256
Comment:
Hi...
Running Excel 2000, and doing calculations by laboriously typing "=A1+A2+A3+A4+A5+A6" and so on, when I actually have about a hundred cells to add. Wondering if there is any easier way of doing this. Can I, for example, hold down + and drag across or highlight all the cells I want to add? (Well, actually, I know I can't do this, as I've tried, but welcome any similar moves I can make to make life easier!)
Name: Krystyna Date: November 14, 2003 at 08:11:45 Pacific
Reply:
Hi Jeremy
One way to add 100 cells is to put a SUM formula
=SUM(A1:A100)
Krystyna
0
Response Number 2
Name: Bryco Date: November 14, 2003 at 13:51:33 Pacific
Reply:
Or, in using Krystyna's example; Click on or make cell A101 active. Then click on the Auto Sum button and hit Enter. It will input Krystyna's formula in A101.
Or click on A1, hold down the mouse button, drag it to A100 and look in the Status bar as it will show you the sum of all highlighted cells.
Or click in A1, hold down the Ctrl and Shift keys and hit the Down arrow button to highlight all cells to the last concurrent cell in that column.
Bryan
0
Response Number 3
Name: Bryco Date: November 14, 2003 at 13:53:24 Pacific
Reply:
There are more ways too.
Bryan
0
Response Number 4
Name: Jeremy Date: November 19, 2003 at 02:06:11 Pacific
Summary: Excel will not change the format of selected cells. I cut and pasted a table that I sorted on line. The problem after the import is that Excel will not change the format of selected cells. I am tryi...
Summary: I am wondering if their is a way to do the working excel faster than write this stuff out cell by cell. What i am doing is, i have a column with a range of years inputed, exp 2003-2009. In the two col...
Summary: What you need to do is to start calling the objects in Excel thier correct names so we can tell what is it that you are trying to do. A xls file is called a "workbook" in excel speak. A "workbook" c...
0 
