Prevent changing size when copy&paste into another Excel Worksheet
Hello,
I have created a template in Excel that contains headings that I need to copy and paste into another Excel worksheet that I have exported data onto. However, when I copy and paste this template that I have created in Excel onto another Excel worksheet, the formatting such as, the size of the cells change which takes a lot of time to correct because I have formatted the cells on the template to "wrap the text." Is there anyway I can "freeze" the cells so that I can copy and paste the template onto another Excel worksheet without having to fix the cell formatting and/or size?? I have found a HELP topic on this issue, it is called "Prevent objects from moving and sizing with cells;" however, I cannot figure out how to get to "Object Positioning" so I can select (I BELEIVE) "Move but don't size with cells." Because I do want to copy and paste it but I don't want to change the cell(s) size. THANK YOU SOOOO MUCH FOR YOUR HELP IN ADVANCE! -- Michelle |
All times are GMT +1. The time now is 11:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com