Where did my numbers go?
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 of a misplaced keystroke which invoked […]
Lookup from a list in Excel
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 show you Vlookup since it’s […]
Excel ideas – More or Less
There’s a nifty BBC program all about the abuse of numbers. Excel is about numbers and numbers can be used or abused. In the media numbers are often abused for the sake of a headline or to push a certain product or ideology. There’s a nifty BBC program all about the abuse of numbers. More […]
Many shapes in Excel 2007 can slow you down
At the very end of 2008, Microsoft finally admitted to something Excel users had long suspected … that adding a lot of shapes to a worksheet can greatly affect Excel’s performance. At the very end of 2008, Microsoft finally admitted to something Excel 2007 users had long suspected … that adding a lot of shapes […]
December 2008 security patches for Office
More security patches for lapses in Microsoft products including various versions of Office from Office 2000 to 2007 plus some incarnations of FrontPage. More security patches for lapses in Microsoft products including various versions of Office from Office 2000 to 2007 plus some incarnations of FrontPage. As usual, we’ll list the updates according to product […]
A humble submission to their Lordships
Even after two years, the Lords and Members of Parliament in the UK can’t easily open Office 2007 documents. We explain the simple options available to the honorable members. Silicon.com is reporting that the UK’s Members of Parliament and the House of Lords are having trouble opening documents that are delivered in the Office 2007 […]
Reorganising monthly information in Word
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 pages to have the most […]
New Office 2007 help files
Microsoft has released a series of updated help files for Office 2007 programs. Microsoft has released a series of updated help files for Office 2007 programs. Each program has a separate download. In most cases the download includes updates for both the main user help file and the developers help file. There are no details […]
MS Office coming to the Apple iPhone
Soon Apple iPhone and iTouch users will be able to edit MS Office documents on a tiny but crisp screen. When Apple released the latest iPhone with direct support for Microsoft Exchange Server, it left the question of access to other parts of the Office suite. DataViz has announced that their Documents To Go product […]
August updates for Office
‘Remote Code Execution’ is the phrase for August 08 updates for a wide range of Office products. August 2008 brings two security updates for Access plus Word, Excel, Powerpoint, Publisher and Office. It’s really a case of ‘once more around the roundabout’ with most of the patches fixing yet more ‘remote code execution’ security lapses. […]
Make the Office 2007 ribbon go away
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 minimised from the pull-down menu […]
Quick Access toolbar – keyboard shortcuts
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 the second and so on. […]
Excel 2007 hotfix: Shapes not selected in chart
In a chart within an Excel 2007 worksheet you cannot select shapes by dragging a box around multiple shapes (after click Find & Select in the Editing group of the Home tab, and then you click Select Objects). Microsoft has released a hotfix for a bug in Excel 2007. In a chart within an Excel […]
Excel 2007 hotfix for WordArt bug
Excel 2007 has a bug related to Excel 2003 and WordArt – Microsoft has a fix if you need the hotfix. Microsoft has released a ‘hotfix’ to a repair a bug that arises in Excel 2007. The problem is described thus: ” Consider the following scenario: You create a new file in Excel 2003 that […]
Excel – Shading in every other row
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 […]
Excel shading – understanding the logic
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 […]
