If you’ve ever tried to break an external link in Excel without success, this is for you. External links are sometimes created when copying a worksheet to another file or a new workbook. If the Edit Links button on the Data ribbon doesn’t allow you to delete the external reference the following steps will show… Read More Force a Break to an External Link in Excel
I am a huge fan of TechSmith’s Snagit and highly recommend it to anyone that needs to take screenshots to another level. But not all of us want to purchase software just to take a screen shot here and there. One of my favorite features in Office 2010 is the Insert Screenshot tool. It’s a… Read More Take a Picture of Excel Data, Charts, Pivot Tables and More
Excel 2010’s Table feature provides many different Table Styles including options for banded rows and customization. What if you want to format your data with banded rows without having to convert it to a Table? You can do this with Conditional Formatting. What’s a banded row? It’s when every other row has a different shaded… Read More How to apply banded rows in Excel without converting to a table
Office 2010 Quick Access Toolbar Tip – Add a Group of Commands at Once If you haven’t already figured out that the QAT (Quick Access Toolbar) in Office is a true time saver, you’re missing out. The QAT is designed to make commands more easily accessible without having to navigate from tab to tab to… Read More Group commands and free up some QAT real estate!
In my previous post, “How to Copy Tracked Changes in Word 2010 and Paste into Outlook 2010 Email”, I showed how to copy Track Changes markup into an email message. What if you wanted to do the reverse, copy tracked changes from an email back into a Word 2010 document? If you’ve tried this, you may have… Read More On the Flip Side…How do I Copy Tracked Changes from Outlook 2010 Email into Word 2010?
Applies to Word 2010 and Outlook 2010 This method allows you to copy tracked changes in a Word document and paste into an email message in Outlook 2010, and retain the marked up text. Previous methods of doing this in Office 2003 do not work in Office 2010 (the old Ctrl+F3 and Ctrl+Shift+F3 in 2003).… Read More How to Copy Tracked Changes in Word 2010 and Paste into Outlook 2010 Email
Applies to PowerPoint 2003, 2007, and 2010 This trick allows you to take a slide from any PowerPoint presentation and convert it into an image file (jpeg, gif, tiff, etc.) This comes in handy when you’ve got a slide that contains content that fits well with other materials such as websites, documents, and even email.… Read More Convert a PowerPoint Slide to an Image File
Scroll through Ribbon Tabs in Office 2007 and 2010 You can use the scroll wheel on your mouse to scroll from one tab to another on the ribbon. To Scroll Through Ribbon Tabs: Place the mouse pointer in the ribbon area at the top of the Excel 2007 or 2010 screen. Turn the scroll wheel… Read More Office 2007 and 2010 Ribbon Tips
The following applies to Office 2007 and 2010 Each time you open a file it is stored on your Recent Documents list located within the Office Button menu, allowing you to quickly access that file at a later time. However, it is possible for that file to drop off the list if many other documents… Read More Customize the Recent Documents List in Office 2007 and 2010