Really basic question about A-Z sorting in Excel

P

pattyclarke

New Member
Joined
Jul 13, 2010
Messages
2
I just bought a new HP computer with the Windows 7 O/S and the 2010 [FONT=inherit!important]Microsoft Officehttp://forums.techguy.org/business-applications/935321-really-basic-question-about-z.html package. (Huge learning curve for me from the ten year old system I had.)

I do the record-keeping for a fun NASCAR pool for my friends. There are 30 columns with the players name at the top and then weekly I update the drivers picked list because you can't have duplicates. In the 2003 version I would just highlight the drivers and choose sort AtoZ and it would happen. Now when I do that I get a "Sort Warning" that says "[FONT=inherit!important]Microsoft[/FONT] Excel found data next to your selection. Since you have not selected this data, it will not be sorted. What do you want to do?" The default is set at "Expand the selection" with the option of choosing "Continue with the current selection." So each time I have to select the "Continue with current selection" and then sort. It is irritating and time consuming. Is there a way I can disable this sort warning function? (No fancy formulas or anything involved.)

Thank you in advance for your help.

Patty <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>[/FONT]
<o:p> </o:p>
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Sort by date Sort by votes
Hello Patty

Insert an empty column to the right of the driver's column.
 
Upvote 0
Thank you Shift-del, that worked perfectly. So would it be a safe assumption that I need to have blank columns with other things I might do such as accounting spread sheets where I would want to add the first quarter figures to the column of second quarter figures to come up with a year to date column?

I'm so happy that you were able to help me so quickly.

Patty
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question
Need help creating a second ListBoxOutput without corrupting the first.
Replies
3
Views
296
Blasirl
B
R
  • Question
Use Excel as MS-Outlook clone to handle MSG files
Replies
0
Views
2K
RoVBA
R
T
  • Question
Data Sort Question: Pivot Table?
Replies
1
Views
278
Jerry Sullivan
Jerry Sullivan
C
  • Question
Visual Basic Code - Cannot add more times to code.
Replies
4
Views
1K
civilred
C
E
  • Question
Seemingly Complicated Excel Question
Replies
4
Views
1K
ebase131
E

Forum statistics

Threads
1,214,950
Messages
6,122,428
Members
449,083
Latest member
Ava19

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top