Emma Healey “Lady Licensing” is the site to visit to understand Microsoft Licensing in Depth http://ladylicensing.spaces.live.com
Archive for the ‘Office tips’ category
Microsoft Licensing – “Lady Licensing”
April 18th, 2010Microsoft Office 2010
April 18th, 2010Jonathan Bailor, a Microsoft Word program manager, worked with a team of problem-solvers to find a way for multiple users to efficiently collaborate on documents. The resulting tool, coauthoring, will be available in Office 2010.
Sam Radakovitz developed a feature called “sparklines” for Microsoft Office Excel 2010 that lets users transform large amounts of data into small, at-a-glance displays that fit into a single cell.
Microsoft Program Manager Michael Affronti helped develop two new features for Microsoft Office 2010, one that organizes e-mails by conversation and another that lets people use e-mail to connect socially with friends and professional contacts.
Excel tip
April 6th, 2010To enter the same: string, number, or formula into two or more cells select all the cells to populate, type the entry, and press Ctrl + Enter to autocopy the data into all of the selected cells.
Quickly remove hidden text in Word
March 31st, 2010To hide text in Word use the Hidden format.
Tt’s easy to forget that the hidden text is still present andd it may be sensitive or confidential. Best practice is copy and then remove the hidden text from the copy before you distribute the document.
To hide text:
1.Select the text to hide.
2.From the Format menu, choose Font.
3.Click the Font tab.
4.Check the Hidden option in the Effects section.
Uncheck the Hidden option to display hidden text. Or click Show/Hide on the Standard toolbar — it’s faster. Show/Hide is a toggle, so a second click rehides all the hidden text when you’re ready to put it out of sight.
Viewing the hidden text can be helpful, but it won’t remove it. To remove all hidden text in a document, :
1.From the Edit menu, click Replace. Or press [Ctrl]+H.
2.Click the Find What control.
3.Click More.
4.Click the Format button and choose Font .
5.Select the Hidden option in the Effects section.
6.Click OK.
7.Click Replace All
Word will delete any Hidden text
To change your mind, just press [Ctrl]+Z to retrieve the deleted text.
Note; Removing hidden text could displace other text,
Office 2010 and SharePoint 2010 RTM on track
March 14th, 2010The Microsoft Office Product Development Group official blog asnnounced that Office 2010, SharePoint 2010, Visio 2010 and Project 2010 are all on track to reach RTM next month.
A huge amount of new functionality is promised
On May 12, e Stephen Elop, President of the Microsoft Business Division, will deliver a live keynote focusing on the next wave of productivity that Office 2010 and SharePoint 2010 will deliver.
There will also be virtual breakout sessions.
MS Word -stubborn page break
February 15th, 2010If you have page break in your document that you cannot remove then this may be because Track changes is enabled. To turn this off esnure your screen is in Normal View, and double click the ‘TRK’ section in the status bar ,or simultaneously press: CTRl,, Shift and E
Remove formatting
February 3rd, 2010A useful keyboard shortcut for Microsoft programs like Word, Outlook, etc
When you cut, copy & paste text from a web page into an email message or a Word document, the associated formatting styles also get copied along with the text.
If you like to clear this formatting, just select the text again and press Ctrl key followed by space bar. The selection is converted into plain text without requiring any macros and It kills hyperlinks –and still the font and the font size remain
In Word 2007 hit the Office button in the top left corner. select “word options” (bottom right) select the “advanced” menu option in the left column there is a whole section “cut, copy, and paste” to make the changes – you can also change your default file location here
I believe Ctrl + Space actually restores the underlying paragraph formatting; it doesn’t change text to plain. That is what happens in Word 2002/2003 at least. For example, if you have a Heading 1 where you’ve changed it to red underlined italic for example (not in the styles but directly in the document) Ctrl + Space will reset to the heading 1 style so its bit more subtle than it seems.
Microsoft Word tip – remove formatting
January 26th, 2010There’s a simpler way to strip all formatting from Word text:
Select the text you want to strip of all its formatting.
Press Ctrl+Spacebar
This is an all or nothing solution–you can’t pick and choose the format you delete. Pressing Ctrl+Spacebar removes all the formats previously applied to the selected text.
The Great PowerPivot FAQ
January 3rd, 2010http://powerpivotfaq.com/Lists/TGPPF/AllItems.aspx
PowerPivotPro’s FAQ Site
This is going to be one of the big successes over 2010 so get ready!
December 27th, 2009
The US Court of Appeals ordered Microsoft to drop support for editing Custom XML in Word, essentially stopping the company from selling current versions of one of its flagship products and affirming a $290 million patent infringement judgment . The injunction, goes into effect on January 11, 2010, and only bars the sale of Word 2007, and also affects all editions of Microsoft Office 2007, .
This injunction applies only to copies of Microsoft Word 2007 and Microsoft Office 2007 sold in the US on or after the injunction date of January 11, 2010,”meaning all copies of these products sold before this date (including Word 2003 and Word 2007) are not affected.
The injunction does not require changes to Word 2010, due for release in June 2010 because “the beta versions of Microsoft Word 2010 and Microsoft Office 2010, which are available for downloading, do not contain the technology covered by the injunction