Results 1 to 9 of 9

Thread: file highlights

  1. #1
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts
    hi all,

    it may sound strange request, but is there a way to highlights an xl file within a workbook, something not classic that will make it recognizable and easy to spot, not by name and by putting it in a separate folder.

    dubdub
    TIA
    dubdub

  2. #2
    Star Lounger
    Join Date
    Dec 2009
    Location
    Mexico City, D.F., Mexico
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I would say use UPPER CASE letters in the file name, or create a shortcut that points to this file and put it in a visible place (desktop, special folder).
    This eco-post is made of recycled electrons

  3. #3
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Quote Originally Posted by dubdub View Post
    hi all,

    it may sound strange request, but is there a way to highlights an xl file within a workbook, something not classic that will make it recognizable and easy to spot, not by name and by putting it in a separate folder.

    dubdub
    I am sure it i not a strange request, but I don't understand what you mean.
    Do you mean file names stored in cells, or do you mean formulas that reference file names or?
    Andrew

  4. #4
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts
    hi,

    what i meant is suppose you have a folder with too many xl workbooks and you want to highlights certain ones to make them quickly noticeable, something like the file name will be written on red color instead of the normal black one and/or anything that will make it easy to spot....

    dubdub.
    TIA
    dubdub

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    That is not possible, as far as I know.

  6. #6
    3 Star Lounger
    Join Date
    May 2008
    Location
    India
    Posts
    306
    Thanks
    0
    Thanked 0 Times in 0 Posts
    one easy step (what I follow) to name the file in alpha-numeric, starting with number.

    [attachment=87300:untitled.JPG]
    Attached Images Attached Images
    Regards
    Prasad

  7. #7
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by dubdub View Post
    ... easy to spot, not by name and by putting it in a separate folder.
    You could add a comment to the workbook properties:

    [attachment=87305:y.gif]

    and then show Comments in the File dialogue...

    [attachment=87304:x.gif]

    (If comments are not shown, right-click on the Name/Size/Type field bar and select Comments.)

    You could obviously use any comment to highlight the files you are interested in - and sort on the Comment field to filter them.
    The above is as shown in Excel 2002 on XP. For some reason, a recently-added comment added to a workbook which is saved, does not show up in Explorer until after the workbook is closed.

    By default, I have 'Prompt for workbook properties' selected in my options:

    [attachment=87306:z.gif]
    Attached Images Attached Images

  8. #8
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts
    hi all,

    looks will wait for initiative from the main developer"Microsoft", thanks to all who participated and brought some good ideas.

    dubdub
    TIA
    dubdub

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Quote Originally Posted by dubdub View Post
    looks will wait for initiative from the main developer"Microsoft"
    Don't hold your breath!

Posting Permissions

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