| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HIGHLIGHTING A COLUMN OF DATA
I HAVE DATA IN A COLUMN, SAY IN A1 THROUGH A300.
I also have a "name" for the last cell, A300, call it "END". Question: How do I highlight the entire column...cells A1 through A300 without having to drag the mouse...so that I can copy and paste it to another column (for sorting in numerical order)?? Thanks., FLKulchar |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HIGHLIGHTING A COLUMN OF DATA
click on the first cell and then touch
SHIFT-END SHIFT-down arrow -- Gary's Student "F. Lawrence Kulchar" wrote: I HAVE DATA IN A COLUMN, SAY IN A1 THROUGH A300. I also have a "name" for the last cell, A300, call it "END". Question: How do I highlight the entire column...cells A1 through A300 without having to drag the mouse...so that I can copy and paste it to another column (for sorting in numerical order)?? Thanks., FLKulchar |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HIGHLIGHTING A COLUMN OF DATA
Thank you!!!!!!!!!!!!!!!!!!!!!!!!
"Gary''s Student" wrote: click on the first cell and then touch SHIFT-END SHIFT-down arrow -- Gary's Student "F. Lawrence Kulchar" wrote: I HAVE DATA IN A COLUMN, SAY IN A1 THROUGH A300. I also have a "name" for the last cell, A300, call it "END". Question: How do I highlight the entire column...cells A1 through A300 without having to drag the mouse...so that I can copy and paste it to another column (for sorting in numerical order)?? Thanks., FLKulchar |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HIGHLIGHTING A COLUMN OF DATA
Range("a1:" & Range("end").Address).copy range("b1")
-- Don Guillett SalesAid Software "F. Lawrence Kulchar" wrote in message ... I HAVE DATA IN A COLUMN, SAY IN A1 THROUGH A300. I also have a "name" for the last cell, A300, call it "END". Question: How do I highlight the entire column...cells A1 through A300 without having to drag the mouse...so that I can copy and paste it to another column (for sorting in numerical order)?? Thanks., FLKulchar |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with referencing please | New Users to Excel | |||
| Macro question | Excel Worksheet Functions | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| Otto M. - Data Matching | Excel Worksheet Functions | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Linear Mode
