Microsoft

>Tag:Microsoft

Excel Retains Manual Calculation

There is a known issue with Excel's calculation when switching out of Automatic calculation mode. For those who don't know, let me recap the issues: The first workbook opened will use the calculation mode of its last save Any workbook created will inherit the calculation state of the first opened workbook (or current application calculation [...]

March 16th, 2013|Tags: , , , , |7 Comments

Delete styles in MS Excel

This is applicable to Excel 2007-2013. Styles are wonderful, and I've loved having them in Excel.  If you're not familiar with styles, check out these links: http://office.microsoft.com/en-us/word-help/style-basics-in-word-HA010230882.aspx (Word 2007+) http://office.microsoft.com/en-us/word-help/all-about-themes-quick-styles-cell-styles-and-background-styles-HA010178624.aspx (Excel 2007+) http://office.microsoft.com/en-us/excel-help/using-styles-in-excel-HA001110199.aspx (Excel 2003) Often times, especially when sharing files, perhaps emailing files back and forth to/from co-workers, a file can become bloated with [...]

January 14th, 2013|Tags: , , , , |12 Comments

Get Table Addresses

This was written with Excel 2010 in mind, but will work in 2007-2013. Version differences are pointed out where applicable. Screenshots are using 2010. In the spirit of working with tables via VBA, sometimes you may need to check the range of a table. This is fairly straight-forward in most cases, but sometimes it has [...]

January 14th, 2013|Tags: , , , , |6 Comments

Why you should use structured references in tables

Tables were introduced in Excel 2007 and are a spin-off from the lists feature of previous versions. This blog post will be based on working with structured formulas in tables, as opposed to standard relative/absolute referencing. I consider this a basic level post. If you're not up to speed with tables, here is some reference [...]

January 7th, 2013|Tags: , , , , |9 Comments

Running Total in a Microsoft Excel Table

Running Total in an Excel Table INTRODUCTION Tables were introduced in Excel, 2007.  I love them, they’re very handy.  Along with them we were introduced to Table referencing.  This made it easy to identify parts of a Table.  It’s called “structured referencing”.  Here is pretty much the best resource for identifying structured referencing in Excel [...]

July 12th, 2012|Tags: , , , , |7 Comments