Excel 2010

Excel 2010 articles

  • excel

    Center Printed Excel 2010 Worksheets

    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 horizontally, vertically or both if you like. Follow the steps […]

  • excel

    How to Turn the Excel Chart Legend On or Off

    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 to learn how: Click once on your legend to select […]

  • excel

    How to Create a Single Use Drop-down List in Excel 2010

    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 they have made their selection and moved on to another […]

  • excel

    How to Freeze Excel 2010 Top and Bottom Rows

    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 MS Excel. You might think you could freeze your rows […]

  • excel

    How to Set Row Label Width in Excel 2010

    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 top 50 rows are frozen so she can always see […]

  • excel

    How to Control the Formula Bar Display in Excel 2010

    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 side is the Name Box and on the right-hand side […]

  • excel

    How do You Change the Cell Color in Excel 2010

    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 a small paint bucket and color sample. If you click […]

  • excel-logo-image

    How to Change Cell Colors in Excel 2010

    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 has a small paint bucket and color sample. If you […]

  • excel-logo-image

    How to Hide the Excel 2010 Formula Bar

    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 Name Box and on the right-hand side is the contents […]

  • excel-logo-image

    How to Freeze Top & Bottom Rows in Excel 2010

    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 MS Excel. You might think you could freeze your rows […]

  • Getting Zeros to Show in Excel

    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 ways to approach this problem. You can try formatting the […]