Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trialMatthew Han
Courses Plus Student 701 PointsIf we are dealing with thousands of data, we can't possibly select with our mouse when doing the SUM function right?
If we are dealing with thousands of data, we can't possibly select with our mouse when doing the SUM function right? How should we do with huge amount of data?
3 Answers
Steve Hunter
57,712 PointsHi Matthew,
Depending on the spreadsheet, you can use the arrow keys, together with Ctrl+Shift to select to the end of that section of data, i.e. select to the next gap in the row. So, if you're at the top of a column, you can hold Ctrl+Shift and press the down arrow to select all the way to the next gap - a subsequent press of the down arrow goes to the next, until you reach the end of the column.
Steve.
Matthew Han
Courses Plus Student 701 PointsHi Steve,
What if I have thousands of data, do i have to press and wait until it gets to the bottom? Could there be a faster way?
regards,
Matt
Steve Hunter
57,712 PointsIf you press Ctrl+Shift and an arrow it should jump immediately and not scroll down each row slowly.
Alternatively, you can send the whole column into the sum, like sum(A:A)
. Depends what you're trying to achieve.
Matthew Han
Courses Plus Student 701 PointsThank you very much for the answer Steve!