|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 16th 06, 06:03 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
How can you anchor pictures to excel cells?
I am attempting to paste pictures into individual excel cells and cannot
figure out how to anchor a picture to a cell, so that if I sort, the pictures travel with the appropriate rows. Thanks, Laura 
|
| Ads |
|
#2
November 16th 06, 06:17 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can you anchor pictures to excel cells?
You can put a picture in a comment and the comment will travel with the cell.
However, the comment can "drift" and may need occasional adjustments, especiallly if rows/columns are added/deleted. -- Gary's Student "Laura" wrote: > I am attempting to paste pictures into individual excel cells and cannot > figure out how to anchor a picture to a cell, so that if I sort, the pictures > travel with the appropriate rows. > Thanks, Laura
|
|
#3
November 16th 06, 06:17 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can you anchor pictures to excel cells?
The picture must be entirely within the cell (or row) otherwise there is
nothing that can be done. Assuming that this is feasable then all you need to do is to right click the picture -> select format -> select move and size with cell... that should do it... -- HTH... Jim Thomlinson "Laura" wrote: > I am attempting to paste pictures into individual excel cells and cannot > figure out how to anchor a picture to a cell, so that if I sort, the pictures > travel with the appropriate rows. > Thanks, Laura
|
|
#4
November 16th 06, 06:46 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can you anchor pictures to excel cells?
Thank you so much. I had gotten to the point of right clicking, selecting
format, and selecting move and size with the cell, but hadn't noticed that some of the pictures were not entirely within some of the cells. Have a great day! "Jim Thomlinson" wrote: > The picture must be entirely within the cell (or row) otherwise there is > nothing that can be done. Assuming that this is feasable then all you need to > do is to right click the picture -> select format -> select move and size > with cell... that should do it... > -- > HTH... > > Jim Thomlinson > > > "Laura" wrote: > > > I am attempting to paste pictures into individual excel cells and cannot > > figure out how to anchor a picture to a cell, so that if I sort, the pictures > > travel with the appropriate rows. > > Thanks, Laura
|
|
#5
July 18th 07, 12:38 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can you anchor pictures to excel cells?
I still can't get it to work. The picture stay in the cell, but when I filter
it gets all jumbled. Am I missing something? "Jim Thomlinson" wrote: > The picture must be entirely within the cell (or row) otherwise there is > nothing that can be done. Assuming that this is feasable then all you need to > do is to right click the picture -> select format -> select move and size > with cell... that should do it... > -- > HTH... > > Jim Thomlinson > > > "Laura" wrote: > > > I am attempting to paste pictures into individual excel cells and cannot > > figure out how to anchor a picture to a cell, so that if I sort, the pictures > > travel with the appropriate rows. > > Thanks, Laura
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel - Lock date in multiple cells | tungsten222000 | Excel Worksheet Functions | 3 | September 1st 06 07:10 AM |
| transfer data into row cells from column cells in Excel | Bernard Modlinsky | Excel Discussion (Misc queries) | 3 | August 12th 06 08:07 PM |
| Excel auto formats cells with numbers - Can it be disabled? | Jeromey | Setting up and Configuration of Excel | 1 | May 21st 06 01:17 AM |
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | MEGTOM | New Users to Excel | 5 | October 27th 05 03:06 AM |
| How can I have excel search and add multiple cells to find a targe | Blakepro | Excel Discussion (Misc queries) | 1 | April 1st 05 02:37 AM |
Linear Mode
