Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i save a large amount of data in a worksheet excel 4 | Excel Worksheet Functions | |||
Print Excel charts in Word 2003 with fixed size | Charts and Charting in Excel | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
Merging data from an excel worksheet into an excel template | Excel Worksheet Functions |