Preparing and optimizing screenshots and photos for Office and the Web

If you’re not using the Microsoft Office Picture Manager, you’re leaving a powerful image editing tool on the table that’s included free with Office 2007. When you take screenshots to illustrate your Word and PowerPoint documents, sure, you can simply resize them directly in the document. But, in terms of overall file size, they might…


Prepare Office documents for download with the Document Inspector

Before you publicly share a Microsoft Office document (e.g., a Word file offered for download on your public Web site), you should use the Document Inspector to ensure there are no hidden comments, invisible images, or personal information. Your first step should be to make a copy of the file you want to share since…


Excelling at Excel – Importing from Word documents

If you have a Word document that you want to import into Excel, first save your Word document as text. From the Microsoft Office Button at top left, select Save As, Other Formats and in the Save As Type box choose Plain Text (*.txt). Once you’ve saved your text file, close your original document and…


Use custom styles to make formatting changes swiftly

When you’re creating complex structured documents, you may need to alter a specific style during or even at the end of the content creation process. Good planning can make this a simple task rather than a headache earned during a long night of menial revision. Say you have all company names in a legal document…


Fix up a Word document quickly

Yesterday we looked at hidden formatting and shared a quick tip to search and replace double spaces using the Find and Replace tool. But what if what you want to replace is not a character but the formatting itself? No problem. In your Find and Replace box, click More to reveal this view: Click Special…


Reveal what’s really going on in Word

If you’ve ever grappled with a formatting issue in Microsoft Word – say, a bullet that just won’t line up where you want it – you’ve no doubt wondered, "Just what is going on in this document?!" Did you know there’s an easy way to view the invisible formatting marks that Word uses to keep…


Macros Made Easy – Removing hyperlinks in Excel

Macros Made Easy – Removing hyperlinks in Excel Ever wanted to quickly get rid of all hyperlinks in a Microsoft Excel document? Here’s how. First, be sure you have the Developer tab turned on in Excel. To add it, go the Microsoft Office Button at the upper left of your open Word document, click Excel…


Macros Made Easy – Assigning shortcuts after the fact

To add a shortcut key combination or toolbar button later if you didn’t assign one when you created your macro, don’t go to the Macros button. Instead, go the Microsoft Office Button at the upper left of your open document, click Word Options, and then click Customize. In the Choose commands from dropdown list, select…


Excelling at Excel – Storing numbers that are longer than Excel allows

Have you ever pasted a number into Excel and watched it turn into something like this: That’s not terribly useful if you’re storing a product ID or tracking number in a spreadsheet. Worse, it changes the number itself if it exceeds 15 characters. 123456789012345678 becomes 123456789012345000; the last three numbers are zero’d out! If you’re…