+ Reply to Thread
Results 1 to 13 of 13

check List Cell

  1. #1
    Registered User
    Join Date
    06-25-2009
    Location
    Canary Islands
    MS-Off Ver
    Excel 2002
    Posts
    22

    check List Cell

    check List Cell

    I woul like a cell with the symbol of check for create a checking list in excel.

    how can i do and format a cell ?

    I would like to get a template with this options and add my list. I only need to select o deselect the items.

    Thanksxxx

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: check List Cell

    to just put a check mark format cell windings2 then use an uppercase P
    or use a checkbox from the forms tool bar
    Last edited by martindwilson; 08-12-2009 at 05:08 PM.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    03-17-2008
    Posts
    2

    Re: check List Cell

    Hope this may help you.

    checklist.xlsx
    ________________________________________
    visit xlfabz.com - sharing your MS Excel knowledge

  4. #4
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: check List Cell

    thats an xlsx, Esgrimidor may not be able to open that!

  5. #5
    Registered User
    Join Date
    03-17-2008
    Posts
    2

    Re: check List Cell

    Sorry for that. Attached a 97-2003 version.

    checklist.xls

  6. #6
    Registered User
    Join Date
    06-25-2009
    Location
    Canary Islands
    MS-Off Ver
    Excel 2002
    Posts
    22

    Re: check List Cell

    I'm trying now and comments.

    Thank a lot

    \1

  7. #7
    Registered User
    Join Date
    06-25-2009
    Location
    Canary Islands
    MS-Off Ver
    Excel 2002
    Posts
    22

    Re: check List Cell

    Perhaps with checkboxes it's not possible. For me is indifferent. What I need is know with any mark. A number . True. False, anyway.
    But faster and with only one hand.
    By example, a number and the enter key.
    If a number whe line is made, is the enter key the line is not made.

    \1

  8. #8
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: check List Cell

    why not just use the format i told you?
    or just put an x in the cell?

  9. #9
    Registered User
    Join Date
    06-25-2009
    Location
    Canary Islands
    MS-Off Ver
    Excel 2002
    Posts
    22

    Re: check List Cell

    Quote Originally Posted by martindwilson View Post
    to just put a check mark format cell windings2 then use an uppercase P
    or use a checkbox from the forms tool bar
    What's windings2

    I saw the way to create checkbox with

    \1

  10. #10
    Registered User
    Join Date
    06-25-2009
    Location
    Canary Islands
    MS-Off Ver
    Excel 2002
    Posts
    22

    Re: check List Cell

    Quote Originally Posted by martindwilson View Post
    why not just use the format i told you?
    or just put an x in the cell?
    For me is enough to put a X in the cell or any character to indicate is done. But I would like to put the character and goes inmediately to the next row. And if I press enter then leaves the cell blank or equal and goes next.

    How can I do that ?

    Thanksss again

  11. #11
    Registered User
    Join Date
    06-25-2009
    Location
    Canary Islands
    MS-Off Ver
    Excel 2002
    Posts
    22

    Re: check List Cell

    Do you know a tutorial with the way to do these steps ?

  12. #12
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: check List Cell

    if you type into a cell it goes to next row on enter any way
    if cell is blank and you hit enter it move to next as well as long as tools/options/edit
    move selection after enter is checked and set to down

  13. #13
    Registered User
    Join Date
    06-25-2009
    Location
    Canary Islands
    MS-Off Ver
    Excel 2002
    Posts
    22

    Re: check List Cell

    I don't know in your system

    In my system if I put "1" in a cell don't go to the next one.
    I need the enter key too. I woul like to put "1" and go to the next cell.

    How can I format those cells ?

    Thanksssss

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1