short cut

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Short cut

Short cut

resolvedResolved · Low Priority · Version 2007

Sarah has attended:
Excel Advanced course

Short cut

How do I show the formulas within a cell to print them off?

RE: short cut

Hello Sarah,

Hope you enjoyed your Microsoft Excel Advanced course with Best STL.

Thank you for your question regarding how to show formulas in Excel so that they can be printed.

All you have to do is hold down the CTRL key then press the Accent Grave ` key and this will display all your formulas. The Accent Grave key is located at the top left-hand corner of your keyboard just below the ESC key.

Follow the same procedure to put things back to normal.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Make a quick copy of a worksheet

Hold down the Ctrl key, then click and drag on a sheet tab to make a copy of that sheet. Though this process usefully copies the formats of the original sheet, note that any Range Names you have on the original sheet will be duplicated too.

To make a copy of a worksheet's contents and formats without duplicating range names: (1) Ensure that you have a blank worksheet to paste to. (2) On the sheet to copy, click on the sheet selection square to the left of Column A's heading to select the whole sheet. (2) Copy the whole sheet. (3) Paste to the blank worksheet.



View all Excel hints and tips


Server loaded in 0.09 secs.