Excel’s options for shading alternate rows are limited and sometimes ugly. Here’s how to take full control and design the way you like I sometimes wonder whether Microsoft spends so much on its programming budget it has little left over to spend on designers. This thought often crosses my mind when working with Office sample […]
An explanation of the logic behind alternate shading rows or columns in Excel. If you’re content with this result and don’t need to know the nuts and bolts, class dismissed. If, on the other hand, you’d like to understand how we end up with a checkerboard pattern from this expression, stick with me. Unless you […]
Cells in Excel are linked by references – whether they are relative, absolute or mixed – named or unnamed – Rose Vines will explain all. When you refer to a cell in an Excel formula, you can use any of three different types of reference: relative, absolute and mixed. Relative cell references are the most […]
Excel 2003 has limited undo level, until you use our tip to increase the number of actions than can be reversed. Excel 2007 lets you undo 100 actions; with Excel 2003, the limit is 16 but that’s an arbitrary limit set by Microsoft. If that feels too restrictive, you can up the Excel 2003 limit […]
By default, Outlook displays either your Inbox or the Outlook Today page when you open it. What if you’d like it to display your calendar instead? Or, perhaps you’d find it handy to open two Outlook windows, one showing your Inbox and the other your calendar. By default, Outlook displays either your Inbox or the […]
