ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how to move up and down different rows? (https://www.excelbanter.com/excel-programming/317759-how-move-up-down-different-rows.html)

Rana Mubasir Mehmood

how to move up and down different rows?
 
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

Gord Dibben

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




All times are GMT +1. The time now is 04:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com