| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range Selection
I have multiple sheets having varying rows of data. I need to select all
data in each sheet for sorting without click and drag, perhaps for a macro. Any suggestions? I am stumped! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Range Selection
I'm not clear exactly on what you're trying to do, however, to quickly select
a proper list of data, start by selecting the upper left most cell in the list then press Ctrl+Shift+(Right Arrow), then Ctrl+Shift+(Down Arrow). Does that work? -- Hope this Helps! Camilo Objective: To help one person each day! Feedback is greatly appreciated! Please let me know if I've answered your question or if my post was helpful to you? "cfspahn24" wrote: I have multiple sheets having varying rows of data. I need to select all data in each sheet for sorting without click and drag, perhaps for a macro. Any suggestions? I am stumped! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Range Selection
Sorry, this does not accomplish what I need. I need to select the entire
range within the sheet that contains data. Sort of like the "select all" command in some programs. Any suggestions? Anyone? "Camilo" wrote: I'm not clear exactly on what you're trying to do, however, to quickly select a proper list of data, start by selecting the upper left most cell in the list then press Ctrl+Shift+(Right Arrow), then Ctrl+Shift+(Down Arrow). Does that work? -- Hope this Helps! Camilo Objective: To help one person each day! Feedback is greatly appreciated! Please let me know if I've answered your question or if my post was helpful to you? "cfspahn24" wrote: I have multiple sheets having varying rows of data. I need to select all data in each sheet for sorting without click and drag, perhaps for a macro. Any suggestions? I am stumped! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Range Selection
You can click on the "select all" button--it's to the left of the column headers
and above the row headers. Or hit ctrl-a (depending on your version of excel and what is selected, you may have to hit it a couple of times) cfspahn24 wrote: I have multiple sheets having varying rows of data. I need to select all data in each sheet for sorting without click and drag, perhaps for a macro. Any suggestions? I am stumped! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| First row in Selection range (first index of a cell) EXCEL VBA | Excel Worksheet Functions | |||
| UDF is updateing cells on another sheet with count from current sheet. | Excel Discussion (Misc queries) | |||
| FORMULA at Source range (in Data-validation-List) gives wrong re | Excel Worksheet Functions | |||
| 'Centre across selection' format to apply to vertical range | Excel Discussion (Misc queries) | |||
| How to Select a relative range with Using "Find" and Offset() | Excel Discussion (Misc queries) | |||
Linear Mode
