Forum Discussion
Excel Text Box - how to exact copy text & formatting to text box on another sheet
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) t...
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.
Sorry but this does not work if you want to have one big cell but leave the rest of the column or row the original size.