Results 1 to 8 of 8
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    Virginia Beach, Virginia, USA
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Windows to Other Sheets

    I have come across and interesting trick in Excel and I have no idea how they did it. There is an object on sheet 1 (which Excel ids as a picture) which shows a range of cells from sheet 2. The thing is that the picture is live. You change the data on sheet 2 and it changes on sheet 1. This is a great way to put header info on a sheet without worrying about messing up column widths. Anyone know how this was done?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Windows to Other Sheets

    Actually if you hold down the shift key before you copy the selection, you get some options which might be useful. If you have gridlines shown, you can exclude them being included in the image by selecting As shown when Printed. If you select the default then the gridlines are included and printed if the picture is eventually printed. You also get the option to copy as a bitmap, which means that the image no longer updates based on the underlying cells.

    There is a camera tool available by going to Tools, Customize and selecting Tools from the command tab. Drag the camera to a toolbar, and it can be used by selecting your cells and then clicking the camera. Then move the cursor to the point you want the image pasted and click.

    Andrew C

  3. #3
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Windows to Other Sheets

    Andrew,

    I can't find the camera (Excel 97 SR2 or XL2K)

    My Tools, Customize dialog box has 3 tabs- Toolbars, COmmands, Options.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Windows to Other Sheets

    Geoff,

    Sorry about the lack of clarity. Go Customize, select the Commands Tab, and in the categories section scroll down until you find Tools, then on the right hand side (commands) scroll down until you find a little camera, its down towards the bottom of the list. It's been there since Excel 5 if not earlier.

    Whether using the camera button or the Shift Menu method (more options) it can be very useful, especially for combing different parts of a Workbook onto a single sheet for printing out, or even on the screen where formatting might now allow certain ranges to fit adjacently. These pictures update from the underlying cells unless you copy as a bitmap.

    Good luck,

    Andrew

  5. #5
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Windows to Other Sheets

    ANdrew,

    Got it. Thanks. A very useful tool.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Windows to Other Sheets

    Just another use or two for this feature. If have you text on the clipboard , and select ShiftEdit, Paste Picture, The text is pasted into a text box in Excel. Can be handy, especially for getting the pearls of wisdom from the lounge onto your worksheet to follow instructions.

    You can also use it to embed (Paste Picture) or link (Paste Picture Link) sections of a word document.

    Andrew

  7. #7
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Windows to Other Sheets

    It's called a picture link.

    Copy the cells as normal. Instead of pastingthe cells, hold down the shift key and click on edit in the menu. This will bring up a "hidden" menu item called Paste Picture Link.

    Tony

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Windows to Other Sheets

    Another tip/trick with this is that you can set the range to be a NAMED range rather than just a range.

    Having a named range allows using variable range names using something OFFSET or INDIRECT to change the actual range of the picture with formulas.

    I like to use it to display a "Data Table" of points on an XY Scatter that changes with the data.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •