MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Print all cell formulas

Posted by Alex on November 10, 2001 9:21 PM

I have long formulas in some of the cells.
When I use Ctrl+ ~ I see the formulas in cells but they
are truncated. It appears printing works as WYSIWYG.

Posted by Alex on November 10, 2001 9:24 PM

Is there a way to list all cells in certain sequence with complete formulas and data?

Posted by JACK on November 11, 2001 2:27 AM

Im sure if you set Tool | Options and set to click on show formulas then Excel will print the formula OK, whatch the cells with will explode on the command change this is normal, i would suggets some edition - i awlays set the cell alignment to WRAP TEXT,

Hope that helps, remember you can change back. Sorry i know of CRTL+ Tidle but never use..