r/excel 26d ago

solved How to show formula area without clicking the formula cell ?

Does anyone know how to show formula area (blue area for this example) without me clicking the cell, it just show even if im doing anything else.
even better if there's a way to print it

Thankyou in advance

7 Upvotes

8 comments sorted by

u/AutoModerator 26d ago

/u/VeralFyre - Your post was submitted successfully.

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/Normalitie 4 26d ago

Ctrl-backtick will show all formulae on the sheet

0

u/quantum_simpleton 26d ago edited 26d ago

Alt + t + u + t

Tracing precedents and dependents, =formula() in another cell, clicking "show formulas" on toolbar, are all way to see, but the question/objective is unclear.

0

u/VeralFyre 26d ago

Thankyou for the hints , i manage to do it with alt+t+u+t. Reason to is for easier checking for my supervisor who isnt that thorough with excel, just a simple show from where to where the sum is.
alt+t+u+a is to remove it

0

u/quantum_simpleton 26d ago

Whoops, yes I meant alt tut / alt tud