Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michelle
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i save a large amount of data in a worksheet excel 4 Rana Excel Worksheet Functions 1 June 13th 06 10:54 AM
Print Excel charts in Word 2003 with fixed size Phil Charts and Charting in Excel 1 November 3rd 05 04:24 AM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 Rich Rodberg Links and Linking in Excel 1 October 21st 05 07:53 AM
Merging data from an excel worksheet into an excel template pkasler Excel Worksheet Functions 1 March 13th 05 04:36 AM


All times are GMT +1. The time now is 01:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"