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 trial

Data Analysis Spreadsheet Basics Getting Started With Spreadsheets Calculating Totals With SUM

If 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

Hi 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.

Hi 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

If 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.

Thank you very much for the answer Steve!