Tips.Net > ExcelTips Home > Worksheet Functions > Information Functions
Tips, Tricks, and Answers
The following articles are available. Click the article's title (shown in bold) to see the associated article.
Determining a Value of a Cell Much of Excel’s worksheet data is maintained by internal numbers, regardless of what is displayed on the screen. You can uncover the underlying numbers by using the N worksheet function, described in this tip. Microsoft Excel versions: 97 2000 2002 2003
Getting the Name of the Parent Workbook If you need to insert into a cell the name of the workbook in which a worksheet is contained, you can use the CELL function. This tip explains the proper way to get the info you need. Microsoft Excel versions: 97 2000 2002 2003 2007
Perplexed by Pivots?
PivotTables don't need to be scary or mysterious. Use this powerful tool to analyze your data in ways you didn't know were possible. (more information...)
Helpful Links
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Bugs and Pests Tips
ExcelTips
Family Tips
Health Tips
Home Tips
Organizing Tips
WordTips
Advertise on the
ExcelTips Site
Great Info!
RSS Feeds
Daily Nuggets (an ExcelTip every day)
Allen Wyatt's ExcelTips (the weekly classic)