Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 20
Default SORT BY: left to right

Apr ' 05 Feb '05 Jan '05 Jun '05 Mar '05 May '05
1400 1400 1400 1400 1400 1400
700 700 700 700 700 700
220 220 220 220 220 220

2007 version: I want to sort the above excel table Left to Right, in date
order. When clicking F1 for help it suggests adding the default Oldest to
Newest (which I typed in, this option did not appear as a default), but it
didnt work - Help?

I highlighted the above range as follows:
Home | Data | Sort & Filter| Sort | Options | Left to Right...........then
Sort by: Row 1 | Values | Jan, Feb, Mar.... | OK €“ nothing changed!
Thank you

PS: is there a dedicated Forum for 2007 users - most of the links to
tutorials or suggestions to remedy problems come from 2003 users.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort Left-Right & Up-Down Ben Dummar Excel Worksheet Functions 0 April 4th 07 05:56 PM
SORT RIGHT-TO-LEFT IN EXCEL apprentice idiot Excel Worksheet Functions 11 November 25th 06 02:12 PM
sort from right to left in excel colekom Excel Discussion (Misc queries) 2 May 12th 06 01:08 AM
Sort Left to Right not working Juan Excel Discussion (Misc queries) 3 July 29th 05 07:26 PM
Sort Left to Right David Excel Discussion (Misc queries) 1 February 3rd 05 04:18 PM


All times are GMT +1. The time now is 06:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"