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 Sorting & Filtering

EMEKA PEACEWILL
seal-mask
.a{fill-rule:evenodd;}techdegree
EMEKA PEACEWILL
Front End Web Development Techdegree Student 5,914 Points
Posted by EMEKA PEACEWILL
.a{fill-rule:evenodd;}techdegree
EMEKA PEACEWILL
Front End Web Development Techdegree Student 5,914 Points

how did you select all those data...just before going to the Data menu?

Any shortcuts?

2 Answers

Joseph Maza
Joseph Maza
9,184 Points
Joseph Maza
Joseph Maza
9,184 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,548 Points

Thanks! That's a great tip!

Steven Parker
Steven Parker
231,198 Points
Steven Parker
Steven Parker
231,198 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.