Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Using images in Excel

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Using images in Excel

Resolved · Medium Priority · Version 2007

Reply Fri 4 Mar 2011, 10:31Delegate colin said...

colin has attended:
No courses

Using images in Excel

I am trying to use thumbnail images in Excel and am encountering some problems. When I filter columns the images do not move with the other row contents. Is there a way to 'lock' images within a cell so that they are also included in any filtering or sorting?

For upcoming training course dates see: Pricing & availability

Reply Wed 9 Mar 2011, 11:40Trainer Anthony said...

RE: Using images in Excel

Hi Colin, thanks for your query. Small thumbnail images shouldn't be too much of a problem. Right click on the image and choose Size and Position, then click the Properties category. The options for control the moving and resizing of images dependent on the cells are located there.

Hope this helps,

Anthony

Wed 16 Mar 2011: Automatically marked as resolved.

Excel articles

· Preparing to Pivot: Why all Excel users should know about Pivot Tables
· How To Use Excel To Track Your Weight Loss
· Chart Creation Simplified - in 4 Simple Steps
· Finding Your Way Around Excel 2007
· A Quick Guide To Conditional Formatting In Excel 2007/2010

Please browse our web site to find out more about
excel classes and other Microsoft training courses.

Excel tip:

Adding Rows or Columns in an Excel 2010 Worksheet

If you want to add a row to an Excel spreadsheet, these are the simple steps you should take:

With your mouse, right click on the row header below where you want the new row to be added. Then, click Insert.

Follow exactly the same steps if you want to add a column to an Excel worksheet, right click on the column header, choose Insert and the new column will be inserted to the left of the selected column.

View all Excel hints and tips