ProjectWoman: View formulas in Excel

ProjectWoman

Welcome to Helen Bradley's Microsoft Office and productivity blog. I'm a lifestyle journalist specializing in business and consumer software and here you'll find handy hints for using software such as Microsoft Office 2007 and other office applications. Elsewhere on projectwoman.com you'll find tutorials, articles, how tos and tips on photography and Photoshop CS3. My publishing credits include PC Magazine, Windows XP magazine, CNet, PC User magazine, InformIT and others.

Wednesday, August 15, 2007

View formulas in Excel

If you've ever wanted to view your formulas in an Excel worksheet, perhaps because you suspect one has been overwritten by data or you need to troubleshoot something press CONTROL + ~ to display formulas so you can troubleshoot or debug them. Press the same keystroke again to return to your regular view of your worksheet.

If you select a cell with a formula in it before you press CONTROL + ~ you will see not only the worksheet formulas but also all the precedents to the formula in the current cell.

Labels: cell formulas, Excel 2003, precedents

1 Comments:

At October 30, 2008 11:26 PM , Anonymous said...: Thanks for the tip. I forgot how look "into" and excel spreadsheet

Links to this post:

<$BlogBacklinkTitle$>: <$BlogBacklinkSnippet$>
<$I18NPostedByBacklinkAuthor$> @ <$BlogBacklinkDateTime$>

Create a Link

<< Home

Subscribe to
Posts [Atom]

Welcome! here's my tip of the day blog. I love writing it, it's sort of instant gratification. If I see or hear something cool, I can can crank it up and get the word out. There's always heaps of cool tips and tricks here, something for everyone... promise.

ProjectWoman

Wednesday, August 15, 2007

View formulas in Excel

1 Comments:

Links to this post:

About Me

Previous Posts