Here’s how to add up and down buttons to your Excel spreadsheets. First enable the developer ribbon. On the developer ribbon, click Insert >> Spin Button. Next click the cell where you want the spin button to appear. Next select the Spin Button. On the developer ribbon, click Properties. An options box appears. Click the control tab. Enter values if […]
Sometimes you need to make large spreadsheets easier to read. Alternating colors between rows is a good way to do it. Here’s how. In Excel, assigning an alternating color scheme to rows is known as color banding. Start by selecting the cells you want to apply color banding to. Or press [Ctrl][A] to select the […]
Ready to remove those pesky empty cells in Excel? Here’s how to do it. Open your spreadsheet and press [Ctrl] [A] to highlight the entire document. Or highlight just the section of the spreadsheet where you want to remove empty cells. Now, press F5 on your keyboard. The Go To menu will appear. Click the Special button. The […]
Pie charts are an effective way to visually analyze data sets. And since most people love pie, it’s a widely accepted format to present data to customers or management! All jokes aside, it might seem difficult to get started with a pie chart, but Microsoft Excel is an excellent tool for producing them with just […]
Shortly after upgrading to Microsoft Office 2007 I ran across this nice FREE add-on from Microsoft which allows you to save your documents in the Adobe PDF or Microsoft XPS format using all eight Microsoft Office 2007 applications. I use the feature almost daily so I’m sure all you groovyReaders will appreciate the find! […]
If you’ve ever right-clicked in Microsoft Word 2010 or Word 2007, you’ve noticed something new: the Mini Toolbar. This right-click toolbar appears above the usual contextual menu and is essentially the same as the Font Toolbar in your Home ribbon. In other words, its mostly extraneous and to most of us, totally annoying. By popular […]
Using data from a live feed on the web is the best way to keep your Excel 2010 spreadsheets automatically up to date. This can come in handy if you are tracking the prices of something, or even your favorite sports teams’ score boards. (more…)
Microsoft this week released Office 2007 Service Pack 2 for both their Office Products and Server products which they are advertising as providing new bug fixes and improving stability and performance. I can’t think of a reason why you wouldn’t want to go grab these installs immediately and get them installed however before you run […]
Windows 2007 is packed with great features, but many many new users complain about the new Navigation Ribbon. One of my users at work, for instance, spent 20 minutes looking for the PRINT option before calling me. Ouch. So, recently I went on a search to bring back the old Navigation File Menus from Office […]
If you need to protect a sensitive document, Microsoft Office 2007 makes it easy. By following the simple step by step process below you can easily Password Microsoft Word 2007, Excel 2007 and PowerPoint 2007 documents (and even Access 2007, however, that’s a separate article). Using passwords can prevent other people from opening or modifying […]
