Microsoft Excel articles
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 »
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
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
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
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
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
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
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 side is the
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
