View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default how to move up and down different rows?

Rana

Select all columns with data.

DataSort. Pick the prices column to sort on Descending.

Highest prices will be at the top.

Make sure you select all columns so's they will stay together.

Gord Dibben Excel MVP

On Wed, 24 Nov 2004 15:39:01 -0800, "Rana Mubasir Mehmood" <Rana Mubasir
wrote:

hello, i made a menu for my restauran and showed to the chef, but he wanted
to reorder the menu according to their prices. now i have to move the higher
prices items upward and lower price items downward. how can move i the whole
row to the wanted place up or down?
thanks
rana