How to Set Print Margins in Excel 2010

Last updated: March 7, 2017 You will need to know how to change the page margins in Excel 2010 if you encounter a spreadsheet that is either slightly too big to fit on a printed page, or f the spreadsheet might look better if it had larger margins. But the method for changing page margins […]

How to Hide Columns in Excel 2010

Dealing with large amounts of data in Microsoft Excel 2010 can be a bit of a headache. This is not a fault of Microsoft Excel, however. Most of the trouble lies in the size of the screen on which you are viewing the spreadsheet and the amount of data that you can see at once. […]

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 […]