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 current […]
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 […]
Excel addition problems – bug or not?
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 readers understand the limitations that […]
Microsoft’s ‘Get out of jail free’ card for Excel
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 Base article 214118 and it’s […]
Excel’s problem with 65,535 & 65,536
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 mark did not display properly […]
Excel security update – January 2007
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 Download the update (KB925524) Microsoft […]
Add Office 2007 icons to SharePoint 2003
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 the lines to add to […]
Software clarifies date formatting in MS Excel
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 as easy as it sounds. […]
