| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to copy cells which gaps exist between?
I need to copy cells with gaps between:
for example: a1 a3 a5 a7 and paste them with the gaps meaning that when i paste them there will still be 1 cell apart, but i do not want to copy the blank cells which exist in between. thanks jared |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to copy cells which gaps exist between?
Do you mean you want to copy the data on the left and paste it so it looks like the data on the right? IF so you can highlight the entire range on the left, press F5, select "Special" at the bottom of the dialog box and click the radio button for "Constants" and then click "OK". Right click on one of the selected cells and copy the data. Select a destination cell and right click and select paste et voila! Code: -------------------- 1 1 3 3 5 7 5 9 7 9 -------------------- -- Excelenator ------------------------------------------------------------------------ Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768 View this thread: http://www.excelforum.com/showthread...hreadid=565432 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to copy cells which gaps exist between?
Actucally i will probably need to rephrase the question:
let say that the cells which exist a a1,a2,a3,a4,a5,a6 the only ones which contain information a a1,a3,a5 how do i copy them to a differenet location so that when i paste them into b1. the cells which will contain information will be b1 b3 and b5 and not b1 b2 and b3 the tricky part is not copying the blank cells between. jared "Excelenator" wrote: Do you mean you want to copy the data on the left and paste it so it looks like the data on the right? IF so you can highlight the entire range on the left, press F5, select "Special" at the bottom of the dialog box and click the radio button for "Constants" and then click "OK". Right click on one of the selected cells and copy the data. Select a destination cell and right click and select paste et voila! Code: -------------------- 1 1 3 3 5 7 5 9 7 9 -------------------- -- Excelenator ------------------------------------------------------------------------ Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768 View this thread: http://www.excelforum.com/showthread...hreadid=565432 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to copy cells which gaps exist between?
Are you trying to tell us that there is already data in cells b2,b4, and b6 that you don't want disturbed? IF so you can do the following: - Highlight the entire range of cells b1 through b6 - Click F5 and select "Special" - Click the "Blanks" radio button - Type in +A1 and hit CTL ENTER - Highlight the range b1 through b6 again and click "Copy" - Paste Special Values so that the formulas now become values -- Excelenator ------------------------------------------------------------------------ Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768 View this thread: http://www.excelforum.com/showthread...hreadid=565432 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to copy cells which gaps exist between?
Are you trying to tell us that there is already data in cells b2,b4, and b6 that you don't want disturbed? IF so you can do the following: - Highlight the entire range of cells b1 through b6 - Click F5 and select "Special" - Click the "Blanks" radio button - Type in +A1 and hit CTL ENTER - Highlight the range b1 through b6 again and click "Copy" - Paste Special Values so that the formulas now become values -- Excelenator ------------------------------------------------------------------------ Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768 View this thread: http://www.excelforum.com/showthread...hreadid=565432 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to copy cells which gaps exist between?
Are you trying to tell us that there is already data in cells b2,b4, and b6 that you don't want disturbed? IF so you can do the following: Highlight the entire range of cells b1 through b6 Click F5 and select "Special" Click the "Blanks" radio button Type in +A1 and hit CTL ENTER Highlight the range b1 through b6 again and click "Copy" Paste Special Values so that the formulas now become values -- Excelenator ------------------------------------------------------------------------ Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768 View this thread: http://www.excelforum.com/showthread...hreadid=565432 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to copy cells which gaps exist between?
Are you trying to tell us that there is already data in cells b2,b4, and b6 that you don't want disturbed? IF so you can do the following: - Highlight the entire range of cells b1 through b6 - Click F5 and select "Special" - Click the "Blanks" radio button - Type in +A1 and hit CTL ENTER - Highlight the range b1 through b6 again and click "Copy" - Paste Special Values so that the formulas now become values -- Excelenator ------------------------------------------------------------------------ Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768 View this thread: http://www.excelforum.com/showthread...hreadid=565432 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to copy cells which gaps exist between?
Are you trying to tell us that there is already data in cells b2,b4, and b6 that you don't want disturbed? IF so you can do the following: - Highlight the entire range of cells b1 through b6 - Click F5 and select "Special" - Click the "Blanks" radio button - Type in +A1 and hit CTL ENTER - Highlight the range b1 through b6 again and click "Copy" - Paste Special Values so that the formulas now become values -- Excelenator ------------------------------------------------------------------------ Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768 View this thread: http://www.excelforum.com/showthread...hreadid=565432 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to copy cells which gaps exist between?
Are you trying to tell us that there is already data in cells b2,b4, and b6 that you don't want disturbed? IF so you can do the following: - Highlight the entire range of cells b1 through b6 - Click F5 and select "Special" - Click the "Blanks" radio button - Type in +A1 and hit CTL ENTER - Highlight the range b1 through b6 again and click "Copy" - Paste Special Values so that the formulas now become values -- Excelenator ------------------------------------------------------------------------ Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768 View this thread: http://www.excelforum.com/showthread...hreadid=565432 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to copy cells which gaps exist between?
Are you trying to tell us that there is already data in cells b2,b4, and b6 that you don't want disturbed? IF so you can do the following: - Highlight the entire range of cells b1 through b6 - Click F5 and select "Special" - Click the "Blanks" radio button - Type in +A1 and hit CTL ENTER - Highlight the range b1 through b6 again and click "Copy" - Paste Special Values so that the formulas now become values -- Excelenator ------------------------------------------------------------------------ Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768 View this thread: http://www.excelforum.com/showthread...hreadid=565432 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to copy cells which gaps exist between?
Are you trying to tell us that there is already data in cells b2,b4, and b6 that you don't want disturbed? IF so you can do the following: Highlight the entire range of cells b1 through b6 Click F5 and select "Special" Click the "Blanks" radio button Type in +A1 and hit CTL ENTER Highlight the range b1 through b6 again and click "Copy" Paste Special Values so that the formulas now become values -- Excelenator ------------------------------------------------------------------------ Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768 View this thread: http://www.excelforum.com/showthread...hreadid=565432 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| copy a block of cells | Excel Discussion (Misc queries) | |||
| How to copy cells horizontally to cells out of sequence | 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 | |||
| How to copy block of cells and keep grouping? | Excel Discussion (Misc queries) | |||
Hybrid Mode
