Prev: Adding up hours and minutes
Next: Excel subtotals
From: KKD on 6 May 2010 13:16
I want to copy and paste a section of my spreadsheet, however, I can't seem
to find a way to copy the formatting, the text, and the values. If I try to
use the paste values (special) function, I lose all of my text and all of my
formatting. Any method I've tried that retains my formatting results in a
loss of my values.

I am going from one worksheet to another within the same workbook and have
many merged and adjusted cell sizes which seem to be a lot of the problem.

Any suggestions?
--
KKD
From: Don Guillett on 6 May 2010 13:25
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"KKD" <KKD(a)discussions.microsoft.com> wrote in message
news:A95FBAA8-3E14-4576-AC5C-D6C797AF53BE(a)microsoft.com...
>I want to copy and paste a section of my spreadsheet, however, I can't seem
> to find a way to copy the formatting, the text, and the values. If I try
> to
> use the paste values (special) function, I lose all of my text and all of
> my
> formatting. Any method I've tried that retains my formatting results in a
> loss of my values.
>
> I am going from one worksheet to another within the same workbook and have
> many merged and adjusted cell sizes which seem to be a lot of the problem.
>
> Any suggestions?
> --
> KKD

 | 
Pages: 1
Prev: Adding up hours and minutes
Next: Excel subtotals