Quote:
Originally Posted by Aled Davies
Please can someone tell me how to force text in a cell to overlap the one to its left and the one to its right? This text is centre aligned and there is data in the two cells either side of it. However, i want the text in the centre cell to show over the other two cells. I can't change the size of the cells or the size of the text.
Any ideas?
|
Excel won't overlap a cell that contains any data, so the only suggestion I could make is to put your text into a textbox instead. You could even go so far as to assign a macro to the worksheet so that when your middle cell's value changes, it updates the text box automatically for you.