When building Subtotals, Excel asks you to select the columns to which you would like to add subtotals. This problem is that Excel gives you a matchbook-size dialog box that allows you to select one column at a time. So if you require subtotals on many fields, you need to click, click, click your way through the list of columns one by one.
Believe me when I say that this gets old Tout de suite. » More: Creating Subtotals on Many Columns
Every now and then, I come across quirks in Excel or Access that leave me scratching my head. Today’s post highlights an Access quirk that has bothered me for some time.
Excel annoyance #57 – the formula thingy. Probably officially called intellisense, this tool tip is designed to give you the arguments needed for a formula. In the example you see here, you’ll notice I’m trying to enter an INDEX Formula. The formula thingy pops up right in the way of the cells I need to click in order to select my arguments.
» More: Outta My Way Formula Thingy!
So there you are, editing a named range in like the Excel superstar you are, when you make the mistake of hitting the left arrow key to go back a few characters in your formula. Excel instantly references the cell to the left. Argh!
