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
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
Here’s a list of the October 2006 security updates for Microsoft Office for Windows. There are five security updates for Microsoft Office this month, all of which are rated ‘Critical’ by Microsoft. Powerpoint for Windows and Mac See https://office-watch.com/kb?924163 PowerPoint 2000, PowerPoint 2002, PowerPoint 2003, Excel 2004 for Mac, Excel
More about random numbers in Excel. See Also El Patron de los Numeros Primos Sabotaging Random Numbers Getting truly random numbers into Excel Random Numbers in Excel
If anyone doubted Google’s interest in moving into the ‘office suite’ style applications, that doubt was erased by the announcement of Google Spreadsheet. GOOGLE SPREADSHEET If anyone doubted Google’s interest in moving into the ‘office suite’ style applications, that doubt was erased by the announcement of Google Spreadsheet. We’ve been
More details on the ‘request’ to update Excel after Microsoft lost a patent suit. (You’ll find lots of missing information in this article – we have asked many questions of Microsoft on this matter and received only short, ambiguous and incomplete responses.) Back in June 2005 Microsoft lost one part
Excel is one of the best tools around for working with numerical data sets, but it is also a valuable tool to utilize when working with sets of textual data. By Kara Monroe Excel is one of the best tools around for working with numerical data sets, but it is
There’s more than one way to get your Excel macro to run when there’s an event like changes to your worksheet. You can use a special macro name which tells Excel when to trigger that code. By Office Watch reader, Howard Tanner There’s more than one way to get your
We look at an interesting bug in both Excel 2002 (XP) and Excel 2003. Thanks to Bruce N for reminding us about an interesting bug in both Excel 2002 (XP) and Excel 2003. As Microsoft puts it: “multilevel subtotals for data in Microsoft Excel 2002 or Microsoft Office Excel 2003,
