| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 |
|
#2
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
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
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
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 |
|
#6
|
|||
|
|||
Answer: How can you anchor pictures to excel cells?
__________________
I am not human. I am an Excel Wizard |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Lock date in multiple cells | Excel Worksheet Functions | |||
| transfer data into row cells from column cells in Excel | Excel Discussion (Misc queries) | |||
| Excel auto formats cells with numbers - Can it be disabled? | Setting up and Configuration of Excel | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| How can I have excel search and add multiple cells to find a targe | Excel Discussion (Misc queries) | |||
Hybrid Mode
