View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mahurshi Akilla Mahurshi Akilla is offline
external usenet poster
 
Posts: 8
Default Mirroring Data in Excel

Is there an easy way to "mirror" data in excel ?

e.g.
Let's say I have the following values in one row
1 2 3 4 5

I would like to make it
5 4 3 2 1

I tried using =[cell_number] in a separate row and did a control+R,
but it did not pick it up correctly.

Any ideas on how to do this?


Mahurshi Akilla