Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Toronto, CANADA.
    Posts
    292
    Thanks
    21
    Thanked 3 Times in 3 Posts

    comments in printout (Office 2003)

    hello everyone;

    how can i make the comments i show in spreadsheet come out in the printout?

    TIA for your help

    danielR

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    In 2010, after you have the various comments set, you can go to the REVIEW tab and in the Comments group, click Show All Comments.
    They'll now appear in the sheet.

    From the Page Layout tab, the Page Setup group, open the dialog box (bottom right corner). From the Sheet tab in that dialog box, in the Comments section, click As displayed on sheet or At end of sheet. Then print.

    I no longer run 2003 and can't remember if that feature existed then or not but believe it did, probably from File, Page Setup, Sheet.
    Last edited by kweaver; 2014-01-07 at 14:46.

  3. #3
    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
    In XL2003 it is also possible.

    If I recall correctly (or something similar to this)
    File - Page Setup - Sheet(tab)
    Change dropdown for the Comments drop-down to "end of sheet" or "as displayed"

    Steve

  4. #4
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Toronto, CANADA.
    Posts
    292
    Thanks
    21
    Thanked 3 Times in 3 Posts
    thank for your replies.
    i have XL2003 ,and have tried but in the Page Setup > Sheet(tab) the comments little window is disabled, cannot open or drop-down.
    tried to see if it is a printer setup (have a Brother HW2207), but no luck there either.
    Tools > Options doesn't help either.
    seems i'll have to live with it.

    danielR

  5. #5
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Daniel,

    Is the worksheet and/or workbook protected? This may be why the option is greyed out, just a thought. HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  6. #6
    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
    In addition to RG's comments, make sure you call page setup from within the worksheet, not in print preview

    Steve

  7. #7
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Toronto, CANADA.
    Posts
    292
    Thanks
    21
    Thanked 3 Times in 3 Posts
    nope, workbook is not protected.
    furthermore, i created a new workbook with a comment.
    same result.

    pity.

    thanks again to U all.

    d.

  8. #8
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Daniel,

    I just tried it on my Win 7 HP SP-1 laptop with Office2003 SP-3 and it worked just fine.
    You may want to make sure you have SP-3 (Help Tab) and upgrade if you don't or you
    may want to try a Repair of office. HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  9. #9
    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
    Are you in "Normal" view? I don't recall (and can't check as I no longer have a computer with <XL2007) but it would not surprise me if calling PageSetup from the "Page Break Preview" or the "Page Layout" views had the same "disabled" items as when calling PageSetup from the Print Menu...

    Steve

  10. #10
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Steve,

    FYI: It still works in Page Break Preview mode.
    I couldn't find a Page Layout option.
    However, in Print Preview mode the option does come up greyed out! HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  11. #11
    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
    Thanks for checking. Perhaps "Page Layout" is a new view starting with XL2007, I don't recall, it has been a number of years since I last used XL2000 and the old gray cells aren't what they once were...[I have speculated that the gray in my hair comes from gray cells that are being lost, which explains my changing hair color as well...]

    Steve

  12. #12
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Steve,

    Lucky you...you still have hair.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  13. #13
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Toronto, CANADA.
    Posts
    292
    Thanks
    21
    Thanked 3 Times in 3 Posts
    Hi RG;

    thanks for your assistance.
    i checked my version of XL, and it seems it doesn't have any SPK.
    so, went to MS site and downloaded SPK3 for office 2003.

    Office2003SP3-KB923618-FullFile-ENU ; it is an executable file with exe extension.

    tried to run, but stops giving me the message
    Extracting file failed. It is most likely caused by low memory (low disk space for swapping file) or corrupted Cabinet file.

    my machine has a partition, C:\ is 33.7 Gb, of which 11.5 Gb are free.
    i have 4 Gb ram.
    puzzling (?)

    went back to MS site, and found that it's an update applicable to XP.

    searched again, but ALL what gives are XP versions, which is what i conclude from looking at system requirements in

    http://www.microsoft.com/en-ca/downl...ails.aspx?id=8

    i'm running W7 HP version 6.1 (Build 7601: Service Pack1).

    any help?

    TIA

    danielr2

  14. #14
    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
    you still have hair
    Yes but it is getting thinner and more wiry. And as the gray cells have moved to displace the hair color, some of the hair is displace to new locations (ear lobes, back, tip of the nose, etc...)

    Steve

  15. #15
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Toronto, CANADA.
    Posts
    292
    Thanks
    21
    Thanked 3 Times in 3 Posts
    sorry, sorry, sorry.

    i apologize.

    i skipped skipped Steve's reply on 2014-01-07 21:13

    In addition to RG's comments, make sure you call page setup from within the worksheet, not in print preview

    i set the page up from within the worksheet (all my previous indications were when trying to setup in print preview), and problem solved.

    i apologize again.

    thank you ALL gentlemen for your help.

    daniel rozenberg.

Page 1 of 2 12 LastLast

Posting Permissions

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