ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Copy certain range of cells (https://www.excelbanter.com/excel-discussion-misc-queries/74856-copy-certain-range-cells.html)

Wesleybrack

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?

Doug Kanter

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.




All times are GMT +1. The time now is 11:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com