Ask a Question forum: Alphabetizing a listing

Views: 223, Replies: 16 » Jump to the end
Name: Anna Z.
Monroe, WI
Charter ATP Member Greenhouse Cat Lover Raises cows Region: Wisconsin
Image
AnnaZ
Jan 3, 2016 10:19 AM CST
I have Microsoft "office" that came with my computer. Is there any program in there that will alphabetize a list I make? I want to arrange my recipes in the book I made so I don't have to keep going through the pages and without having to take everything out and arrange myself alphabetically? Some of my pages have recipes on both sides of the paper, and I don't want to have to redo a majority of them.

All I want to be able to do is have the listing in the front of my cookbook alphabetically.




Name: woofie
NE WA (Zone 5a)
Charter ATP Member Garden Procrastinator Greenhouse Dragonflies Plays in the sandbox I was one of the first 300 contributors to the plant database!
The WITWIT Badge I helped plan and beta test the plant database. Dog Lover Enjoys or suffers cold winters Container Gardener Seed Starter
Image
woofie
Jan 3, 2016 12:25 PM CST
What kind of a document is your list? Is it a Word document or a spreadsheet? I like using spreadsheets myself. They're so easy to sort and search.

Oh, wait. In re-readng your post, it sounds like you haven't created your list yet?
Confidence is that feeling you have right before you do something really stupid.
[Last edited by woofie - Jan 3, 2016 12:26 PM (+)]
Give a thumbs up | Quote | Post #1021522 (2)
Name: Anna Z.
Monroe, WI
Charter ATP Member Greenhouse Cat Lover Raises cows Region: Wisconsin
Image
AnnaZ
Jan 3, 2016 12:43 PM CST
No, I have not. If one of those programs would alphabetize, it would be great.
Name: woofie
NE WA (Zone 5a)
Charter ATP Member Garden Procrastinator Greenhouse Dragonflies Plays in the sandbox I was one of the first 300 contributors to the plant database!
The WITWIT Badge I helped plan and beta test the plant database. Dog Lover Enjoys or suffers cold winters Container Gardener Seed Starter
Image
woofie
Jan 3, 2016 12:46 PM CST
I'm assuming your "Office" includes Excel (the spreadsheet program)? I use that for just about everything! It's great for lists.
Confidence is that feeling you have right before you do something really stupid.
Name: Anna Z.
Monroe, WI
Charter ATP Member Greenhouse Cat Lover Raises cows Region: Wisconsin
Image
AnnaZ
Jan 3, 2016 12:54 PM CST
Yes, it does. I will look.
Name: woofie
NE WA (Zone 5a)
Charter ATP Member Garden Procrastinator Greenhouse Dragonflies Plays in the sandbox I was one of the first 300 contributors to the plant database!
The WITWIT Badge I helped plan and beta test the plant database. Dog Lover Enjoys or suffers cold winters Container Gardener Seed Starter
Image
woofie
Jan 3, 2016 1:15 PM CST
That's probably the easiest way to make a list that you can sort. Just remember, if you put information in more than one column, you need to select ALL the columns in order to get everything to sort together. I'd be happy to help if you're not all that familiar with using spreadsheets. Smiling It's really pretty easy.
Confidence is that feeling you have right before you do something really stupid.
Name: Anna Z.
Monroe, WI
Charter ATP Member Greenhouse Cat Lover Raises cows Region: Wisconsin
Image
AnnaZ
Jan 3, 2016 1:53 PM CST
I'd put recipe name and the page number. I'd want to sort it alphabetically by the name, not numerically.
Name: woofie
NE WA (Zone 5a)
Charter ATP Member Garden Procrastinator Greenhouse Dragonflies Plays in the sandbox I was one of the first 300 contributors to the plant database!
The WITWIT Badge I helped plan and beta test the plant database. Dog Lover Enjoys or suffers cold winters Container Gardener Seed Starter
Image
woofie
Jan 3, 2016 2:37 PM CST
If I were doing it, I'd put the recipe name in one column (column a), and the page number in the next column. Then, when you want to sort it alphabetically by name, you'd highlight both columns. Then you go to the "Data" pull down menu and select "sort by column A". Don't know what version of Office you have; that's how it works in the one I have.
Confidence is that feeling you have right before you do something really stupid.
Name: Anne
Summerville, SC (Zone 8a)
Be a voice - not an echo!
Plant and/or Seed Trader Enjoys or suffers cold winters Hybridizer Birds Seed Starter Cat Lover
Pollen collector Morning Glories Greenhouse Bookworm Garden Ideas: Master Level Garden Sages
Image
Xeramtheum
Jan 3, 2016 3:31 PM CST
Easy to do .. I could explain it but this link explains it better - with pictures!

http://www.online-tech-tips.com/ms-office-tips/how-to-sort-t...
"We were all humans until race disconnected us, religion separated us, politics divided us and wealth classified us."

Unknown

Name: Anna Z.
Monroe, WI
Charter ATP Member Greenhouse Cat Lover Raises cows Region: Wisconsin
Image
AnnaZ
Jan 3, 2016 3:31 PM CST
Thanks. I will try that.
Name: Anne
Summerville, SC (Zone 8a)
Be a voice - not an echo!
Plant and/or Seed Trader Enjoys or suffers cold winters Hybridizer Birds Seed Starter Cat Lover
Pollen collector Morning Glories Greenhouse Bookworm Garden Ideas: Master Level Garden Sages
Image
Xeramtheum
Jan 3, 2016 3:34 PM CST
Just realized that this feature is only available in newer versions of word.
"We were all humans until race disconnected us, religion separated us, politics divided us and wealth classified us."

Unknown

Name: woofie
NE WA (Zone 5a)
Charter ATP Member Garden Procrastinator Greenhouse Dragonflies Plays in the sandbox I was one of the first 300 contributors to the plant database!
The WITWIT Badge I helped plan and beta test the plant database. Dog Lover Enjoys or suffers cold winters Container Gardener Seed Starter
Image
woofie
Jan 3, 2016 5:27 PM CST
Heh, and when all else fails, there's always Open Office. Which has the benefit of being free. Smiling
Confidence is that feeling you have right before you do something really stupid.
Name: Anna Z.
Monroe, WI
Charter ATP Member Greenhouse Cat Lover Raises cows Region: Wisconsin
Image
AnnaZ
Jan 3, 2016 6:10 PM CST
I did it in Excel. Thanks for the info. It came out perfect. Only thing I should have changed was make the font a little bigger.
Name: Rob Duval
Mason, New Hampshire (Zone 5b)
Region: New Hampshire Vegetable Grower Daylilies Celebrating Gardening: 2015 Garden Ideas: Level 1 Tomato Heads
Annuals Hostas Lover of wildlife (Black bear badge) Spiders! Dog Lover Region: Northeast US
Image
robertduval14
Jan 3, 2016 6:21 PM CST

Plants Admin

AnnaZ said:I did it in Excel. Thanks for the info. It came out perfect. Only thing I should have changed was make the font a little bigger.



If you select whole columns at a time or even the whole document, you can make a mass change to the font size that way.

Name: Anna Z.
Monroe, WI
Charter ATP Member Greenhouse Cat Lover Raises cows Region: Wisconsin
Image
AnnaZ
Jan 3, 2016 6:26 PM CST
Yes, but I didn't see that the font was small till it started to print. It will be ok this way. At least I won't have to flip through 80 pages for what I want. :>)
Name: woofie
NE WA (Zone 5a)
Charter ATP Member Garden Procrastinator Greenhouse Dragonflies Plays in the sandbox I was one of the first 300 contributors to the plant database!
The WITWIT Badge I helped plan and beta test the plant database. Dog Lover Enjoys or suffers cold winters Container Gardener Seed Starter
Image
woofie
Jan 3, 2016 8:26 PM CST
Hee hee, keep that list on your computer and you can search that without flipping through ANY pages. Big Grin
Confidence is that feeling you have right before you do something really stupid.
Name: Anna Z.
Monroe, WI
Charter ATP Member Greenhouse Cat Lover Raises cows Region: Wisconsin
Image
AnnaZ
Jan 3, 2016 8:51 PM CST
I have saved the list in case I have to add/subtract pages.

« Garden.org Homepage
« Back to the top
« Forums List
« Ask a Question forum
You must first create a username and login before you can reply to this thread.

Today's site banner is by dirtdorphins and is called "Dianthus 'Nyewood Cream'"