Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy only celss with text not blanks
I am trying to copy a row, using paste special "transpose" to paste in a column, but I dont want to copy any blank fields, How can I do this Lorraine -- lorraine knight ------------------------------------------------------------------------ lorraine knight's Profile: http://www.excelforum.com/member.php...o&userid=35294 View this thread: http://www.excelforum.com/showthread...hreadid=551034 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy only celss with text not blanks
Lorraine,
First, you need to add to your tool bar the "select visible cells" button. It can be found in the "Edit" category. Next, hide the columns that don't have any data in the row you are trying to copy. Highlight that row, click on the "select visible cells" button, then click on the copy button. Put your cursor where you want to paste, select paste special, transpose and it should work. Good Luck!, Lisa "lorraine knight" wrote: I am trying to copy a row, using paste special "transpose" to paste in a column, but I dont want to copy any blank fields, How can I do this Lorraine -- lorraine knight ------------------------------------------------------------------------ lorraine knight's Profile: http://www.excelforum.com/member.php...o&userid=35294 View this thread: http://www.excelforum.com/showthread...hreadid=551034 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy only celss with text not blanks
HI Lisa, thanks for your response, I dont think I explained the problem properly, I have a worksheet A1:IV600, in column A1:A600 I have one name per row, in columns B:IV i have the product codes, I have entered data by row in the corresponding product column (there is a minimum of one and maximum of 17 ) entries or cells filled per row accross the 250 columns, thus leaving lots of blanks, I want to copy the data, or products each person has bought into a smaller worksheet, i.e. reducing the 250 columns to 18, how do I avoid copy of blank cells Lorraine -- lorraine knight ------------------------------------------------------------------------ lorraine knight's Profile: http://www.excelforum.com/member.php...o&userid=35294 View this thread: http://www.excelforum.com/showthread...hreadid=551034 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find text and copy and move row containing it | Excel Discussion (Misc queries) | |||
How to I copy text from a range of cells to another single cell? | Excel Discussion (Misc queries) | |||
how can we copy cells comments text and paste to cells | Excel Discussion (Misc queries) | |||
Strip out text copy and paste? | New Users to Excel | |||
Find text in cell, copy row to new sheet | Excel Discussion (Misc queries) |