Enter a Fraction in a Cell in Excel 2007
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.
Where is that &$#@ command in Office 2007?!
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.
Identify Duplicate Values in an Excel Table
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.
Office Live Workspace available worldwide
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
Hiding Task Pane programmatically with VSTO
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
Me.ActionsPane.Controls.Add(actions)
about me
Hi there! My name is Patrick and I code on .NET and build a few products on SharePoint and Windows Azure. I am currently CTO of IPS Infonomics Pte Ltd and co-founder of Tech Insights Conference.
My reading list- How to Deliver a Killer Business Presentation
- 10 Hot Web Startups Changing the Face of Retail
- Visa certifies NFC-equipped Android, BlackBerry smartphones for payWave -- Engadget
- An easy way to use certificates for WCF security - CodeProject®
- 6 Things To Do when you got your Unifi Wireless Router D-Link Dir-615 « Sawanila.com™
- Controlling Registry ACL Permissions with Powershell
- Building the Ultimate SharePoint 2010 Development Environment
- Running SharePoint 2010 on a domain controller
- Using Local Machine Accounts for Managed Accounts in SharePoint 2010
- How Trello is different - Joel on Software