Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Apr 2007
    Location
    Lancashire, United Kingdom
    Posts
    264
    Thanks
    32
    Thanked 5 Times in 5 Posts

    Printing off names?

    I have created a load of names in excel (Formula-> Name Manager to show them all). Is there any way I can print them off?

    The only way I can find is <Alt-Prtsc> to copy the window and then paste into Paint - but that's not really what I want (I want a list I can do things with).

    thanks for any information

    Alan

  2. #2
    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
    Alan,


    1. Insert a new sheet.
    2. Click on A1 in the new sheet.
    3. Press F3
    4. Click on the Paste List button.
    5. Print the Sheet.


    PasteList.JPG
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,827
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Or use VBA; assign following to a button on a new blank sheet:

    Sub listAllNames()
    [a1].ListNames
    [A:B].EntireColumn.AutoFit
    [a1].Select
    End Sub

    zeddy

  4. #4
    3 Star Lounger
    Join Date
    Apr 2007
    Location
    Lancashire, United Kingdom
    Posts
    264
    Thanks
    32
    Thanked 5 Times in 5 Posts
    Quote Originally Posted by RetiredGeek View Post
    Alan,
    1. Insert a new sheet.
    2. Click on A1 in the new sheet.
    3. Press F3
    4. Click on the Paste List button.
    5. Print the Sheet.

    PasteList.JPG
    That works well but shows me the forumula rather than the result in Column B. If I copy the formula and paste it in column C, I get the result. So, what is different about column B? There must be a setting somewhere that says "show me the formula" but I have no idea what it is. The picture below illustrates it (I hope).

    t1.jpg

  5. #5
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,827
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi

    After pasting the list of names you can use the formula
    =Indirect(name)
    ..to see results.

    This will work for names that refer to single cells rather than multi-cell ranges.

    zeddy

  6. #6
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,827
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi

    Just to be clear, if your names are pasted into column [A] with the name definitions in column [B], then in column [C] use formulas like
    =Indirect(A2)
    =Indirect(A3)
    etc

    zeddy

  7. #7
    3 Star Lounger
    Join Date
    Apr 2007
    Location
    Lancashire, United Kingdom
    Posts
    264
    Thanks
    32
    Thanked 5 Times in 5 Posts
    Thanks, that worked. So did pressing <F2> then <Enter> for each affected line. I think there's a slight bug when the name definition is pasted in.

    regards

    Alan

  8. #8
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,827
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi Alan

    It is not a bug. The 'paste list' feature gives you the name and alongside, what the name refers to, not the result.
    In files where you use lots and lots of names across many sheets etc you can sort the paste-list block to group all names that refer to specific sheets etc which can be useful.
    But as you pointed out, by simply 'F2-editing' the 'refers to' entry you can get the values.

    zeddy

  9. #9
    3 Star Lounger
    Join Date
    Apr 2007
    Location
    Lancashire, United Kingdom
    Posts
    264
    Thanks
    32
    Thanked 5 Times in 5 Posts
    Ah, it's a "feature"

    Thanks for the information. Useful to know.

    regards

    Alan

Posting Permissions

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