Moved to the Excel Twitters archive:
Excel Twitters 20090501

When sharing an Access database, you should have the data in one file (the back end) and the queries, reports, forms and modules in a separate database (the front end).
Give each user their own copy of the front end, linked to the shared back end.
Keep a master copy of the front end file, tucked away [...]

At 100% zoom setting in Excel, the numbers display correctly. If I have a column of 7 digit numbers, all 7 numbers line up correctly, all down the column. For example, 1111111 is the same width as 8888888:

However, if I zoom to something less than 80%, the numbers become proportional, and don’t line up [...]

While trying to type a hyphen in Excel 2007, I stumbled onto a handy keyboard shortcut.
I had a bit of an overreach on the hyphen, and hit the F10 key instead. To my amazement, the Ribbon filled with little tags.

Maybe I’ve been living under a rock, but I don’t remember seeing those before.
There’s [...]

It’s nice to have a new laptop, but it’s amazing how many options and settings need to be adjusted. For example, on my other machines I’ve changed the settings so those annoying Paste Options and AutoFill Options buttons don’t appear. Now it’s time to fix them on the new laptop. Does anyone actually use those [...]

Moved to the Excel Twitters archive:
Excel Twitters 20090424

You don’t have to put all your lists in Excel – Word has a Sort feature too. And Word has an extra feature that makes it easy to sort a book list.
For example, in this list, several of the book titles start with “The”. When sorting the list, I’d prefer to ignore that word, and [...]

Today I heard from someone who was having problems with data validation, in cells that were formatted in Percent Style. In the workbook, Enable automatic percent entry is turned on (Office button, Excel Options, Advanced, Editing options).
 
In the cells that are formatted as Percent Style, the percent sign automatically appears as you start [...]

When you add field to the Row or Column area of a pivot table, subtotals automatically appear in the outer fields. For example, in the following pivot table, Region and Employee are the outer fields, and show subtotals.

Remove Subtotals in Excel 2007
In Excel 2007 you can turn off all subtotals for the active pivot [...]

In earlier versions of Excel you could select a comment on the worksheet, and use the Drawing toolbar commands to change the comment’s rectangle to a different shape.  It’s not a technique that you’d want to use too often, but it can add impact to a worksheet if used sparingly.

In Excel 2007, the Drawing [...]