Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-06-2014, 08:49 AM
Dave Fraser Dave Fraser is offline Normal sort not bringing along other columns Windows 7 64bit Normal sort not bringing along other columns Office 2007
Novice
Normal sort not bringing along other columns
 
Join Date: Jun 2014
Posts: 2
Dave Fraser is on a distinguished road
Default Normal sort not bringing along other columns

I have a very modest worksheet with columns of text, dates, and numbers. I try to sort a text column and the other columns do not get sorted with the sort column. I've, of course, done this thousands of times successfully. Is there something I am missing??
Reply With Quote
  #2  
Old 06-06-2014, 10:32 AM
whatsup whatsup is offline Normal sort not bringing along other columns Windows 7 64bit Normal sort not bringing along other columns Office 2010 32bit
Competent Performer
 
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default

Hi

The question is how did you do the sorting?
Normally the first cell of the column to be sorted should be selected. Nothing else. By sorting as desired, excel itself will recognize the area to sort.
Reply With Quote
  #3  
Old 06-06-2014, 11:48 AM
Dave Fraser Dave Fraser is offline Normal sort not bringing along other columns Windows 7 64bit Normal sort not bringing along other columns Office 2007
Novice
Normal sort not bringing along other columns
 
Join Date: Jun 2014
Posts: 2
Dave Fraser is on a distinguished road
Default Found the problem.

Thank you for the response. I found the problem. Just to the left of the column that I wanted to sort on, there was a narrow column just used as a spacer. When I removed that column it sorted just fine. Thanks......
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help sorting data in columns that will sort by number of Xs brenna.at.work Excel 8 04-12-2014 07:00 AM
Normal sort not bringing along other columns Bringing in excel data into word dianabanana Word Tables 1 03-20-2014 06:20 PM
quick replace, sort, change columns userman Excel 1 05-01-2012 06:24 AM
Normal sort not bringing along other columns How to sort table having three columns? Bahir Barak Word 2 01-20-2011 01:52 PM
bringing back old files ms_helpneeded Outlook 0 11-18-2009 01:47 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:48 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft