View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default Format cells. For Excel nerds? :-)

If it's not on your toolbar........then right click on a toolbar and choose
CUSTOMIZE, then select the COMMANDS tab, and TOOLS category.......then scroll
down till you find the CAMERA icon and drag it to a toolbar.........

Vaya con Dios,
Chuck, CABGx3


"Martin" wrote:

Dear Chuck.

Thank you for your reply.

I understand mostly everything except the camera part. Where in the menu bar
can I find this ICON?

- Martin

"CLR" skrev:

The only way I know to do this is to set up your data as it would normally
appear, ie in range A1:E7.........then select a similar sized area off to the
right, say AA1:AE7 and put your flag images in the respective cells in that
range,......then go back to the regular range and highlight it and using the
CAMERA icon, take a picture of it and paste that picture over the Imaged
range..........this is dynamic, so when you change the data in the original
range, the Imaged range data will follow.....

hth
Vaya con Dios,
Chuck, CABGx3



"Martin" wrote:

I am trying to place a picture (a country flag) behind some cells to indicate
which country is reporting the numbers. When choosing "Format picture" I am
setting the color to "washout". Then I am chossing "send picture to back" in
order to make the numbers in the cell visible, but this does not work. I am
using Excel 2003. Thank you for helping.