Jump to content

? servers

? players online

Excel Spreadsheet Help

Recommended Posts


  • Content Count:  769
  • Joined:  04/23/10
  • Status:  Offline

Okay so I have to make an Excel Spreadsheet for my AS level coursework and we have to do a shop so I chose a local music shop, I can build the spreadsheet fine I was just wondering if anyone knew whether or not what I'm about to try and explain is possible in Excel.

 

Currently on my spreadsheet an instruments details are displayed next to it like so;

 

Help.png

 

However I was wondering whether or not it would be possible to make it so that when you hover over the image a text box is displayed showing that information automatically, it would save me space and add in functionality.

 

If anyone has any idea how this can be done, or whether or not it can be done reply please.

 

P.S. It doesn't have to be exactly as I described just the same kind of thing, I'd prefer if it didn't link to another sheet in the file with the details there.

Link to comment

  • Content Count:  769
  • Joined:  04/23/10
  • Status:  Offline

Why don't you ask your teacher how to do it?

 

Trying to finish the spreadsheet over the weekend, having the text there takes away alot of space that I need to use (To make it look good anyway), I will probably ask the teacher in my next lesson but I was just wondering if anyone was familiar with spreadsheet's and could help out.

Link to comment

  • Content Count:  769
  • Joined:  04/23/10
  • Status:  Offline

I assume you've tried youtube and google? (not trying to be a dick) :)

 

Yes, I did try google and youtube quickly but after the first few links I gave up, could find kind of what I wanted but not exactly.

 

Excel Comments -- Basics

Use the cells behind the pictures to display a comment maybe? Maybe this somehow works with pictures too, anyway, use comments.

..or learn visual basic

 

Thanks, from the link I was able to work out how to do it in Excel 2007, was pretty simply really but was one of those things you wouldn't really know how to do unless you've done it.

Link to comment

Reply to Thread

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...