Excel Text Box - how to exact copy text & formatting to text box on another sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2437511%22%20slang%3D%22en-US%22%3EExcel%20Text%20Box%20-%20how%20to%20exact%20copy%20text%20%26amp%3B%20formatting%20to%20text%20box%20on%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2437511%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20wanting%20to%20know%20is%20it%20possible%20to%20have%20a%20text%20box%20on%20one%20sheet%20of%20my%20excel%20file%20be%20copied%20with%20the%20exact%20same%20text%20and%20formatting%20(ie%20with%20bold%2C%20underlined%20on%20specific%20text%20areas)%20to%20another%20text%20box%20located%20on%20another%20sheet%20within%20the%20same%20spreadsheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20creating%20a%20report%20-%20will%20have%20the%20protected%20finished%20report%20on%20one%20tab%20and%20the%20editable%20fields%20on%20the%20data%20entry%20tab%20on%20the%20other.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20the%20a%20few%20options%20to%20try%20and%20copy%20the%20text%20over%20from%20a%20cell%2C%20however%2C%20takes%20just%20the%20text%20although%20not%20the%20formatting.%20Any%20ideas%20most%20welcome.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPS%20I%20am%20not%20an%20excel%20expert%2C%20so%20apologies%20if%20this%20is%20basic%20stuff%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22juliamanuel_1-1623370138828.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F287968iAFB6FF722B2C663D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22juliamanuel_1-1623370138828.png%22%20alt%3D%22juliamanuel_1-1623370138828.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2437511%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2504440%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Text%20Box%20-%20how%20to%20exact%20copy%20text%20%26amp%3B%20formatting%20to%20text%20box%20on%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2504440%22%20slang%3D%22en-US%22%3E%3CP%3EInstead%20of%20using%20a%20text%20box%2C%20I%20would%20make%20one%20big%20cell.%20Either%20by%20resizing%20a%20single%20cell%20to%20fit%20your%20data%20and%20using%20%22Wrap%20Text%22%2C%20or%20you%20could%20merge%20cells%20to%20create%20one%20big%20one%20to%20enter%20your%20text%20into.%20From%20there%2C%20you%20can%20use%20the%20%22Format%20Painter%22%20to%20copy%20the%20format%20from%20one%20cell%20to%20another.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20general%20I%20would%20try%20to%20avoid%20using%20text%20boxes%20in%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22DKoontz_0-1625092411602.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F292757i8C5011F0C833AF97%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22DKoontz_0-1625092411602.png%22%20alt%3D%22DKoontz_0-1625092411602.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

 

Hello

 

I am wanting to know is it possible to have a text box on one sheet of my excel file be copied with the exact same text and formatting (ie with bold, underlined on specific text areas) to another text box located on another sheet within the same spreadsheet.

 

I am creating a report - will have the protected finished report on one tab and the editable fields on the data entry tab on the other.

 

I have tried the a few options to try and copy the text over from a cell, however, takes just the text although not the formatting. Any ideas most welcome.

 

PS I am not an excel expert, so apologies if this is basic stuff

 

juliamanuel_1-1623370138828.png

 

 

1 Reply

Instead of using a text box, I would make one big cell. Either by resizing a single cell to fit your data and using "Wrap Text", or you could merge cells to create one big one to enter your text into. From there, you can use the "Format Painter" to copy the format from one cell to another. 

 

In general I would try to avoid using text boxes in Excel.

 

DKoontz_0-1625092411602.png