Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy and paste visual cells only in Excel
I have an Excel spreadsheet that has a column of business names with
addresses and telephone numbers. I have hidden the non meaningful information. I want to copy this list to an other column, spreadsheet, or where ever, so that I can paste just the visual cells information. At one time I thought that this was possible through the paste options box. Or am I dreaming of a different dimension? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy and paste visual cells only in Excel
Select the range that you want to copy and do the following:
Press F5, click SPECIAL command button in the lower-left corner and then click the VISIBLE CELL option button. Click OK Then just do the copy and paste, and only the visible cells will be pasted. -- Kevin Backmann "MermaidHunter" wrote: I have an Excel spreadsheet that has a column of business names with addresses and telephone numbers. I have hidden the non meaningful information. I want to copy this list to an other column, spreadsheet, or where ever, so that I can paste just the visual cells information. At one time I thought that this was possible through the paste options box. Or am I dreaming of a different dimension? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy and paste visual cells only in Excel
If you copy a range with some of the rows hidden you'll copy the hidden rows
into the Windows clipboard, but not into the Office clipboard. Do your paste from the Office clipboard. "MermaidHunter" wrote in message ... I have an Excel spreadsheet that has a column of business names with addresses and telephone numbers. I have hidden the non meaningful information. I want to copy this list to an other column, spreadsheet, or where ever, so that I can paste just the visual cells information. At one time I thought that this was possible through the paste options box. Or am I dreaming of a different dimension? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy cells from netscape and paste to excel | Excel Discussion (Misc queries) | |||
How I can copy / paste a selected cells to other columns in Excel | Excel Discussion (Misc queries) | |||
copy and paste (visual basic) | New Users to Excel | |||
visual basic (copy and paste) | Excel Worksheet Functions | |||
How do I edit, copy and paste text in excel cells? | New Users to Excel |