+ Reply to Thread
Results 1 to 10 of 10

Sorting

  1. #1
    Registered User
    Join Date
    10-10-2013
    Location
    Surrey, England
    MS-Off Ver
    Excel 2007
    Posts
    19

    Sorting

    I am using Excel as a database with data in 3 columns. How can I sort out the database alphabetically on the first column when the rows are of different widths as it always seems to upset the row widths making some of them very wide and others so narrow data in the other columns is hidden.

  2. #2
    Forum Contributor
    Join Date
    08-04-2013
    Location
    Bucharest
    MS-Off Ver
    Excel 2013
    Posts
    287

    Re: Sorting

    Please attach a sample of the file so we can see exactly what the issue is.

  3. #3
    Registered User
    Join Date
    10-10-2013
    Location
    Surrey, England
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Sorting

    I have extracted a small section of my Excel database and tried to upload it but it is a Word document and I can only upload a jpeg etc. I cannot see how to convert my Word document to a jpeg or other document.
    Attached Files Attached Files

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,876

    Re: Sorting

    Sorry, but that's not much help, either. Why not post it as an Excel file???
    Glenn



  5. #5
    Registered User
    Join Date
    10-10-2013
    Location
    Surrey, England
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Sorting

    Try again!!

    The problem I am having is that if I want to add names I would normally add them to the bottom of the database and then sort them alphabetically into their correct positions. When I do this the rows are thrown out and I have to readjust them which I do not want to do every time.Sample.xlsx

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,749

    Re: Sorting

    I added copies of some of your data at the bottom, then sorted - it sorted fine and the row hights were maintained
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  7. #7
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,809

    Re: Sorting

    Quote Originally Posted by grahamila View Post
    Try again!!

    The problem I am having is that if I want to add names I would normally add them to the bottom of the database and then sort them alphabetically into their correct positions. When I do this the rows are thrown out and I have to readjust them which I do not want to do every time.Attachment 333472
    I, too, had no difficulty maintaining widths.

    I did notice, however that your numbered entries in column B show up as if entered as one line with multiple spaces (?) between them. I've had difficulties with those, too.

    Try ending those lines within the cell with Alt+Enter. This puts a carriage return-line feed after each numbered entry just like you were typing a Word document within each cell.

    Hope this helps.

  8. #8
    Registered User
    Join Date
    10-10-2013
    Location
    Surrey, England
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Sorting

    Thanks FDibbins and FlameRetired for your postings and I apologise for not responding sooner. The advise about Alt+Enter is new to me so I will modify my spreadsheet. Also, after each entry I dragged the gridline below the details down to create a space between entries so I don't know if that might have thrown things out later when adding names. If I use Alt+Enter at the end of each entry to create that space I would like is that likely to cause problems?

  9. #9
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,876

    Re: Sorting

    No. It should be OK. See the pink row, where I've used ALT-Enter for within-cell line breaks. The only thing you need to know is that you may need to adjust the formula pane so you can see everything (I've made it very large here for you to see. resize by left click at the interface between the formula pane & the column header letters & drag up/down..
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    10-10-2013
    Location
    Surrey, England
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Sorting

    Many thanks for this. I have modified my spreadsheet using Alt+Enter and all seems well. I have found in a couple of places where I added 2 spaces by mistake at the end of each entry instead of 1 without noticing it I am unable to delete the additional space when I go back to the entry. Alt+Backspace does not work as it would in a Word document.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 02-24-2014, 11:27 AM
  2. Sorting by Date--Need help when sorting by 2-digit year
    By Farris_TN in forum Excel General
    Replies: 3
    Last Post: 06-20-2013, 11:20 AM
  3. Sorting 2 data ranges by comparing one column in each and sorting to match
    By MDKsmiffy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-17-2013, 03:30 PM
  4. Sorting a range to invert it upside down without sorting by any specific column
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-29-2013, 12:53 PM
  5. [SOLVED] Sorting a range to invert it upside down without sorting by any specific column
    By luv2glyd in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-28-2013, 12:43 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1