Optimizing RedRover Detect For Your Environment
When faced with the task of proofing a new workbook, the sheer volume of cells to be examined can be intimidating. RedRover Detect is designed to help you bring the candidate cells down to a focused, manageable number.
MANAGING HEURISTICS
The various heuristics that RedRover Detect uses to analyze your spreadsheet have been carefully chosen and analyzed. [...]
Posted by clark on April 18th, 2008 in Blog with No Responses
Excel 2003 to Excel 2007: Sheet Size Expansion. Too Much of a Good Thing?
Did you know that Excel has a maximum number of rows and maximum number of columns?
So, lets get the numbers out of the way:
Excel 2003: Max Rows: 65,536 Max Columns: 256
Excel 2007: Max Rows: 1,048,576 Max Columns: 16,384
That makes 16,777,216 cells per page in Excel 2003. This is increased to a whopping 17,179,869,184 (about [...]
Posted by vega on April 15th, 2008 in Blog with No Responses
Clearing the Contents of Cells in Excel
Updating a spreadsheet is challenging enough to correct what you can see, but what you can’t see can also throw you off.
What I’m specifically thinking about is clearing the contents of a cell. First off, I’ll tell you that the correct way to do this is to select the cell and press the delete [...]
Posted by vega on April 10th, 2008 in Blog with No Responses
Spreadsheet Design Considerations
As I’ve started to look at more and more spreadsheets with Audit, I’ve begun to wonder if there are ways I could change the design to make it cleaner and easier to check for errors. I’ve come up with a few techniques, detailed below, that seem to work well, especially alongside Audit:
Make [...]
