I have a text box at the top of my excel workpapers. In the past, when printing out the excel spreadsheet, I would select "fit all columns on one page" or "fit on one page" and the text box would automatically resize. Now for some reason it is no longer auto resizing the text box. Even when I go back to the saved workpapers that did not have a problem previously, I am unable to reprint the out. I have right clicked on the text boxes, selected format shape, then selected text options and the box under properties "move and size with cells" is selected. I am not sure why all of the sudden this is happening.
Solved by X. J. in 30 mins