Microsoft Excel articles
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 »
On some occasions, your Word table can contain formulas that are too long for the smaller cells in your table and that prevents them from being displayed completely when you look at your field codes rather than the results of your field codes. Word does
How to Easily View Formulas in Excel Cells 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
How to Protect an Excel 2010 Worksheet Read More »
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 »
A very cool shortcut you can use in Excel 2007 allows you to copy data from the cell above the current cell. Follow the steps below to learn how: Click Ctrl + “ (quotation mark) Say you enter the number 456 in cell A6. If
How to Quickly Enter Similar Data in an Excel 2007 Worksheet Read More »
You may know that you can enter multiple lines within a single cell by simply clicking Alt + Enter at the end of each line, which starts a new line for you. With a little work you can use that tidbit to create a
How to Create a Single Cell Bulleted List in Excel 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
Center Printed Excel 2010 Worksheets Read More »
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
How to Turn the Excel Chart Legend On or Off Read More »
There is a really cool way you can use the validation feature in Excel and that is to create a single-use drop-down list. Your list will allow users to select the cell and then select from a list of pre-defined values for that cell. Once
How to Create a Single Use Drop-down List in Excel 2010 Read More »
If you have a very large worksheet containing rows and rows of data it would be a lot easier for you if you were able to freeze both the top and bottom rows of your worksheet. Unfortunately, there is no way to do this in
How to Freeze Excel 2010 Top and Bottom Rows Read More »
A client wrote to me recently with this problem: She had a worksheet with about six thousand rows (yes, those do exist!). At the very top of her worksheet there is a graph based on her data with the data starting at row 50. The
How to Set Row Label Width in Excel 2010 Read More »
You all know the Formula Bar resides at the top of your Excel window, immediately below the Ribbon area or the Formatting toolbar depending on which version of Excel you own the license to. There are two parts of the Formula Bar: On the left-hand
How to Control the Formula Bar Display in Excel 2010 Read More »
There is a tool in Excel that allows you to very quickly and easily change the color of a selected cell. That would be the Fill color tool, which can be found on the Formatting toolbar or the Home tab of your Ribbon and has
How do You Change the Cell Color in Excel 2010 Read More »
There is a tool in Excel that will allow you to very quickly and easily change the color of a selected cell. That would be the Fill color tool, which can be found on the Formatting toolbar or the Home tab of your Ribbon and
How to Change Cell Colors in Excel 2010 Read More »
