|
Q: How do you Display or Print Formulas in the cells?
- Select the sheet you which to see the formulas.
From the Tools menu, Choose Options
Click the View Tab.
In the lower section (the Window Options), select "Formulas"
Now all the cells will display the formulas.
Click OK to close the dialog.
Back to the worksheet. Select the Column headers you want to resize.
Move the mouse to the right edge of one of the column header boarders. When
the pointer changes to a double arrow, double click to resize the selected
columns to show the entire width of the longest formulas.
Now select areas to print.
From the File menu, choose Page Setup...
Click the Sheet Tab.
Click on Column & Row headings.
Specify the Print Area.
Then Print.
|
