converting website visitors
Microsoft Office Tip & Tricks Menu
Tip & Tricks Menu

View and Select Formulas in Excel

Monday April 18, 2011 at 2:40pm
When you are dealing with a spreadsheet that you didn’t create yourself, it can be useful to locate the cells that hold formulas, particularly if you are checking for errors. Normally, you only see the formula contained in a cell when you select that cell: it appears in the Formula Bar.

On Excel 2007 and 2010, to show all the formulas, you can select the Formulas tab and click onto the Show Formulas button, which is in the Formula Auditing group. On Excel 2003, select Tools from the menu bar, followed by Formula Auditing, then Formula Auditing Mode. There is a shortcut on all versions: Hold down the CONTROL button and click onto the ` (grave accent) button, which is just below the Esc button.

If you simply wish to highlight all the cells that contain formulas, press the [F5] button (Go to), click onto the Special button and then select Formulas. This will select all the cells containing formulas, on your worksheet.
» Categories: Microsoft Excel

5 Comments

Skelton | Sunday January 25, 2015 at 12:57am
Pretty nice post. I just stumbled upon your blog and wished to say that I have truly enjoyed browsing your blog posts. After all I'll be subscribing to your feed and I hope you write again soon!
Stpierre | Sunday May 10, 2015 at 3:11am
Admiring the persistence you putt into youjr blog aand in depth information you offer. It's nice to come across a blog every once iin a while that isn't the same outdated rhashed material. Wonderful read! I've bookmarked your site aand I'm including your RSS feeds to my Google account.
Saltau | Tuesday July 14, 2015 at 11:02pm
This is really interesting, You are a very skilled blogger. I have joined your feed and look forward to seeking more of your fantastic post. Also, I've shared your website in my social networks!
Abreu | Tuesday July 14, 2015 at 11:36pm
This is a really good tip particularly to those new to the blogosphere. Short but very accurate information… Thanks for sharing this one. A must read post!
Saucier | Wednesday July 15, 2015 at 7:57pm
Greetings from Los angeles! I'm bored at work so I decided to check out your website on my iphone during lunch break. I enjoy the information you present here and can't wait to take a look when I get home. I'm shocked at how quick your blog loaded on my cell phone .. I'm not even using WIFI, just 3G .. Anyways, superb blog!

Leave a Comment

Your Name
  
Email Address (kept hidden)
  
Website
 
Comment
  

So that we can check that you are a real person (and not a crafty computer),
answer this simple sum:

What is 12 - 11?
  
Intec Business Colleges - Established For Over 30 Years
Microsoft Office Specialists - Approved Microsoft Courseware
Intec Business Colleges Ltd, Old School, Pennington Court, Rugby, Warwickshire, CV21 2BB, UK. VAT Number: 695223026 Company Number: 2494959
tel:01788 575090 fax:01788 575411 email:tracey.chaplin@getoncourse.net
Website Design by ZARR Ltd