Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 16th 06, 06:03 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 77
Default 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   Report Post  
Old November 16th 06, 06:17 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,058
Default 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   Report Post  
Old November 16th 06, 06:17 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5,942
Default 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   Report Post  
Old November 16th 06, 06:46 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 77
Default 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   Report Post  
Old July 18th 07, 12:38 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 1
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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


All times are GMT +1. The time now is 03:49 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017