ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I "glue" a picture in a cell and treat it as content? (https://www.excelbanter.com/excel-discussion-misc-queries/113219-how-can-i-glue-picture-cell-treat-content.html)

smaruzzi

How can I "glue" a picture in a cell and treat it as content?
 
I would like to assign a cell a graphical content, such as a small image. It
then would be great if I could treat a graphical content as normal text or
numbers. In other words, copying and moving the content as in a regular cell
reference.

Thanks, Stefano

Elkar

How can I "glue" a picture in a cell and treat it as content?
 
This may not be what you're looking for, but one option would be to insert
your graphic into a Comment. The comment is assigned to a cell, and thus
would move/copy with the cell.

Select your cell
From the Insert Menu, select "Comment"
Right-Click the border (outer dashed line) of the comment
Select "Format Comment"
Select the "Colors and Lines" tab
In the Fill Color box, select "Fill Effects"
Select the "Picture" tab
Click the "Select Picture..." button
Find your picture file, then click "Insert"
Click "OK"
Click "OK"

You can also choose whether the Comment (picture) is always displayed, or
only displayed when the mouse hovers over the cell. Go to TOOLS then OPTIONS
then VIEW Tab.

HTH,
Elkar


"smaruzzi" wrote:

I would like to assign a cell a graphical content, such as a small image. It
then would be great if I could treat a graphical content as normal text or
numbers. In other words, copying and moving the content as in a regular cell
reference.

Thanks, Stefano


smaruzzi

How can I "glue" a picture in a cell and treat it as content?
 
Elkar,

thanks a lot. It's not exactly what I needed, but it's a creative solution.

Thanks, Stefano

"Elkar" wrote:

This may not be what you're looking for, but one option would be to insert
your graphic into a Comment. The comment is assigned to a cell, and thus
would move/copy with the cell.

Select your cell
From the Insert Menu, select "Comment"
Right-Click the border (outer dashed line) of the comment
Select "Format Comment"
Select the "Colors and Lines" tab
In the Fill Color box, select "Fill Effects"
Select the "Picture" tab
Click the "Select Picture..." button
Find your picture file, then click "Insert"
Click "OK"
Click "OK"

You can also choose whether the Comment (picture) is always displayed, or
only displayed when the mouse hovers over the cell. Go to TOOLS then OPTIONS
then VIEW Tab.

HTH,
Elkar


"smaruzzi" wrote:

I would like to assign a cell a graphical content, such as a small image. It
then would be great if I could treat a graphical content as normal text or
numbers. In other words, copying and moving the content as in a regular cell
reference.

Thanks, Stefano


Jonas

How can I "glue" a picture in a cell and treat it as content?
 
I have the same need and the Comments solutions is not sufficient because i
want to be able to show several images at the same time.
Other suggestions?

"smaruzzi" skrev:

Elkar,

thanks a lot. It's not exactly what I needed, but it's a creative solution.

Thanks, Stefano

"Elkar" wrote:

This may not be what you're looking for, but one option would be to insert
your graphic into a Comment. The comment is assigned to a cell, and thus
would move/copy with the cell.

Select your cell
From the Insert Menu, select "Comment"
Right-Click the border (outer dashed line) of the comment
Select "Format Comment"
Select the "Colors and Lines" tab
In the Fill Color box, select "Fill Effects"
Select the "Picture" tab
Click the "Select Picture..." button
Find your picture file, then click "Insert"
Click "OK"
Click "OK"

You can also choose whether the Comment (picture) is always displayed, or
only displayed when the mouse hovers over the cell. Go to TOOLS then OPTIONS
then VIEW Tab.

HTH,
Elkar


"smaruzzi" wrote:

I would like to assign a cell a graphical content, such as a small image. It
then would be great if I could treat a graphical content as normal text or
numbers. In other words, copying and moving the content as in a regular cell
reference.

Thanks, Stefano



All times are GMT +1. The time now is 06:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com