keyboard-1

OH, NO! I JUST DELETED A NAME THAT WAS USED IN A FORMULA

If you have used defined names in formulas and then delete that defined name, you will get an #NAME? error. Perhaps you should Find the name, as you defined it, looking in the entire workbook, BEFORE you delete the name.  Then you are aware that you will have an issue. If you have pasted a [...]

By | October 25th, 2014|Excel Tips, Office 2007 Tips, Office 2010 Tips, Office 2013|Comments Off on OH, NO! I JUST DELETED A NAME THAT WAS USED IN A FORMULA

PASTE A LIST OF EXCEL RANGE NAMES

If you inherit a spreadsheet from someone else and want to see what block names (if any) exist within the worksheet, you can have Excel paste a list of block names within the current spreadsheet. Excel will create a two-column table that alphabetically lists the defined block names in the current file and their corresponding [...]

By | October 25th, 2014|Excel Tips, Office 2007 Tips, Office 2010 Tips, Office 2013|Comments Off on PASTE A LIST OF EXCEL RANGE NAMES

Excel PivotTable Field List Can Float!

I just love it when a student in one of my classes teaches me a new trick!  Natalie Bhutto is my hero! I was teaching a class with PivotTables and the display was a wide-screen TV.  I sized the window down so the PivotTable Field List would not be so far from the PivotTable when [...]

Use the N function in Excel to Add a Comment to a Cell

You can add a “comment or note” to a cell with a formula and it will be hidden in the cell’s formula. The formula below multiplies the sales ($5,000) by 37.5% then there is a note that explains why.   NOTE: +N(“quotations must be used around the note”)

By | June 15th, 2014|Excel Tips, Office 2003 Tips, Office 2007 Tips, Office 2010 Tips, Office 2013|Comments Off on Use the N function in Excel to Add a Comment to a Cell