How to Hide Row and Column Headings in Excel 2010

The numbers and letters at the top and left side of your Excel 2010 spreadsheet are called headings. They are a helpful way to identify your location in a spreadsheet, plus they are also beneficial for ensuring that you are making a change in the correct cell. But, depending upon your current needs, they might […]

How to Average a Group of Cells in Excel 2010

Microsoft Excel 2010 has a lot of tools that you can use to easily accomplish tasks that Excel users commonly perform. While many of these tools are geared toward editing data and changing the layout and appearance of your spreadsheets, Excel 2010 can also use a number of formulas and utilities to compare and summarize […]

How to Hide a Sheet in Excel 2010

Excel 2010 has many formatting options that allow you to customize the way that data is displayed in your spreadsheet. If you are working with a large spreadsheet, for example, you may want to hide individual columns and rows so that you are only viewing the data that is relevant to your current task. But, […]

How to Remove Duplicates in Excel 2010

Last updated: March 10, 2017 You may discover that you need to learn how to remove duplicates in Excel 2010 when you are working with data in a spreadsheet that is difficult to sort or analyze because there are too many instances of the same cell data. While deleting individual rows to remove these duplicates […]

How to Split Data in One Column to Two Columns in Excel 2010

Correctly formatted data is very important when you are trying to get information into a database, or if you are working with a formula in your Excel spreadsheet. So if you encounter a column of data in a spreadsheet that contains information that you might need divided into two columns, the prospect of manually copying […]

Convert CSV Comma Delimited File to Pipe Delimited

CSV files are helpful for a lot of different reasons, but mainly due to their compatibility with a lot of different types of programs. Unfortunately all CSV files are not created or formatted in the same way, so you can run into situations where a CSV file is not compatible with what you are attempting […]

How to Print Comments in Excel 2010

Last updated: March 13, 2019 While Microsoft Excel 2010 spreadsheets, in their default format, contain many ways for you to alter the appearance of your worksheets, the only way to add new information is by typing directly into the cells. When you are creating a simple spreadsheet by yourself, this is probably fine. But if […]

How to Change Border Color in Excel 2010

Microsoft Excel 2010 is an almost infinitely customizeable program. Aside from being able to choose, edit and modify every cell in your spreadsheet, you can also set options for how the cells are displayed. This does not apply to only the data in the cells, however. You can also customize the way that the cells […]

How to Get Out of Header and Footer View in Excel 2010

One of the biggest problems people encounter when they are printing out a lot of similar Excel 2010 spreadsheets, or if they are working on a lot of them on their computer, is that they can be difficult to distinguish from one another. This is further exacerbated if you print out the same report each […]

How to Ignore the Print Area in Excel 2010

Last updated: March 9, 2017 Learning how to set a print area in Excel 2010 provides you with the option of choosing a group of cells in your spreadsheet that you want to print. Many spreadsheets, especially larger ones, often include data that is less important than other data. For example, you might have a […]