Excel 2010 articles
How many times have you been typing away only to glance down and discover that Caps Lock is on? Fortunately, Excel can catch these errors for you – IF I tell it to! Follow the steps below to learn how: On your Ribbon, Click the […]
There are many reasons why you might want to control a user’s input in a worksheet. My number one reason is that it saves time and keystrokes and everyone knows how much I love that! Another reason is that it will limit the choices and
How to Use a Custom Drop-Down List for Choices in Excel 2010 Read More »
Many folks use merged cells in their worksheets and they can definitely be helpful, but many times merged cells can cause you untold heartburn when selecting ranges, sorting and other functions we use in Excel every day. Even if you do not use merged cells
How to Find all Merged Cells in an Excel Worksheet Read More »
Have you ever received a workbook from a colleague and wanted to print selections from more than one worksheet and have them all print on the same page? Sounds like voodoo magic doesn’t it? It can be done and doesn’t involve any crazy magic either!
How to Print Multiple Selections of an Excel Document Read More »
You can easily put more text into a cell than will display properly and while you can widen your column to make the text fit, there are some instances where this might not be advisable. Instead, you can wrap your text within the cell such
How to Adjust Row Heights for Text in Excel 2010 Read More »
If you have ever had a drawing object in your worksheet and wanted to flip it either horizontally or vertically and didn’t know how, this article is for you! Follow the steps below to learn how: Click on the object you would like to flip
Sometimes you just have gigantor Excel worksheets – there’s no getting around it! Now if, in your gigantor worksheet you also have graphs based on your data, you may find that at some point when you are scrolling through your worksheet that redrawing of your
Any time that you have two or more graphics in an Excel worksheet, you want to be certain that they are distanced equally from each other because it is more pleasing to the reader’s eye. This can be easily accomplished with a few easy steps.
Usually one would add borders around a cell or range of cells in their worksheet by selecting the cell or range and using the Border tab of the Format Cells dialog box. BUT, there is a nice little shortcut that saves you time and keystrokes
There are two types of page breaks that can appear in your worksheet in Excel 2010. Those would be Manual and Automatic. As you know, you insert page breaks manually by clicking on the Breaks tool in the Page Layout tab in the Page Setup
How to Control Display of Page Breaks in Excel 2010 Read More »
There are some occasions when you would like to prevent your colleagues from making changes to your cells or perhaps you do not want them to have the capability of seeing your formulas in the Formula bar. Fortunately, Excel will allow you to do this
Excel has always been a great piece of software but Excel 2010 has even more great features and one of them is the ability to use a right-click cell menu to filter a table based on the active cell’s value, font color or fill color.
How to Quickly Filter Data by color in Excel 2010 Read More »
When you work with small worksheets they sometimes look out of kilter when you print them. The reason for this is that Excel prints worksheet data from the upper left-hand corner. To make your worksheet more pleasing to the eye, you can center your data
As you know, when you create a chart in Excel, a chart legend is automatically created right along with your chart depending upon which type of chart you are creating. It doesn’t have to be that way. You have a choice. Follow the steps below
