Local trumps Global – Local Named Ranges make the spreadsheet more tractable

January 21, 2014Posted inMacros, Tips and Tricks3 Comments
Create from Selection

Creating user friendly spreadsheets is not just a professional courtesy anymore. We have the obligation to help users decipher the spreadsheet we so hastily put together. Spending a little extra time setting up well designed spreadsheets help a firm reduce future costs by

  1. reducing the time spent on testing and scrutinizing the sheet.
  2. improving the productivity of the worker.
  3. helping the ‘new guy’ figure out the sheet in no time.
  4. increasing the visibility of errors, consequently reducing the need for rework.