I found out this awesome trick in Excel. Check it:
If you get a workbook from someone, you can figure out what formulas they used by selecting all the cells (ctrl+A), then going to "Edit - GoTo - Special". There you click "Formulas" and "ok" and this selects the cells with formulas. You can now make those cells have red or bold font! If you click the backwards apostrophe (under the tilde), it will even show all the actual formulas.
Here's where it gets crazy. If you go to "Tools - Formula Auditing" and click "Trace Precedents", Excel will draw a blue line from all the input data cells to the destination cell, even if the input data is from a different workbook!
Now you know how the formulas work in your new workbook of data.
skip to main |
skip to sidebar
After leaving the Saint Paul Pioneer Press, Par Ridder recently became the publisher of the Minneapolis Star Tribune. There's been some controversy with his changing roles, and he'd like to let people know his side of the story. Also, this blog is a parody. It's not the thoughts and opinions of the real Par Ridder.
About Me
- Par
- I'm formerly the publisher of the Saint Paul Pioneer press, and I'm currently on sabbatical from my job as the publisher of the Minneapolis Star Tribune. Do you want to join my new internet newpaper? Email me for career opportunities!
Links That I Like
Blog Archive
-
▼
2007
(50)
-
▼
July
(27)
- Pools Are For Swimsuits
- So Long Good Buddy
- Dining for a Cause
- Excel Tip
- The City Pages Cover Story
- All Comers Welcome
- C.J. Is A Cover Girl
- Paul Magers House Into A Home
- A Beautiful Relationship
- Out with the CFO, In with the Consultant
- Excel Tip
- "We, the journalists of the Star Tribune, call on ...
- "The Guild does not get to decide who is publisher...
- An Easy Weekend
- I See How It's Gonig to Be
- Excel Tip
- Newspaper Manager Extraordinaire
- Wall Street Tribune
- Publisher Is Higher Up Than VP
- The Grind
- Yesterday Lambert wrote another attack piece on me...
- One Night With Paris
- I Also Like The Word 'Nemesis'
- Full Confidence
- Prince at Macy's
- Vitamn: Swimsuit Edition
- Even after I defended Parry, she still had to go s...
-
▼
July
(27)
3 comments:
Good to see you've gotten beyond copy, paste and print.
I assume this has nothing to do with your civil trial underway?
You can also delete all the spreadshee data -- non-formula and non-text content -- with a $30 Excel add-on (Google: 'Excel numbers delete remove' [without the quotes]) or with a little custom function (and Excel's "Conditional Formatting").
Post a Comment