How do I sort in Excel with sub bulleted text?

J

Jerome

For example, I am organizing a new document that needs to be alphabeticalized
for easy referrence. Each topic though has sub bullets. I've tried to sort it
by highlighting the spreadsheet but it rearranges the whole text.

Is Excel the better product or would Word work better?
 
J

Joel

Microsoft Office products (such as excel) always have a lot more capability
than Microsoft Works. for Excel to do what you need it to do you have to
enter the data in the right locations and formats.

If you have something like this

Column A column B
Topic A
Sub Topic A
Sub Topic B


You may need to add a new column

Column A Column B Column C
Topic A
Topic A Sub Topic A
Topic A Sub Topic B


Then sort on new columns A & C.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top