selecting column

Hello. I have searched a few forums and discussions, but I cannot figure out a solution to a Numbers Issue. I have a column that is about 600 rows tall, I need to select all the rows except row 1 (a title row) and row 2 (header of the column). What I would like to do is quickly select the entire column, (basically like you can do in Excel with Shift+ page down button). Then I would have the entire colum selected, I can easily cut the data and paste it to the new column that I need it in, or I could drag it over.


the problem and time consuming part here in Numbers is that in order to highlight the entire column, i have told Down Arrow + Shift. Then as the highlight works it way down the column until if finally reaches then end of the column and the data I need.


So is there a way to quickly highlight a column (or row for that matter) of data without using Shift+Arrow keys? Is there somekind of key combination in Mac that will accomplish the pagedown/pageup while selecting data?


thank you for any answers or directions..

Chris

15" Macbook Pro, Mac OS X (10.6.5), 1st-Time-Apple-user-never-going-back-to-pc-user

Posted on May 5, 2011 7:54 AM

Reply
4 replies

May 5, 2011 9:09 AM in response to chris9771

Click the column letter to select the entire column.

Command-click on the cells in rows 1 and 2 to de-select them


Another method, useful for selecting a range of rows in a column, is to click on the uppermost cell you want to select, scroll down to the bottom of the range, shift-click on that cell. All rows between will be selected (in addition to the two you clicked on).

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

selecting column

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.