Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i sort a data sheet which has images in it also?
hi can anyone help me with this. i am new here any help will be appreciated.
thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i sort a data sheet which has images in it also?
With my limited testing, I found that images move with Sort if the image is
completely contained in the cell... In Format Picture - Properties I chose 'Move but do'nt size with cells' option. "Arpit Gupta" wrote: hi can anyone help me with this. i am new here any help will be appreciated. thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i sort a data sheet which has images in it also?
You want the images to sort with the cells?
Difficult to do as images cannot be inserted in cells, only lay on top. One method is to size the images to fit within the cell boundaries of adjacent cells then Format the images to "move and size with cells" Select both columns and sort on the cells with data. Gord Dibben MS Excel MVP On Thu, 11 Sep 2008 13:05:01 -0700, Arpit Gupta <Arpit wrote: hi can anyone help me with this. i am new here any help will be appreciated. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cross-sheet formula and sort data | Excel Worksheet Functions | |||
How to sort and filter when there are images invloved | Excel Discussion (Misc queries) | |||
How to sort data with off-sheet dependents? | Excel Discussion (Misc queries) | |||
Help to sort out filtered data from the data contained in another sheet of the same workbook | Excel Worksheet Functions | |||
Sort data from 1 work sheet into another | Excel Worksheet Functions |