Gmail stopped working, but Outlook users didn’t have to worry. Saul Hansell at the New York Times is reporting on an outage on the popular Gmail service. The Gmail breakdown happened at the start of the working day in Europe and lasted until about lunchtime. Early risers in the USA
How to format a Word or Excel document to print on someone else’s computer. On our new Twitter account we saw this question: ” When I send an Excel file to someone, should I have to set it up so they can print it? I don’t know the printer/size paper
How to configure the list of recently used documents in Office and the glaring omission. The Most Recently Used (MRU) list is the list of documents you’ve recently opened in Word, Excel or PowerPoint. It is a handy way to reopen documents you’re currently working on but could be better.
Office Watch explains what can happen with Show Formulas in Excel and the simple fix. A slip of the fingers can make all your numbers disappear! An Office Watch reader wrote in a panic, her vital worksheet had gone crazy showing only formulas instead of numbers! She was the victim
Sections are in every Word document – here’s how to use them to make Word do what you need. In the last issue I described how to omit the page number on the last page of a document by using a section break and “de-linking” the header/footer between the sections.
Vlookup scares too many Excel users but it should not. David Goodmanson shows how easy and incredibly useful it can be. How can your grab a value from a separate Excel list and insert it into your current calculation? Vlookup or Hlookup is the main answer in Excel. We’ll
It’s a simple question about ordering monthly data in Word – there’s many answers which give a glimpse into what you can do with Office. ” I want to have a monthly log of items, each month separated by a page or section break, but be able to “toggle” the
A current example of what to watch for and what to do when Outlook doesn’t detect a new type of spam message. In the last day or so we’ve started seeing some obvious spam messages in our Inbox. ‘Obvious’ to us but not to Outlook 2007’s Junk e-mail filter on
The Office 2007 can disappear to make more screen room available for your document – not only that but it does so intelligently. The Office 2007 can disappear to make more screen room available for your document – not only that but it does so intelligently. The ribbon can be
The Quick Access Toolbar (QAT) in Office 2007 programs have their own shortcut keys using the number keys. The Quick Access Toolbar (QAT) in Office 2007 programs have their own shortcut keys using the number keys. Alt + 1 for the first icon on the QAT, Alt + 2 for
Here’s some more tips for using Office 2007 without the mouse. Here’s some more tips for using Office 2007 without the mouse. As we’ve mentioned before, much of the same shortcuts that applied for earlier versions of Office will also apply with Office 2007. Plus there’s new features that make
Here’s how to delete the Microsoft Word document you’re currently editing. Here’s a rather more complex macro you might find useful. This one lets you delete the document you’re currently editing. Word normally won’t let you do this: you must first close the document, then delete it. That’s a sensible
If you frequently find yourself wanting to edit the same document you were using in your last Word session, you can create a shortcut which does just this. If you frequently find yourself wanting to edit the same document you were using in your last Word session, you can create
Most of the time all you need is the basic message information – From, To and Subject but occasionally you need to dig a bit deeper into the ‘raw’ email message header. Here’s how to do it in Outlook 2007, Outlook 2003 and before. Most of the time all you
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,
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
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
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
Word has a hidden calculator but Google’s online calculator is much better. If you spend lots of time in Word, you’ll find its calculator extremely useful; it’s much easier to get a result within the program you’re using than by having to load up an external application. However, if your
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
Use your mouse to nudge down a folder list in Outlook Do you have dozens of folders in Microsoft Outlook into which you sort incoming email? To make life more manageable, you can create shortcuts to the folders you use most frequently and then use the Shortcuts button in the
Word 2007 has changed the Rand() feature and not entirely for the best. One of Word’s quirky, tucked-away features is the rand() function. It lets you quickly insert a block of text in a document. To use the function in pre-2007 versions of Word, at the beginning of a line
Does Excel have a bug that forces an unchanged worksheet to be saved again? Gordon H writes: “Here’s a long standing bug in Excel that Microsoft has never fixed. I open a Word document, look at it then close the document – there’s been no change to the file so
The new ‘ribbon’ interface in Office 2007 is officially called the ‘Fluent’ interface and there are some nifty shortcut tricks available. The new ‘ribbon’ interface in Office 2007 is officially called the ‘Fluent’ interface and there are some nifty shortcut tricks available. First off, keep in mind that the ribbon
