Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with Camera Function
I'm trying to copy a picture of part of a spreadsheet into a Word document.
The Camera function found in Tools\Customise\Commands\Tools almost does the trick but I particularly want to include the Row and Column headings so it's easy to refer to particular cells or ranges. Can Camera be used to show Row and Column headings as well as cells and, if so, how? If not, what is the easiest way of achieving what I want to do? Thanks a lot |
#2
|
|||
|
|||
Hi
Try Snagit for this http://www.techsmith.com/ -- Regards Ron de Bruin http://www.rondebruin.nl "nospaminlich" wrote in message ... I'm trying to copy a picture of part of a spreadsheet into a Word document. The Camera function found in Tools\Customise\Commands\Tools almost does the trick but I particularly want to include the Row and Column headings so it's easy to refer to particular cells or ranges. Can Camera be used to show Row and Column headings as well as cells and, if so, how? If not, what is the easiest way of achieving what I want to do? Thanks a lot |
#3
|
|||
|
|||
If you size the picture to match the underlying cells, enter the
column/row headings in cells surrounding the picture (format them the appropriate font/color if you want). Make sure you set the picture to "Move and size with cells". In article , nospaminlich wrote: I'm trying to copy a picture of part of a spreadsheet into a Word document. The Camera function found in Tools\Customise\Commands\Tools almost does the trick but I particularly want to include the Row and Column headings so it's easy to refer to particular cells or ranges. Can Camera be used to show Row and Column headings as well as cells and, if so, how? If not, what is the easiest way of achieving what I want to do? Thanks a lot |
#4
|
|||
|
|||
Forget about Camera tool.
Use File|PageSetup and on the Sheet tab specify Row and Column headers are to be printer. Return to sheet Select the range to be copied. Hold down Shift and use menu command Edit|Copy Picture (this shown only when Shift is held down); specify As Printed Now you have the picture on clipboard. Move to Word and use Paste or Paste Special best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "nospaminlich" wrote in message ... I'm trying to copy a picture of part of a spreadsheet into a Word document. The Camera function found in Tools\Customise\Commands\Tools almost does the trick but I particularly want to include the Row and Column headings so it's easy to refer to particular cells or ranges. Can Camera be used to show Row and Column headings as well as cells and, if so, how? If not, what is the easiest way of achieving what I want to do? Thanks a lot |
#5
|
|||
|
|||
Thanks Bernard. That worked perfectly. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
EXCEL 2003 "CAMERA" FUNCTION | Excel Worksheet Functions |