!!

Not Yet Registered?

Welcome to the N Gauge Forum!  We've currently hidden most of the threads due to the vast number of guests contributing in slowing the speed of the forum down.  Please register and login to see the many thousands of posts about our great hobby.  After registering and gaining 10 posts you will be able to sell and buy items on our N'porium.

If you have any problems registering, then please check your spam filter before emailing us.  


Thanks for reading,
The NGF Staff.

Author Topic: Excel 2003 Stock spreadsheet - adding pictures to data?  (Read 985 times)

0 Members and 1 Guest are viewing this topic.

Offline Avis1434

  • Trade Count: (+1)
  • Full Member
  • ***
  • N Gauge Society Number: 20007
  • Posts: 122
  • Country: scotland
  • Gender: Male
    • Awards
Excel 2003 Stock spreadsheet - adding pictures to data?
« on: November 10, 2014, 04:34:31 PM »
I have compiled a spreadsheet, using Excel 2003, of all my stock.

I would like to attach a photograph from my PC files of the stock item to the relative main description cell in order that when you click on it, it will show the photograph, in a reasonable size. :dunce:

Can I do this? If so how? In simple language please! :help:

Cheers

Murray

Offline austinbob

  • Trade Count: (+3)
  • Full Member
  • ***
  • N Gauge Society Number: 23835
  • Posts: 4438
  • Country: gb
  • Gender: Male
    • Awards
Re: Excel 2003 Stock spreadsheet - adding pictures to data?
« Reply #1 on: November 10, 2014, 04:48:57 PM »
Hi Murray

In my version of Excel (Excel 2010) you right click on the cell you want to put the picture in and then click on 'insert hyperlink'. It then takes you through a series of windows to locate the picture or file you want to link to and you select the one you want.

Once inserted you just click on the cell with the hyperlink to view the picture.

I'm sure Excel 2003 must be similar.
Size matters - especially if you don't have a lot of space - and N gauge is the answer!

Bob Austin

Offline Newportnobby

  • Global Moderator
  • Trade Count: (+105)
  • Full Member
  • *****
  • N Gauge Society Number: 21962
  • Posts: 38291
  • Country: england
  • Gender: Male
    • Awards
Re: Excel 2003 Stock spreadsheet - adding pictures to data?
« Reply #2 on: November 10, 2014, 05:07:36 PM »
Someone on the forum said it was possible to add a comment to a cell (which it is) and then add a pic to the comment.
Haven't tried it yet, though.

Offline MikeDunn

  • Trade Count: (0)
  • Full Member
  • ***
  • N Gauge Society Number: 21391
  • Posts: 3098
    • Awards
Re: Excel 2003 Stock spreadsheet - adding pictures to data?
« Reply #3 on: November 10, 2014, 05:38:21 PM »
I would like to attach a photograph from my PC files of the stock item to the relative main description cell in order that when you click on it, it will show the photograph, in a reasonable size. :dunce:

Can I do this? If so how? In simple language please! :help:

Select a cell
On the Insert menu item, select Pictures (may be under Illustrations)
Browse to the image & select it; then Insert
If too large, grab the handle at the bottom-right corner & resize towards top left

Simples.

Someone on the forum said it was possible to add a comment to a cell (which it is) and then add a pic to the comment.
Haven't tried it yet, though.

Select the cell.
Choose the Review menu item
select the New Comment option

Also simples.
« Last Edit: November 10, 2014, 05:40:40 PM by MikeDunn, Reason: Adding comment part »

Online msr

  • Trade Count: (+18)
  • Full Member
  • ***
  • Posts: 383
    • Awards
Re: Excel 2003 Stock spreadsheet - adding pictures to data?
« Reply #4 on: November 10, 2014, 05:42:57 PM »
But beware that the size of the spreadsheet will increase in direct proportion to the size of the images you add. If you have a lot of stock, or use images with a high resolution, you are likely to get a spreadsheet which is many Mb in size and this will become slow to load and eventually may exceed the capacity of your RAM and hang.

Consider keeping the resolution of each image down, say below 300 kb each.

Mike

Offline Avis1434

  • Trade Count: (+1)
  • Full Member
  • ***
  • N Gauge Society Number: 20007
  • Posts: 122
  • Country: scotland
  • Gender: Male
    • Awards
Re: Excel 2003 Stock spreadsheet - adding pictures to data?
« Reply #5 on: November 10, 2014, 05:48:27 PM »
Thanks guys for all your speedy assistance - austinbob and others and thanks for the warning from msr :claphappy:

Already have some of the photo's inserted! What a great forum this is - got an answer in 14 minutes - and about a topic nothing really to do with N gauge!! Well done guys :beers: :thankyousign:
« Last Edit: November 10, 2014, 05:49:43 PM by Avis1434, Reason: Addition »

Offline austinbob

  • Trade Count: (+3)
  • Full Member
  • ***
  • N Gauge Society Number: 23835
  • Posts: 4438
  • Country: gb
  • Gender: Male
    • Awards
Re: Excel 2003 Stock spreadsheet - adding pictures to data?
« Reply #6 on: November 10, 2014, 05:49:58 PM »
But beware that the size of the spreadsheet will increase in direct proportion to the size of the images you add. If you have a lot of stock, or use images with a high resolution, you are likely to get a spreadsheet which is many Mb in size and this will become slow to load and eventually may exceed the capacity of your RAM and hang.

Consider keeping the resolution of each image down, say below 300 kb each.

Mike

That's why I think its best to add a hyperlink to the spreadsheet rather than embed the picture. Keeps the spreadsheet neat, tidy and small. Especially good way of using pictures if you already have the pictures on you computer.
Size matters - especially if you don't have a lot of space - and N gauge is the answer!

Bob Austin

Offline Trainfish

  • Larger Gallery
  • Trade Count: (+11)
  • Full Member
  • ***
  • N Gauge Society Number: 21524
  • Posts: 4051
  • Country: england
  • Gender: Male
  • IPAholic
    • Ebay
    • YouTube
    • My layout, Longcroft under construction
    • Awards
Re: Excel 2003 Stock spreadsheet - adding pictures to data?
« Reply #7 on: November 15, 2014, 05:26:38 PM »
I agree with the hyperlinking. I've always had a spreadsheet of my stock and this week have been adding pictures via hyperlinks. I have over 500 pictures to add and doing this way I can keep them at a decent resolution and yet the spreadsheet stays relatively small. I do have some pictures on one tab but it's still only 3.7mb. With 8gb of RAM I think I'll be ok for a while yet  :D
John

To see my layout "Longcroft" which is currently under construction, you'll have to catch the fish below first by clicking on it!

<*))))><

See my Youtube video channel          >>>>>>>> here <<<<<<<<          >>>>>>>> or here <<<<<<<<          >>>>>>>> or here <<<<<<<<

Offline MikeDunn

  • Trade Count: (0)
  • Full Member
  • ***
  • N Gauge Society Number: 21391
  • Posts: 3098
    • Awards
Re: Excel 2003 Stock spreadsheet - adding pictures to data?
« Reply #8 on: November 15, 2014, 09:22:17 PM »
It depends what you want ... if a small photo (say a couple hundred pixels) is big enough - then why all the drama about "it will be a massive file" ?  Such an image would be in the tens (not hundreds or thousands) of KB - and that's a lot of photos per megabyte ... and there's nothing to stop you setting the small image as a hyperlink to the high-res one, is there ? 

Although why you'd want to open a stock spreadsheet & click such an image escapes me, when you could just open the image ...  Remember, this is just so you can see what it looks like, in the stock sheet !

Offline Trainfish

  • Larger Gallery
  • Trade Count: (+11)
  • Full Member
  • ***
  • N Gauge Society Number: 21524
  • Posts: 4051
  • Country: england
  • Gender: Male
  • IPAholic
    • Ebay
    • YouTube
    • My layout, Longcroft under construction
    • Awards
Re: Excel 2003 Stock spreadsheet - adding pictures to data?
« Reply #9 on: November 16, 2014, 03:04:18 AM »
I agree with you Mike. My spreadsheet is for insurance reasons and also so I can keep track of what I already have. If I see something on offer somewhere it's quick and easy to see if I already have it, I can't remember all of my stock. The pictures are again for insurance where I think a decent resolution picture should mean a bit more to an assessor. Finally, my pictures haven't been renamed, they're just "img0012" etc so it's quicker and easier to find the correct picture when you have over 500 to choose from.
As you say though, each to their own as we probably all have different reasons to keep the list either with or without pictures.
John

To see my layout "Longcroft" which is currently under construction, you'll have to catch the fish below first by clicking on it!

<*))))><

See my Youtube video channel          >>>>>>>> here <<<<<<<<          >>>>>>>> or here <<<<<<<<          >>>>>>>> or here <<<<<<<<

 

Please Support Us!
September Goal: £60.00
Due Date: Sep 30
Total Receipts: £80.00
Above Goal: £20.00
Site Currency: GBP
133% 
September Donations

anything
SimplePortal 2.3.5 © 2008-2012, SimplePortal