Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

Data Analysis Spreadsheet Basics Getting Started With Spreadsheets Sorting & Filtering

2 Answers

Joseph Maza
Joseph Maza
9,172 Points

I think what EMEKA PEACEWILL was referring to was when he selected all the cells without clicking. To do this select a cell then hold SHIFT + Control and then press the arrow key in the direction corresponding to the cell direction you want to highlight. EXAMPLE: All cells with data to the right highlighted to end SHIFT + Control + RIGHT ARROW. Hope this helps

angiem
angiem
1,498 Points

Thanks! That's a great tip!

Steven Parker
Steven Parker
218,679 Points

You can click and hold in a cell and then drag to the opposite corner to select an entire rectangular region.

You can also simply click to select one cell, then shift-click in the opposite corner to select the whole region.