how do i sort a data sheet which has images in it also?

  • Thread starter Thread starter Arpit Gupta
  • Start date Start date
A

Arpit Gupta

hi can anyone help me with this. i am new here any help will be appreciated.

thanks
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to filter rows data based on background color of individual cells 1
advise on how to import data into excel sheet 1
Sorting Text Data 4
How do I sort a database without also sorting the column heading? 1
copy rows from one Data sheet to another sheet based on cell conte 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Sorting Automatically 3
Sort Data 1

Back
Top