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
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
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
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
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
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
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
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
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
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
‘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
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
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
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
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
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 can’t add up properly – is that an acceptable compromise or something Microsoft should fix? We’ve been covering the Excel addition issues in a series of recent articles starting here. To round out the coverage we’ll now take a look at the arguments pro and con so that Office Watch
Microsoft has a standard response to any maths anomalies in Excel – KB214118 – we have a look at what it says and doesn’t say. Microsoft has a ‘get out of jail free’ card when it comes to floating point / binary math errors in Excel – it’s called Knowledge
Excel 2007 had a serious bug where some numbers display as ” 100,000 ” regardless of the true value around 65,535 and 65,536. Excel 2007 and Excel Services 2007 had a problem with a few numbers it doesn’t like … truly. A few numbers around the 65,535 and the 65,536
There are critical updates for Excel 2003, Excel 2002 (XP) and Excel 2000 plus Office for Mac Microsoft’s regular monthly patch release includes a patch for a problem in Excel. A ‘malformed’ worksheet could give access to the computer. Microsoft Office 2000 patch needs Service Pack 3 Microsoft Excel 2000
A neat little hack to add the Word 2007 and Excel 2007 icons to Sharepoint 2003. Wictor Wilén has a neat little trick to add the Word 2007 and Excel 2007 icons to Sharepoint 2003 when you upload .docx and .xlsx documents. He provides the two small GIF icons plus
Working with date values in Excel is not as easy as it sounds. Should you enter dd/mm/yy or mm/dd/yy? Do you enter slashes or dashes or dots? Pop-up Excel Calendar solves all the headaches by adding a pop-up calendar to your Excel Working with date values in Excel is not
From: Microsoft Microsoft Office Visio 2007, Every Picture Tells a Richer Story- a Microsoft Q & A Richard Wolf, general manager of the Microsoft Office Graphics Division, highlights new data visualization capabilities in the upcoming release of Microsoft Office Visio that will enable business and IT professionals to more easily
