| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to avoid pasting blanks ?
Dear Sir,
I have the following worksheet: A B C 235 235 211 211 148 148 412 412 741 741 225 225 622 622 I wish to copy and pasting column A and B to column C simultaneously. May I know the keyboard steps for avoiding pasting blank cells in column C ? I try Paste Special Skip Blank but it still pasting bank cells by overwriting earlier the cell content. Thanks Low -- A36B58K641 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to avoid pasting blanks ?
Maybe using a formula might suffice?
Assuming source data in cols A and B as posted in A1:B7 Put in C1: =IF(A1="",B1,A1) Copy down to return required results. If needed, select col C and kill the formulas with an "in-place" copy n paste special as values -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Mr. Low" wrote: Dear Sir, I have the following worksheet: A B C 235 235 211 211 148 148 412 412 741 741 225 225 622 622 I wish to copy and pasting column A and B to column C simultaneously. May I know the keyboard steps for avoiding pasting blank cells in column C ? I try Paste Special Skip Blank but it still pasting bank cells by overwriting earlier the cell content. Thanks Low -- A36B58K641 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to avoid pasting blanks ?
Hello Max,
Thanks for your help. Best Regards Low -- A36B58K641 "Max" wrote: Maybe using a formula might suffice? Assuming source data in cols A and B as posted in A1:B7 Put in C1: =IF(A1="",B1,A1) Copy down to return required results. If needed, select col C and kill the formulas with an "in-place" copy n paste special as values -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Mr. Low" wrote: Dear Sir, I have the following worksheet: A B C 235 235 211 211 148 148 412 412 741 741 225 225 622 622 I wish to copy and pasting column A and B to column C simultaneously. May I know the keyboard steps for avoiding pasting blank cells in column C ? I try Paste Special Skip Blank but it still pasting bank cells by overwriting earlier the cell content. Thanks Low -- A36B58K641 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to avoid pasting blanks ?
welcome
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Mr. Low" wrote in message ... Hello Max, Thanks for your help. Best Regards Low |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 :How to reduce distortion upon pasting to Quattro Pro? | Excel Discussion (Misc queries) | |||
| Excel 2002: How to retain default formating after pasting ? | Excel Discussion (Misc queries) | |||
| Excel 2002 : How to avoid pasting incremental refrences ? | Excel Discussion (Misc queries) | |||
| Avoid plotting refferanced blanks as zeros in scatter plot graphs | Charts and Charting in Excel | |||
| Excel 2002 : Why VLOOKUP formula does not show blanks or N/A ? | Excel Discussion (Misc queries) | |||
Linear Mode
