quick question about excel (rep for winner/first answer)

Watch
This discussion is closed.
lou p lou
Badges: 2
Rep:
?
#1
Report Thread starter 16 years ago
#1
how do you print your spreadsheet showing the formulae?

this should prob be in the academic section, but i need the answer like 3 hours ago

lou xxx
0
Baron
Badges: 1
Rep:
?
#2
Report 16 years ago
#2
(Original post by lou p lou)
how do you print your spreadsheet showing the formulae?

this should prob be in the academic section, but i need the answer like 3 hours ago

lou xxx
Excel help: On the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode .


0
Baron
Badges: 1
Rep:
?
#3
Report 16 years ago
#3
and then:

On the File menu, click Print.
Under Print what, select an option to print the selection, the active sheet(s), or the entire workbook

apparently
0
pal_sch
Badges: 0
Rep:
?
#4
Report 16 years ago
#4
Write the equation out in quote marks. I don't think you can do it so it shows all the equations automaticaly. Depends on how their used and how you want to show them.
0
Baron
Badges: 1
Rep:
?
#5
Report 16 years ago
#5
(Original post by pal_sch)
Write the equation out in quote marks. I don't think you can do it so it shows all the equations automaticaly. Depends on how their used and how you want to show them.
im using 2003 and the Formula Auditing Mode displays all the formulas automatically in 3 clicks dunno if earlier excel versions have it
0
lou p lou
Badges: 2
Rep:
?
#6
Report Thread starter 16 years ago
#6
(Original post by Baron)
and then:

On the File menu, click Print.
Under Print what, select an option to print the selection, the active sheet(s), or the entire workbook

apparently
cheers m'dear!

lou xxx
0
pal_sch
Badges: 0
Rep:
?
#7
Report 16 years ago
#7
(Original post by Baron)
im using 2003 and the Formula Auditing Mode displays all the formulas automatically in 3 clicks dunno if earlier excel versions have it
I don't use excell except at school, and some of the feature are less than obvious. I probably haven't found all of them yet.
0
Daveo
Badges: 14
Rep:
?
#8
Report 16 years ago
#8
Or just press "ctrl" and the key next to number 1.
0
X
new posts
Back
to top
Latest
My Feed

See more of what you like on
The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

Personalise

How are you finding researching unis for 2021 entry?

I have been able to get all the information I need from online research (71)
18.78%
I have tried virtual events and found them useful (78)
20.63%
I have tried virtual events and did not find them useful (70)
18.52%
I would be interested in trying socially distanced or scaled down in person events (79)
20.9%
I want to but don't know where to start with researching unis for 2021 entry (39)
10.32%
I haven't started researching yet (41)
10.85%

Watched Threads

View All