Excel 2010 and 2013 gives you the option to add watermarks to your worksheets. The steps are different in each version. Here’s the differences.
Tag Archives | excel 2010
Microsoft Excel lets you customize the way your worksheets look to improve their appearance. Changing the color of Gridlines is just another way to make Excel data more attractive and less boring.
Some might think changing the default color scheme in Office 2010 is a small thing however I would disagree. I use this app all day, every day so for me, changing the default to black was a huge improvement.
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 […]
Comparing Excel 2010 spreadsheets side by side makes it easy to view data in two XLSX or XLS documents. Just follow this easy tutorial.
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 […]
We’ve already looked at customizing the Office 2010 ribbon in detail, but this time we’re going to be a little more specific. The Developer tab is a pre-built custom tab that by default has a good variety of advanced actions, and enabling it is simply a lot faster than searching for and adding these to […]
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 […]
Microsoft Office has recently taken to the clouds, and if you haven’t already started using your SkyDrive and Office Live Web Apps, here’s another good reason to start. Using your SkyDrive, you can embed PowerPoint presentations and Excel spreadsheets in any web page or blog post. That way, your readers can view entire PowerPoint presentations […]
In Excel 2010 and 2007, a handy feature I use all the time during budget season is the Data Validation feature which allows you to create an in-cell Drop-Down list for populating fields. Since several of us work on the budget together, by using the drop down lists I can keep the data normalized saving […]
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.
Yesterday I explained how to score a copy of Office 2010 on the cheap or even free and today I have another groovyDeal for college students! Microsoft this week upgraded its Educational Student discount program from Office 2007 to Microsoft Office Professional Academic 2010. The Office Pro Academic 2010 Suite includes: Word 2010 Excel 2010 […]