Help Questions | Solutions | Experts

Select Categories Below

.net [

]

Bluetooth [

]

browsers [

]

C# [

]

computer [

]

Errors [

]

forms [

]

HTML [

]

information tec... [

]

internet [

]

Start Your Own Q&A Site

Create your own Q&A site easily, allowing you to quickly grow a new community around any subject matter or generate new organic traffic for your existing website.

Question

Status: Closed Points: 75 Time: 06:09 - Oct 25, 2007

mary2

How do I set the top line as a title line in Microsoft Excel so I can sort?

I am in excel and the first line is the titles to my rows, but every time I try to sort a column alphabetically it sorts the titles also. Is there a way to set that as a title row?

Categories:

Microsoft Title
Sorting Title Line

Answer Discussion

Tutorials

oracleofDelphi

Date:: Oct 25, 2007

Time:: 11:12

depending on your version of excel,
there is a little box that says (first row contains column headings) check that box and the first row will not be included in your sort.
another way to sort is to select only what you want to sort less the column titles.

oracleofDelphi

Date:: Oct 25, 2007

Time:: 11:13

sorry, the box to check appears if you use the tools->data->sort from the dropdown menu and not the toolbar button.

Question Answered

This question has been closed, and points have been rewarded to the following experts:

oracleofDelphi:

You're welcome however to comment or give additional information or if you wish, you have the ability to write a Tutorial in the Tutorial Area.

Answer this Question

New User

Email:
Upon submission of this form, you will automatically be registered as a Quomon user and we will send your login information to this address

Registered User

Username:

Password:

Forgot Your Password?

No tutorials have been submitted yet. Want to be the first?