Excel 2010 articles
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
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
Once you have your ribbon customized perfectly and want everyone else to have the same, it’s a very easy task to share with your colleagues. Follow the steps below to learn how: Right-click your Ribbon and select Customize the Ribbon. Just below the the list
You may have an occasion when you would like to copy cells from your current workbook to a new one. Fortunately, this is very easy to do. Follow the steps below to learn how: Close all open workbooks except for your current on and the
Folks define names in their Excel worksheets all the time and they can sometimes end up with so many names that they have difficulty remembering them or finding them! Of course, you can can jump to a named range by clicking on F5 to open
