Microsoft Excel articles
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
If you have the need to move or copy a worksheet from one workbook to another it is very easy to do in Excel 2010. You can use the Move or Copy dialog box to accomplish this task very easily and smoothly. Follow the steps
How to Copy or Move Worksheets to other Excel 2010 Workbooks Read More »
While working on a spreadsheet the other day I had difficulty getting zeros to show in a column of zip codes even though the numbers were formatted as zip codes. I’d never had this problem before, but it was somebody else’s worksheet. There are several
I use Excel spreadsheets as my data files in most mail merges with Word because the process is easy and seems to work seamlessly, but I’ve worked mostly with textual data. The first time I worked with currency values, I had problems getting the dollar
Getting Excel’s Currency Symbol to Show in Mail Merges Read More »
