Data sorting is a daily activity which is required to perform to make data easier to read. If you have large data sets & you want to perform multi-level data sorting i.e. sorting by one column & then another, there are two ways you can perform multiple level data sorting:

• How To Use Microsoft Excel
• Instructions For Microsoft Excel 2010
• Microsoft Excel Download 2010

Microsoft Office 2010 (codenamed Office 14) is a version of the Microsoft Office productivity suite for Microsoft Windows. Office 2010 was released to manufacturing on April 15, 2010, and was later made available for retail and online purchase on June 15, 2010. It is the successor to Office 2007 and the predecessor to Office 2013. Excel 2010 is the spreadsheet application in the Microsoft Office 2010 suite. Get help organizing and calculating data in this Excel 2010 tutorial.

Method 1 – Sort Dialog box

Let us take an example to understand:

We have Sales Report that contains Sales Person, Country & Sales Amount.

We need to sort the report by Sales Person & Country column to look like the below snapshot:

• We need to follow the below steps:
• Select the data
• Click on Data tab
• From Sort & Filter group, click on Sort

• The following Sort dialog box will appear

• In the Sort Dialogue box, select the following options:
• Sort by (Column): Sales Person (this is the first level of sorting)
• Sort On: Values (you can have cell color, font color, cell icon)
• Order: A to Z
• If the data contains headers then, “My data has headers” option needs to be checked

• Click on Add Level to add another level for sorting
• In the second level of Sorting, select the following options:
• Sort by (Column): Country (this is the second level of sorting)
• Sort On: Values (you can have cell color, font color, cell icon)
• Order: A to Z

• Click on OK button, and you will get the sorted data

This sorts data by Sales Person & then by Country column. Sorting will work on text as well as numbers. You can have as many sorting levels as you want.

Method 2 – Sort Icons

This is another way of performing multi-level data sorting which is the faster way. This technique works wherein you have to sort second level first & then move on to first level of sorting.

• You need to select the column that you want to be sorted last (select Country column first)
• Click on Data tab

From Sort & Filter group, click on Sort A to Z icon.

• This will sort the Country column with Canada at the top
• Now select the Sales Person column (this is the column that you want to sort first)
• Click on Sort A to Z icon.

Now the data is sorted by Sales Person column first & then with the Country column.

In case you have multiple levels of sorting (say three levels) then start by sorting the last column (third column) followed by second column & then first column.

In this way, you can get the same result. In case you are sorting by values, you can use Method 1.

Today, here in this article we are going to describe Microsoft Excel most popular version – Excel 2010 problems and errors. Know about the top 5 common Excel problems and solutions.

About Excel 2010 Application:

MS Excel is the most popular and foundational program of the Microsoft Office suite. Nowadays, it is widely used as Reporting and Data Analysis applications. Microsoft time to time releases various versions of Excel for better performance and more enhanced features.

Excel 2010 is the most sophisticated spreadsheet software of the iconic Microsoft program. It is highly advanced and has many enhanced features in it. In Excel 2010 users can easily organize, analyze, chart data, and perform crucial data calculation.

MS Excel 2010 is a very popular version and is widely used by the office as well as business sectors. But despite its popularity and advancement, there are some common known issues encountered by the Excel 2010 users in daily life.

Here through this tutorial, we will talk about some most frequently encountered Excel problems and of course how to fix it.

Best Software To Resolve Excel Problems

To fix various of your Excel problems and errors you must try MS Excel Repair Tool. This is the best tool to repair all sorts of issues, corruption, errors in Excel workbooks. This tool allows to easily restore all corrupt excel file including the charts, worksheet properties cell comments, and other important data.

This is a unique tool to repair multiple excel files at one repair cycle and recovers the entire data in a preferred location. It is easy to use and compatible with both Windows as well as Mac operating systems. This supports the entire Excel version.

Steps to Utilize MS Excel Repair Tool:

Top 5 Common Excel 2010 Problems And Solutions

Here is the list of 5 most commonly rendered Excel 2010 problems and errors.

1# Excel 2010 Not Responding, Hangs, Freezes Or Stops Working

2# Excel 2010 Printing Issues

3# Excel 2010 Found Unreadable Content

4# Excel 2010 Added formulas Performance Issues

5# Excel 2010 Pasting Error

Let’s know about all these Excel problems and solutions one by one in brief.

1# Excel 2010 Not Responding, Hangs, Freezes Or Stops Working

This is a common problem faced by Excel 2010 users. Many Excel users are found reporting in forums “Excel not responding” error or Excel hangs or freezes when you launch Excel, open a file or save a file.

The hanging, freezing, or not responding to issues with Excel 2010, might occur due to many unexpected reasons here in this article we have described some of the common reasons.

Also Read:

Causes:

• Due to outdated antivirus software or another program conflict with Excel.
• If the latest updates are not installed.
• Excel program is in use by another process.
• The previously installed add-in interferes with Excel.
• Also due to advanced troubleshooting.

These are common reason due to which Excel 2010 hang, freeze or show not responding error. Here follow the solution on how to troubleshoot Excel problems.

Resolution:

Well, to fix the hang, freeze, or not respond Excel problems it is recommended to download and install the latest update. Installing important, recommended, and optional updates can often fix problems by replacing outdated files and fixing vulnerabilities.

So, install the latest Office updates and get rid of the hanging, freezing, and not responding Excel 2010 errors.

2# Excel 2010 Printing Issues

This is another issue commonly faced Excel 2010 error. The issue occurs when the user tries to print from a selected area within a spreadsheet it creates a page break for each and every cell, while the users fit the selection to print on one page. And every time the user tries to scale the image it provides a margin error.

Well, this is a very annoying problem here know the common causes and the solution to resolve the Excel 2010 printing error.

Causes:

How To Use Microsoft Excel

It is found that the problem occurs due to the given conditions:

• Due to the corrupted printer driver.
• Or the user is not having a default printer driver.

Resolution:

To fix the error it is recommended to update the printer driver and also try using a different printer driver as the default printer driver. To do so follow the steps given:

1. First, open the Add Printer dialog box:

• In Windows Vista: Click on Start > click Printers.

• In Windows 7: Click on Start, > click Devices and Printers.

2. Now, click Add a printer.

• In the Add Printer box, > click on Add a local printer.
• And click Use an existing port, > click Next.
• Now, in the Manufacturer list > click Microsoft.
• Click Microsoft XPS Document Writer, > click Next.
• After that click Use the driver that is currently installed (recommended) > Next.
• Click to select the Set as the default printer check box, > click Next.
• Lastly, click Finish.

3. Check changing printer drivers fixes the issue:

• Open the spreadsheet in Excel 2010.
• Click File > click the Print tab > click the Print icon.

3# Excel Found Unreadable Content

This is the common Excel 2010 error faced by users while opening an XlsxWriter file and get the error message:

Excel found unreadable content in .xls 2010 do you want to recover the contents of this workbook

This irritating error in Excel’s default warning for any validation error in the XML used for the components of the XLSX file, it is found that the content is an unreadable error is faced due to the corruption of the entire Excel file, or due to the corruption of one or more object in the Excel file.

However, there are possible manual solutions that help to fix Excel errors. To follow the complete fixes,

Visit:FIX: Excel Found Unreadable Content In Filename .xls Error

4# Excel 2010 Added formulas Performance Issues

The slow performance issue is being reported by the Excel 2010 users. The formulas that have a reference for an entire column can create performance issues in XLSX Excel formats. Generally, the formulas that have a reference for an entire column might create performance issues in XLSX Excel formats. This is faced due to the grown column size in the latest Excel 2010.

To fix the issue in Excel 2010 users need to modify the slow-calculating worksheets to calculate tens, hundreds, or even thousands of times faster. To do so change the calculation modes, from automatic calculation mode to manual calculation mode, doing this will help you to avoid the slow the performance issue in Excel 2010 due to added formulas.

Read this post to Learn Different Ways to Fix Excel File Slow To Respond Issues with Bonus Tips

5# Excel 2010 Pasting Error

Excel 2010 pasting error is a very irritating error faced by the users while pasting data from one Excel document to another from time to time.

This error is not faced with the very document but is considered with several Excel documents. Users are getting the error message “The information that you are trying to paste does not match the cell format (Date, Currency, Text, or other formats) for the cells in the column.”

The main reason for getting the error is not identified. However to fix cannot paste data error in Excel 2010, follow the solution given:

Solution:

While trying to paste a large amount of information, ensure that the cell format for the cells in the column matches the format of the information, that you are pasting, and after that paste the information one column at a time.

Instructions For Microsoft Excel 2010

Or else you can also change the cell format for a column to resolve the error.

Follow the steps to do so:

1. First click the column heading (A, B, C, and so on) for the column that is needed to be changed.
2. Then on the Home tab > click the Number Format
3. After that, click the cell format that matches the information you try to paste into the column.

Microsoft Excel Download 2010

Hope that the given solutions will help you to fix common Excel 2010 errors, but if after following the solutions given you are still facing the error. In this case, make use of the automatic solution to resolve Excel problems and start using your Excel 2010 application without any hassle.

Final Verdict:

Thanks for reading the article. I tried my best to cover the complete information about the common Excel problems and solutions. So, if you are using Excel 2010 then check the issues and also follow the solutions to fix it.

In case you have any additional workarounds that proved successful or questions concerning the ones presented. Do tell us in the comments or you can follow us on Facebook and Twitter accounts.

Good Luck…

Margret

Margret Arthur is an entrepreneur & content marketing expert. She writes tech blogs and expertise on MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in easy to understand language is very impressive. When not writing, she loves unplanned travels.