#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default sort

I am trying to sort a column data. I have selected the data in a
column I want to sort. When I try to sort, the selection slips one row
down.

So If I want to sort then I have to select one more cell above the
cell from where I want to sort.

In one excel it works fine, but in some other workbook it gives
problem.

How to solve this problem

Simha Rupa Das
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default sort

The sort dialogue should have an option to let you tell it whether you have
a header row or not.
--
David Biddulph

wrote in message
...
I am trying to sort a column data. I have selected the data in a
column I want to sort. When I try to sort, the selection slips one row
down.

So If I want to sort then I have to select one more cell above the
cell from where I want to sort.

In one excel it works fine, but in some other workbook it gives
problem.

How to solve this problem

Simha Rupa Das



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 function for dates does not sort properly in Office 2007 Exc. Rosalie Excel Worksheet Functions 1 November 22nd 07 10:25 PM
data, sort option is grayed. how to sort on a column? Steve Richter Excel Discussion (Misc queries) 1 September 25th 07 03:25 PM
Ascending Sort formula, change to neg #: descending sort.. nastech Excel Discussion (Misc queries) 6 July 2nd 07 11:00 PM
Excel sort by Fill Color by custom list sort Dash4Cash Excel Discussion (Misc queries) 2 July 29th 05 10:45 PM
how can I hide sort ascending and sort descending options in the . vida Excel Discussion (Misc queries) 0 December 11th 04 12:31 AM


All times are GMT +1. The time now is 11:07 PM.

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

About Us

"It's about Microsoft Excel"