If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
OT - Excel question
Is there some way to make the sheets in a workbook sort themselves
alphabetically within the workbook? Karen, Queen of Squishies -- Remember that when you leave this earth, you can take nothing you have received, but only what you have given. |
Ads |
#2
|
|||
|
|||
OT - Excel question
what version of Excel are you using?
-- Kate in MI http://community.webshots.com/user/K_Groves * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * "Karen, Queen of Squishies" hicall80 @ mchsi.com wrote in message news:NjLPj.133179$yE1.116811@attbi_s21... Is there some way to make the sheets in a workbook sort themselves alphabetically within the workbook? Karen, Queen of Squishies -- Remember that when you leave this earth, you can take nothing you have received, but only what you have given. |
#3
|
|||
|
|||
OT - Excel question
Excel 2002
Karen, Queen of Squishies -- Remember that when you leave this earth, you can take nothing you have received, but only what you have given. what version of Excel are you using? -- Kate in MI |
#4
|
|||
|
|||
OT - Excel question
2002 -- does that mean MAC? I'm working on an answer -- but I'm a PC
person -- so we'll have to see if it will work in MAC world. Does Mac Excel use VB? -- Kate in MI http://community.webshots.com/user/K_Groves * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * "Karen, Queen of Squishies" hicall80 @ mchsi.com wrote in message news:7CLPj.133198$yE1.26510@attbi_s21... Excel 2002 Karen, Queen of Squishies -- Remember that when you leave this earth, you can take nothing you have received, but only what you have given. what version of Excel are you using? -- Kate in MI |
#5
|
|||
|
|||
OT - Excel question
Oh, no, sorry. I have Windows XP Office, with Excel 2002.
Do you use Yahoo IM? That would make things like this a little easier. Just curious. Karen, Queen of Squishies -- Remember that when you leave this earth, you can take nothing you have received, but only what you have given. 2002 -- does that mean MAC? I'm working on an answer -- but I'm a PC person -- so we'll have to see if it will work in MAC world. Does Mac Excel use VB? -- Kate in MI |
#6
|
|||
|
|||
OT - Excel question
I found this answer:
http://www.cpearson.com/excel/sortws.aspx You can use Alt - F11 to open the VBEditor. I am NOT very familiar with this but am contacting a friend for help... -- Kate in MI http://community.webshots.com/user/K_Groves * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * "Karen, Queen of Squishies" hicall80 @ mchsi.com wrote in message news:E6MPj.79480$TT4.73416@attbi_s22... Oh, no, sorry. I have Windows XP Office, with Excel 2002. Do you use Yahoo IM? That would make things like this a little easier. Just curious. Karen, Queen of Squishies -- Remember that when you leave this earth, you can take nothing you have received, but only what you have given. 2002 -- does that mean MAC? I'm working on an answer -- but I'm a PC person -- so we'll have to see if it will work in MAC world. Does Mac Excel use VB? -- Kate in MI |
#7
|
|||
|
|||
OT - Excel question
Yes, you explained it very well! I have 34+ worksheets though, and didn't
really want to do it manually every month. I'd like to be able to sort, print, and put back where they were. My envelopes print alphabetically, and my invoices print chronologically. It's doable right now, but when there gets to be upwards of 50 invoices, it sure would make the sorting and stuffing of the envelopes a lot easier! Karen, Queen of Squishies -- Remember that when you leave this earth, you can take nothing you have received, but only what you have given. The only way that I know is to manually sort them. You can left click on the worksheet and then place the worksheets alphabetically. A blank page will show when you place the mouse cursor over the worksheet. Keep the left click down until the worksheet has moved. I hope I explained this right! Regards Jennifer Edmonton, Alberta |
#8
|
|||
|
|||
OT - Excel question
Wow, very impressive! I don't understand a word of it! LOL
Karen, Queen of Squishies -- Remember that when you leave this earth, you can take nothing you have received, but only what you have given. I found this answer: http://www.cpearson.com/excel/sortws.aspx You can use Alt - F11 to open the VBEditor. I am NOT very familiar with this but am contacting a friend for help... -- Kate in MI |
#9
|
|||
|
|||
OT - Excel question
In article NjLPj.133179$yE1.116811@attbi_s21, hicall80 @ mchsi.com
says... Is there some way to make the sheets in a workbook sort themselves alphabetically within the workbook? Karen, Queen of Squishies The only way that I know is to manually sort them. You can left click on the worksheet and then place the worksheets alphabetically. A blank page will show when you place the mouse cursor over the worksheet. Keep the left click down until the worksheet has moved. I hope I explained this right! Regards Jennifer Edmonton, Alberta |
#10
|
|||
|
|||
OT - Excel question
"Karen, Queen of Squishies" hicall80 @ mchsi.com wrote in message news:NjLPj.133179$yE1.116811@attbi_s21... Is there some way to make the sheets in a workbook sort themselves alphabetically within the workbook? Karen, Queen of Squishies -- Remember that when you leave this earth, you can take nothing you have received, but only what you have given. There's a Data action dropdown on the action bar. In the Data dropdown there is a Sort... action. When this is selected it launches a pop-up window that asks you which column you would like to sort first on and whether it should sort Ascending or Descending. Lastly, if you utilize the first row as a header row, then select that option. There are other "Advanced" options you can select in the Options page, but these are things like Days of week or Months and sort left - right instead of top - bottom. -- badboy |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
expansivity data - excel, burns or byrnes slips | pbhj | Pottery | 0 | April 21st 05 12:47 AM |
MS Excel file for John Flynn backing formula | hfw | Quilting | 1 | December 12th 04 01:12 PM |
OT - Directory - excel format | LN \(remove NOSPAM\) | Quilting | 0 | March 19th 04 12:38 PM |
Importing directory into Excel | AliceW | Quilting | 1 | July 31st 03 03:54 AM |