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
New Contributor

 

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

 

 

0 Replies