How to Make a Custom Header in Excel 2010

When you are dealing with large amounts of data in Microsoft Excel 2010, your printed spreadsheets can get confusing. This can be multiplied depending upon the number of spreadsheets you are working with and, if you print out the same spreadsheet on a daily or weekly basis, it can become difficult to tell which one […]

How to Format Alternating Row Colors in Excel 2010

Improving the display of your spreadsheet is important when you are trying to improve the readability for a human audience. Most people have a hard time reading and understanding large sets of a numbers in a traditional spreadsheet layout, so you need to take action to present the material in a way that is more […]

How to Sort By Color in Excel 2010

Last updated: February 7, 2017 Excel includes a number of different ways that you can filter data. So if you are wondering how to sort by color in Excel 2010, you might be struggling to figure out where that option is located, or even if it is possible. Fortunately you can sort by color in […]

How to Lock a Cell in Excel 2010

Some Microsoft Excel 2010 spreadsheets can be more complicated than others. Very involved worksheets can include a combination of formulas and information that is very complex, and even slight changes to certain cells could lead to disastrous occurrences for the rest of the data on the sheet. If you have finalized such a complex worksheet […]

How to Center Worksheet Horizontally and Vertically in Excel 2010

Updated: December 23, 2018 By default, Microsoft Excel 2010 will print your spreadsheet based upon how it is laid out in the spreadsheet. Since most people start creating their spreadsheets from the A1 cell, this means that most Excel 2010 documents print from the top-left corner of the page. You can change this, however, by […]

How to Justify Text in Excel 2010

While Microsoft Excel 2010 is most useful as a means to store, organize and compare data, you will eventually have to put some of your data into a format that is readable to a human audience. Unfortunately some of Excel’s default settings can have text aligned on corresponding sides of cells (for example, a left […]

How Do I Make Columns Automatically Expand in Excel 2010

The default cell size in Microsoft Excel 2010 can fit approximately 8.5 characters. When you are working with small numbers and no letters, this sizing is going to be appropriate for most situations. Unfortunately not everyone works with data like that, and you may find yourself needing wider columns on a regular basis. While you […]

How to Automatically Number Rows in Excel 2010

When you are first creating a set of data in Microsoft Excel 2010, there is probably a lot of data entry that is occurring. While this is, by its’ very nature, a tedious activity, it can be made even more so if you are just typing slightly different values on each row. For example, “Product […]

Disable Formula Updates in Excel 2010

You can use formulas in Microsoft Excel 2010 to perform calculations based upon the values in your spreadsheet. The benefit to using cell numbers and letters over actual values is that the formulas that you have created will update their values if you edit a cell value. This is extremely helpful and can aid you […]

How to Merge Cells in Microsoft Excel 2010

If you are lucky enough to be working with an Excel spreadsheet where all of the data can be arranged in the default layout without any additional configuration by you, consider yourself lucky. Individuals making spreadsheets that require no formatting are certainly in the minority. If you have read this article about adjusting your cell […]