Moved to the Excel Twitters archive:
Excel Twitters 20090131

While viewing a Word document in the Print Preview window, you might notice a typo, or something else that you’d like to fix quickly, before printing. However, the pointer is a magnifying glass, and when you click on the page you just zoom in or out.
To edit the document, you can turn off the magnifier:
In [...]

In some of my Excel workbooks there are calculation rows or columns that are required for producing the end result, but users don’t need to see them.
I can manually hide these rows and columns, then unhide them if I need to check a calculation, or adjust a formula.
To make it easy to hide things, I [...]

I’ve been using Microsoft Word since 1985, starting with Word for Mac and eventually moving to the Windows version for Word 6.0. As with other Office programs, some great new features have been added, and other features, that were working just fine, have been removed or changed.  Don’t get me started on Word’s numbering.
Most of [...]

One of the new features in Excel 2007 is live preview when you select a different font or theme on the Ribbon. For example, here’s how my worksheet looks now:

The default font for the cells is Calibri, and I’ve added bold in the first row. I’m not sure if the Calibri font is the best [...]

How can you create a chart from annual or monthly data, and make the results easy to understand? For example, this table shows meat production in the UK, per season, over 2 years, in thousands of tonnes.

I need a chart that shows the fluctuations in production for each meat type. Did production change much from [...]

Moved to the Excel Twitters archive:
Excel Twitters 20090124

Last week I wrote an article about hiding Excel macros, so they don’t appear in the macro list. While working on that article I noticed that the Macro dialog box has a Collapse Dialog button.
While the Macro name box is active, you can go to the workbook, select a sheet, and click on a cell.
[...]

In an Excel workbook you might have a worksheet that contains several lists that you use as the source for data validation dropdown lists. For example, this worksheet has a list of countries, and lists of regions within those countries.

If each list has a heading, you can quickly create named ranges from the lists.
Create [...]

In Outlook, as you start typing a name in the To box, a drop down list may appear, showing names of people to whom you’ve previously sent an email.

Sometimes those names are out of date, and the list includes old email addresses.
In my Outlook drop down lists there are multiple entries for some [...]