How to Make Sortable Headings in Excel

Statistical information can be created with the help of Excel. Different designs are available to us and we can use all sorts of tools to interpret different sets of data available. It is highly unlikely that someone will just use Excel software to store data in it. (Excel is software that is being developed by the Microsoft professionals to help people with different statistical and mathematical solutions). You need to input data and choose different fields. All sort of statistical functions are available in Excel and you can even use user defined functions to run any queries.

Detailed documents and reports can also be created in Excel and that are very useful because the data itself can’t help anyone unless it is being represented in a form of a report which makes sense. You can also perform simple image editing tasks as well like cropping and formatting it a bit. Some formulas are built-in the system like Autosum and Average whilst others can be written manually depending on the need of the time. There is another feature that helps to filter functions like you can sort or rearrange data using the columns.

Instructions

  • 1

    Open Microsoft Excel and then start creating a spreadsheet with the help of the File button which has an option of “New” spreadsheet. Know the columns that will contain the data which needs to be sorted out by you. If you will not know what columns or rows that data is kept then you won’t be able to input the formula correctly and the data sorted will be incorrect because some of the data will be omitted or extra data will be kept in the query.

  • 2

    Click the “Home” tab and browse the “Cells” that needs to be sorted out. Click in the “Insert” option and choose the “Insert Sheet Rows” option. You must put a caption at the top of each column so that you can distinguish each column from others like Name, National Identity Card number, Address, Phone Number, Gender, Qualification etc.

  • 3

    Select all rows that need to be sorted out. Highlight them very carefully and make sure no data is left so that you sort out the right collection of data. You can select the columns by choosing the header only because the whole column is selected automatically.

  • 4

    Go to “Data” tab. Click “Sort & Filter”. Click “Filter”. Choose columns and click “Sort”.

Leave a Reply

Your email address will not be published. Required fields are marked *


three − = 1

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>