Sort range changes during sort

After highlighting the columns and rows I want sorted, I select data and 
sort. At this point the sort range changes to include the entire row from A 
to IV of each row I selected. I've searched the options screen and help menu, 
but don't know why this is happening.

Thanks in Advance.
0
5/24/2005 4:33:17 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
623 Views

Similar Articles

[PageSpeed] 28

This is a complete guess--I couldn't duplicate what happened to you in xl2003.

Do you have merged cells in that range?

If yes, maybe that's the problem.

coffedrinker2003 wrote:
> 
> After highlighting the columns and rows I want sorted, I select data and
> sort. At this point the sort range changes to include the entire row from A
> to IV of each row I selected. I've searched the options screen and help menu,
> but don't know why this is happening.
> 
> Thanks in Advance.

-- 

Dave Peterson
0
ec357201 (5290)
5/24/2005 10:53:21 PM
Reply:

Similar Artilces:

Sorting
Hi, is it possible to use variable for sorting? Something like: declare @sort varchar(10) SET @sort='column1 DESC' SELECT ROW_NUMBER() OVER (ORDER BY @sort)AS rowId, * FROM table Is dynamic SQL only option? Thank you, Simon On 15/04/2010 11:28, simon wrote: > Hi, > > is it possible to use variable for sorting? > > Something like: > > declare @sort varchar(10) > SET @sort='column1 DESC' > > SELECT ROW_NUMBER() OVER (ORDER BY @sort)AS rowId, * FROM table > > Is dynamic SQL only option? You can use CASE to he...

How to sort account list?
I'm using MS Money 2004 Small Business. In the account list, my accounts are catagorized by and in this order: - bank accounts - credit accounts - investment accounts - loans and liabilities - asset accounts TOTAL BALANCE In the above view, I cannot easily determine totals for assets and liabilities. The following view does this. - bank accounts - investment accounts - asset accounts SUBTOTAL -loans and liabilities SUBTOTAL TOTAL BALANCE How do I get the above view? Thanks, Brett I don't use Small Business. But you can run a Net Worth report to get total assets and ...

pivot chart changes when refreshed
Hi I am changing the pivot chart but the changes donot get saved. How ca we make sure that if we r changing the pivot chart options then they permanent. The changes I tried were formatting of series, changing graphs to lin etc...... Can we have a chart like line and bar graph in 1 graph, I am new t pivot charts or a custom chart -- Message posted from http://www.ExcelForum.com This is a known problem with pivotcharts. There's some info in the following MSKB article, which suggests recording a macro as you apply the formatting: XL2000: Changing a PivotChart Removes Series Formatti...

Where's the Sort by New Message option?
Not sure when the layout of the newsgroups changed but I can't seem to find the ability to sort by new message in a thread instead of sorting by just the original thread date. That was hugely helpful as I could follow along and see what threads were still active. If you're gonna hang around in the newsgroups (any newsgroups), you may want to start using a newsreader. Microsoft Outlook Express can do it for you. Saved from a previous post: You may want to connect to the ms newsserver directly: If you have Outlook Express installed, try clicking on these links (or copy and paste i...

Row names will not move with sort
Each row in my summary table in Sheet1 is hyperlinked to a corresponding table in Sheet2 with additional details. I need to move the rows in my summary table (Sheet1) and preserve the links to and from the details tables (Sheet2). I found that I can move rows in Sheet1 with cut & insert and the hyperlinks are maintained. I can travel from a row in summary table (Sheet1) to details table (Sheet2) and back, even after the corresponding row (Sheet1) was moved. But if I sort the rows in Sheet1 the links from Sheet2 back to corresponding rows in Sheet1 lead to presorted locations. Apparen...

Probably very easy question conerning auto-changing dates
I've got a list of dates in column B. Row 1 is labeled "date", Row 2 starts my date data (May-04). I want a list in column B of the preceding 23 months, so columb B ends with Jun-02. Obviously, I can manually input this information. What I can't figure out is how if I go and change the first date (say, to Jun-04) it will auto-change my list of dates accordingly (so my list would now end in Jul-02). NOTE: I know how to create a handle-fill, but it won't update any changes I make to the dates, nor can I get it to go backwards, chronologically. Thanks, Jacob jfarino@ameris...

Expand linked range
I am linked from Excel XP to PPT over a range of cells. This is in 10 charts with separtate links to 100 worksheets. I improved the worksheet by adding some information (3 new rows) an want to expand my linked range without having to delete the original i ppt copy and paste-link the new ranges . Terryve USA -- Message posted from http://www.ExcelForum.com ...

Money Plus Deluxe 2008 Can't Change Account Type
I set up a 401k account as an asset account, instead of a retirement account in an earlier version of Money. I did it that way because that version made it hard to manage if listed properly. I can't figure out how to change it to a retirement account in Money Plus Deluxe 2008. It isn't an option under Change Account Settings. However, if I look at my checking account under Change Account Settings, there is an option to change it to a retirement account. Why can't I change an asset account to a retirement account? -- Jeannine ...

sorts not sorting
OK- Thanks to everyones help I now i have a list i can work with... but there are a few problems.... the zips are all 5 digit and now i have to sort them... the problem is, THEY WONT SORT CORRECTLY!!!!!!! The numbers are not in order... some are but a lot are not... is there anyway to fix this???? i need to sort them by zip code but cant seem to get them to do it correctly.. any ideas??? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ You are going to be far better of...

import- number- sort?
I imported this data into a spread sheet- I tried to format it to number, but when I sort it- I get : 37.08 4.33 4.79 4.8 42.56 5.94 Whats up with this? Thanks Brent Hi Brent, Install the TrimAll macro, select the column and invoke the macro from Alt+F8 http://www.mvps.org/dmcritchie/excel/join.htm#trimall Directions to install and use a macro at http://www.mvps.org/dmcritchie/excel/getstarted.htm#havemacro I expect that you have spaces or CHAR(128) "Required Blank" characters in you data you can check is =LEN(A1) --- HTH, David...

sorting macro #3
I need to sort on 8 cells in a row and on 1500+rows. I can do it one at a time but I know there must be an easier way. Can ANYONE HELP? C3:J3 I need these cells sorted and then down to C1532:J1532 I did create a macro to sort after I selected them but still one at a time. Does it have to be a macro? I can edit a macro but don't really know how to program them. Yes, it has to be a macro. The following should do it. This macro loops through all the entries in Column C, and in each row it sorts the values in Columns C:J. HTH Otto Sub SortRows() Dim rColC As Range Dim i As...

Pivot Table
Hi! What is the maximum rows allowed in a data range when using a pivot table? I have a pivot table that uses a data range. When I have only 4581 records in the data range, the pivot table updates with no problems. But, when entering more than 4581, the pivot table won't update and gives me an error. Am I hitting the max on data rows within my data range or is there a work-around. Thanks!! dmotika The following MSKB articles outline PivotTable limitations for different versions of Excel: XL2000: Limits of PivotTables in Microsoft Excel 2000 http://support.microsoft.com/de...

"Runtime Error: Subscript Out of Range"
What the heck does this mean? If you hadn't guessed, I'm new to macros I'm getting this message when I try to run one of mine. THe macro open another workbook, copies two rows, pastes them, then copies the colo pallette, then closes the other workbook. When I ran them after writin them yesterday, they all worked fine, but now, I'm getting an error Here's the VBA (Which I know nothing about) if it will shed any light Any ideas -- bludovic ----------------------------------------------------------------------- bludovico's Profile: http://www.excelforum.com/member.php?ac...

Protecting range limits
Hola, I need help writing code to protect part of a range given a set of limits. Example: on a 5 x 5 matrix, given n=3, I need to protect rows 4,5 and columns 4,5. Given n=2, I need to protect rows and columns 3,4,5. Help is very much appreciated. Regards, OMER ...

Can we sort a form and also be able to enter new records.
Hi, It is possible to sort the data on a form and also be able to enter new and edit the existing records in it. Cheers! On Tue, 15 Jan 2008 15:41:16 -0800 (PST), Rex wrote: > Hi, > > It is possible to sort the data on a form and also be able to enter > new and edit the existing records in it. > > Cheers! I assume you mean "Is it". The form sort order has nothing to do with editing or adding new records, so the answer is yes. If you cannot edit or add new records, make sure the form's record source, if it is a query, is updateable. Some queries are not. O...

optical trackball
I like to move my MS optical trackball with my fingertips. This means having it "upside down" (cord towards me). On my previous computer, XP provided settings > control panel > mouse > activities which included an "orintation" setting. My newer one doesn't have "activities". Is this something to do with "Intellipoint"? Hugh Momoka wrote: > I like to move my MS optical trackball with my fingertips. This means having > it "upside down" (cord towards me). On my previous computer, XP provided > settings > con...

Sorting checking register
How do i sort my check register in Money 2004 Deluxe so that uncleared transactions appear below cleared transactions? In Quicken i could click on the column to provide that sort. In microsoft.public.money, Dean wrote: >How do i sort my check register in Money 2004 Deluxe so >that uncleared transactions appear below cleared >transactions? In Quicken i could click on the column to >provide that sort. You don't. Available choices are chosen by clicking View at the top of the register. ...

Changing the location of a file through
Hi there, I want to be able to move a file through the use of a command button i vb. The idea would be that after a file was approved it would be moved t the approved folder The form would have a text box with the file location in, below thi ,there would be two command buttons, one approve and one reject. Therefore the file which is waiting to be accepted has the locatio C:\sch and when a comand button (approve) is pressed it moves t C:\sch1, if though it is rejected then it goes to c:\sch2 Is this possible? -- Message posted from http://www.ExcelForum.com Steve, Const sFolder As St...

using addrress books to sort incoming mail
I use address books to sort incoming mail. An odd thing: depending on how the sender's name comes across, it doesn't get caught by the filter (amd moved to the "Family Mail" Folder I have set up. for example: my mom and dad's email (from momanddad@somedomain.com) comes as from that address. However, in my contacts, they are listed by their names: John and Mary Smith, with momanddad@somedomain.com as their email address and John and Mary Smith as the display name. What have I done wrong? TIA 1. The big ONE - failed to post your version of Outlook. Rules operate at ...

Pivot Chart Resets Changes
I'm using a pivot chart for the first time and having some difficulty when the data refreshes. The original chart was an area chart but I changed the second series to be a column chart on the second axis. However, when the pivot table refreshes it changes back to an area chart for both series. What is up? I've written some VBA code to change it back to the way I want but I'd like to know if this is typical of pivot charts or if there is a way I can avoid it. Thanks. - John This is a known problem. There's some info in the following MSKB article, which suggests creating ...

Unmerge so I can sort
I coy/pasted data into Excell and when I try to sort it I get "This operation requires merged sells to be identically sized". I understadn the work around in KB but how do I find which sells are merged? I wouldn't bother looking. I'd just remove all the merged cells from the range to sort. Select that range format|cells|alignment tab uncheck the merge cells box But if you wanted to search, you can do it via process of elimination. Select a range, format|cells|alignment tab. If that merge cells box is checked, then the whole selection is merged. If it's grey, t...

How does excel determine the range of a list?
Hey, I'm working with worksheets that have more than one list on them. I need to define the range of the list and I only know one cell of the list. How does excel determine the range of a list if you select one cell and set the autofilter or sort data? I'm doing this in VBA and was trying to find something like FilterDatabase to define the range but these list are not filtered or named. Hi If first cell is A1 and your list your list has no empty rows in the column before end of the list, you can use this: Set FilterRange=range("A1",Range("A1").End(xl...

sorting issue
Hi, When a range of columns are highlighted and a sort is performed on only one column empty cells above the sort display first. How can this be prevented. I know when there is data in any of the other column but not on the column being sorted this will happen. Any thoughts? Pat Are you sure the cells are really empty? They don't contain spaces or even formulas that evaluate to "". (Even formulas converted to values that returned "")? Pat wrote: > > Hi, > > When a range of columns are highlighted and a sort is performed on only one > column em...

Changing options for Closing a Campaign Response
When converting a Campaign Response, you have the option to close and convert it to a record (New Lead, Existing Lead, or for a customer) or you can just "Close Response", in which case your only options are change the status are either Completed or Cancelled. I want to add more descriptive reasons for closing the response without converting it but I can't find where to do the customization. I've gone to Settings>Customizations>Campaign Response>Attributes and modified the list for Closed, but the Convert Campaign Response Webpage Dialog still only show Comp...

Contact telephone number format keeps changing to a format I don't want
I want my telephone numbers in this format: +II-AA-NNN-NNNN where II is the international country code, AA is the area code and NNN-NNNN is the telephone number. When I edit a contact number it changes my format from +II-AA-NNN-NNNN to +II (AA) NNN-NNNN No matter what I do, I can't get rid of the parenthesis and the "-" symbol gets deleted around the area code number. Ideas on how to keep it the way I like it? Masking of phone numbers is hard coded. You can't configure it. -- Russ Valentine [MVP-Outlook] "��" <news@kidsnews.au.org> wrote in messag...