To enter a fraction, simply prefix it with a zero and a space. So to display the fraction one-third, type 0 1/3. This will display 1/3 but will have an underlying value of 0.33333333.
Sounds familiar? This is the No. 1 complain for first time user of Office 2007 because of the new Ribbon user interface, quite a number of commands have been repositioned. I keep on telling people that after a couple of weeks they will get used to the new UI and actually be happy with it. Honestly at least I do (whether or not I working with Microsoft)
So for the rest of us, Office Labs launched a new Office add in called Search Commands. It helps you find commands, options, wizards, and galleries in Microsoft Office 2007 Word, Excel and PowerPoint. Just type what youâ€™re looking for in your own words and click the command you need. Search Commands also includes Guided Help, which acts as a tour guide for specific tasks. (pic above)
Go here for more details.
In Microsoft Office Excel 2007, you can easily highlight duplicate values with conditional formatting.
- Select the list in which you want to identify duplicates.
- Click the Home tab on the Ribbon.
- In the Styles section, click Conditional Formatting, point to Highlight Cells
Rules, and then click Duplicate Values. Pairs of duplicates will then be highlighted, and you can choose which of each pair to delete.
Microsoft just launch the beta version of Office Live Workspace after allowing pre-registration for US based customers few months ago. Good news is this time it is available worldwide. Goto this URL to sign in using your Windows Live/ Hotmail ID http://workspace.office.live.com/
Upon signing in you will get a screen as below, notice that there is an ‘Install Office Add-in’ button. This is a less than 1Mb .msi file download which gives you integration on Word, Excel and PowerPoint.
I look at Office Live Workspace as a online extension of the Office client. There is a personal document library for you which you also can share with other people. Then for Outlook you can synchronize your tasks, appointments, contacts and even notes on your workspace.
On the help file it stated that the integration is available for Office 2003 and XP as well. Cool, FREE new features for older version of Office product. How many vendor does that?
Integration with Office 2003
Integration with Office 2007
Today I struggled for some time to figure out how to control the visibility of custom task pane in Excel 2007. I had done quite a few Word 2007 addin projects but this is the first time I try to do it in Excel.
In Word 2007 with VSTO 3.0 (that comes with VS2008) to hiding the custom task pane I would add this in the Click event code
Me.Application.TaskPanes(Word.WdTaskPanes.wdTaskPaneDocumentActions).Visible = False
But with Excel 2007 it is different. You have use the DisplayDocumentActionTaskPane class
Me.Application.DisplayDocumentActionTaskPane = False
I found the solution in the MSDN article here.
Just FYI, adding a action pane is same for both application using the following method