Excel

  [DELETED] 20:30 18 Apr 2006
Locked

Please help. I am doing a course on excel. One of the tasks is to print a spreadsheet SHOWING THE FORMULA. I don't think printscreen is acceptable I have Excel 2003 and am running Windows XP. cheers herself

  [DELETED] 20:37 18 Apr 2006

Two ways:

1) Tools > Options, View tab, tick Formulas. This will show all formulas and not the results.

2) use a User Defined Function

Function fmla(rng As Range) As String
fmla = rng.Formula
End Function

To use this:

*Open your workbook
*Press ALT + F11 to open the Visual Basic Editor
*Insert/Module
*Paste in the above code
*Close the VBE

Then to display the formula in, say, A1 enter the following formula in a different cell:

=fmla(A1)

Example click here

  [DELETED] 21:34 18 Apr 2006

To show formula for printing press Ctrl and the start quote and lines key that is the one to the left of number 1 and below Esc.
Press again to get back to normal view after printing.
Before printing you might have to change the cell widths to see all the formula.

Starlet

  [DELETED] 21:50 18 Apr 2006

That does exactly the same as Tools > Options, View tab, tick Formulas.

  [DELETED] 22:19 18 Apr 2006

Vog
You very kindly answered me this same question two years ago, but at college they told me it is a little quicker to press the two keys.
Regards

Starlet

  [DELETED] 22:20 18 Apr 2006

Thankyou so much. What a relief. And so quickly too!

dananme

  [DELETED] 16:30 19 Apr 2006

Let's not have a domestic. They both work No. 1 from vog (as a beginner couldn't work out No. 2.
Starlet was quicker; but both achieved same object.
Thanks for the keyboard link. Very useful.
dananme

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Microsoft Surface Book 2 15in review

Illustrator Amy Grimes on how setting up her own eco-brand led to success with clients too

MacBook Pro keyboard issues and other problems

Test : l’enceinte connectée HomePod d’Apple