![]() |
How do I sort in Excel with sub bulleted text?
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? |
How do I sort in Excel with sub bulleted text?
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. "Jerome" wrote: 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? |
All times are GMT +1. The time now is 04:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com