About manager

This author has not yet filled in any details.
So far manager has created 242 blog entries.

Hyperlink Formulas & how to use them

Hyperlink Me! The HYPERLINK Formula (who knew that formula existed?) can be really useful when navigating around large spreadsheets The simplest format is along the lines of =HYPERLINK("#A1","Any Helpful Message") This would jump you to cell A1 of the current sheet.  But that's no different to a normal old Hyperlink (via RIGHT-CLICK > Hyperlink or Insert [...]


How do you get 4 million rows of data into Excel?

So firstly lets face facts.  Not many people need to bring 4 million rows of data into Excel.  Point accepted. However, some do, and I recently needed to do this. If you've ever checked  (Press End then the down arrow key) Excel has just over 1 million rows, but if you start adding a formula [...]

Business Intelligence, Power BI|

Feeling Bloated? How to fix inexplicably large spreadsheets

Sticking with the theme of the health of your spreadsheet, have you ever notice spreadsheet become inexplicably bigger? Suddenly becoming 20MB instead of 2MB. One cause is unused rows and columns. How do I check and how do I fix it? Simple, on each worksheet in your file press End then Home. Your cursor will [...]

Why multiple monitors might be killing your spreadsheets

Ever get the warning that Excel has “run out of resources” or “too many formats” or you simply can’t paste into it anymore. There’s a glitch in Excel 2010 and 2007 (fixed in Excel 2013) Am I affected? Here’s how to check. Open your Excel Files (your important ones), go to the Home Ribbon [...]

Excel 2007|