ExcelBanter - Formatting Question

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formatting Question (https://www.excelbanter.com/excel-discussion-misc-queries/250692-formatting-question.html)

CommMajor

Formatting Question

Hello,
Is it possible in Excel 2003 to "freeze" the formatting so even if I copy
text with different formatting and paste it into Excel the pasted text will
take on the formatting of the other text in Excel instead of changing? Is
this possible?
Thank you in advance!

Ms-Exl-Learner

Formatting Question

Make use of Paste Special Option.

After copying the different formatting text go to the cell where do you want
to paste the values without formatting. Do Right ClickPaste Special (Paste
Special will get enabled after doing copy command)Select VALUES option
Button and give ok. Now the values only will be pasted on the present cell.
Like this you can paste Format, formula's and lot more using the Paste
Special Option.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------

"CommMajor" wrote:

Hello,
Is it possible in Excel 2003 to "freeze" the formatting so even if I copy
text with different formatting and paste it into Excel the pasted text will
take on the formatting of the other text in Excel instead of changing? Is
this possible?
Thank you in advance!

FSt1

Formatting Question

hi
not with paste all. paste special values will keep the formating of the
celll you are pasting into.

regards
FSt1

"CommMajor" wrote:

Hello,
Is it possible in Excel 2003 to "freeze" the formatting so even if I copy
text with different formatting and paste it into Excel the pasted text will
take on the formatting of the other text in Excel instead of changing? Is
this possible?
Thank you in advance!

CommMajor

Formatting Question

Thank you to both of you! That works! I appreciate it!

"FSt1" wrote:

hi
not with paste all. paste special values will keep the formating of the
celll you are pasting into.

regards
FSt1

"CommMajor" wrote:

Hello,
Is it possible in Excel 2003 to "freeze" the formatting so even if I copy
text with different formatting and paste it into Excel the pasted text will
take on the formatting of the other text in Excel instead of changing? Is
this possible?
Thank you in advance!

All times are GMT +1. The time now is 03:07 PM.