| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy certain range of cells
If I have a spread sheet with 5000 cells being used from A-AL, and I only
want to copy and paste cells from A1,AL1 to A479,AL479. Is there any way of typing this in to select it? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy certain range of cells
"Wesleybrack" wrote in message ... If I have a spread sheet with 5000 cells being used from A-AL, and I only want to copy and paste cells from A1,AL1 to A479,AL479. Is there any way of typing this in to select it? A1,AL1:A479,AL479 The colon in the middle is the key. Type this into the name box, a little below the File menu. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to hide blank cells in a range | Excel Discussion (Misc queries) | |||
| How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
| Match function...random search? | Excel Worksheet Functions | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
Linear Mode
