Home

Copying Merged Cells

%3CLINGO-SUB%20id%3D%22lingo-sub-550435%22%20slang%3D%22en-US%22%3ECopying%20Merged%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-550435%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20am%20working%20on%20updating%20the%20terms%20and%20conditions%20for%20a%20large%20number%20of%20POs%20in%20Excel%20files.%26nbsp%3B%20The%20terms%20and%20conditions%20have%20to%20be%20the%20same%20for%20all%20POs%2C%20but%20the%20first%20page%20of%20the%20PO%20is%20different%20for%20each%20document.%26nbsp%3B%20I%20have%20a%20Word%20document%20that%20contains%20the%20updated%20terms%20and%20conditions%20(a%20numbered%20list)%20and%20this%20needs%20to%20be%20copied%20into%20the%20Excel%20files%20(POs)%26nbsp%3B%20on%20pages%202%2C%203%2C%20and%204.%26nbsp%3B%20I%20have%20tried%20a%20couple%20approaches%20so%20far.%26nbsp%3B%20The%20first%2C%20was%20to%20create%202%20text%20boxes%20and%20paste%20the%20terms%20and%20conditions%20into%20these.%26nbsp%3B%20However%2C%20there%20were%20problems%20with%20the%20text%20being%20cut%20out%20when%20printing%20as%20well%20as%20having%20to%20adjust%20the%20size%20of%20the%20text%20boxes%20for%20each%20PO.%26nbsp%3B%20The%20second%20approach%20I%20used%20was%20to%20copy%20the%20information%20from%201%20term%2Fcondition%2C%20paste%20this%20into%20an%20individual%20cell%2C%20merge%2C%20and%20wrap%20the%20text%2C%20and%20click%20to%20adjust%20the%20height%20of%20the%20row.%26nbsp%3B%20After%20a%20lot%20of%20tinkering%2C%20I%20was%20able%20to%20get%20the%20text%20to%20evenly%20space%20for%20printing.%26nbsp%3B%20Now%2C%20I%20am%20wondering%20how%20to%20copy%20this%20text%20into%20a%20new%20Excel%20Sheet%20(PO)%20that%20already%20has%20information%20on%20page%201.%26nbsp%3B%20I%20tried%20selecting%20the%20text%20and%20then%20selecting%20the%20cells%20in%20the%20new%20sheet%2C%20copying%20and%20pasting.%26nbsp%3B%20However%2C%20the%20format%20was%20not%20transferred%20over%20even%20when%20using%20Paste%20Special%20and%20clicking%20%22ALL.%22%26nbsp%3B%20I%20am%20looking%20for%20a%20way%20to%20quickly%20copy%20the%20formatted%2C%20merged%20cells%20(about%2026%20altogether)%20without%20having%20to%20readjust%20the%20row%20height.%26nbsp%3B%20Thank%20you.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-550435%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-550870%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20Merged%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-550870%22%20slang%3D%22en-US%22%3EWould%20it%20make%20sense%20to%20save%20the%20pages%202%20through%204%20as%20many%20times%20as%20you%20have%20pos%3F%20Sounds%20like%20inserting%20page%201%20into%20the%20beginning%20of%20each%20would%20be%20less%20likely%20to%20break%20formatting.%3C%2FLINGO-BODY%3E
RebeccaD_19-
Occasional Visitor

Hello,

I am working on updating the terms and conditions for a large number of POs in Excel files.  The terms and conditions have to be the same for all POs, but the first page of the PO is different for each document.  I have a Word document that contains the updated terms and conditions (a numbered list) and this needs to be copied into the Excel files (POs)  on pages 2, 3, and 4.  I have tried a couple approaches so far.  The first, was to create 2 text boxes and paste the terms and conditions into these.  However, there were problems with the text being cut out when printing as well as having to adjust the size of the text boxes for each PO.  The second approach I used was to copy the information from 1 term/condition, paste this into an individual cell, merge, and wrap the text, and click to adjust the height of the row.  After a lot of tinkering, I was able to get the text to evenly space for printing.  Now, I am wondering how to copy this text into a new Excel Sheet (PO) that already has information on page 1.  I tried selecting the text and then selecting the cells in the new sheet, copying and pasting.  However, the format was not transferred over even when using Paste Special and clicking "ALL."  I am looking for a way to quickly copy the formatted, merged cells (about 26 altogether) without having to readjust the row height.  Thank you. 

1 Reply
Would it make sense to save the pages 2 through 4 as many times as you have pos? Sounds like inserting page 1 into the beginning of each would be less likely to break formatting.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
12 Replies