1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Number Format

Discussion in 'Other PC Software' started by dastgir, 2009/01/17.

  1. 2009/01/17
    dastgir

    dastgir Inactive Thread Starter

    Joined:
    2005/12/26
    Messages:
    86
    Likes Received:
    0
    Dear Sir,

    My system as follows,
    WinXP PRO
    MS Office 2003

    I wanna know which format i select for number while working in excel
    so that while draging all required number arrange in acsending order as
    when we count, ie number does not get copied, but the order should be
    as is the case with date format.

    For more explaination, for example i want to insert number from 1 to
    100 in cells.Now what i want is, insert 1 in a cell and drag it to 100th cell
    so that no adding of number indivisually.

    Regards,

    Gulam Dastgir
     
    dastgir,
    #1
  2. 2009/01/17
    PeteC

    PeteC SuperGeek Staff

    Joined:
    2002/05/10
    Messages:
    28,896
    Likes Received:
    389
    :confused: Why drag, I'm not sure that you can, when you can use Edit > Fill > Series?

    Enter 1 in the first cell - highlight cells 1 - 100 - Edit > Fill > Series and select Step Value 1
     
    PeteC,
    #2


  3. to hide this advert.

  4. 2009/01/18
    dastgir

    dastgir Inactive Thread Starter

    Joined:
    2005/12/26
    Messages:
    86
    Likes Received:
    0
    Dear PeteC,

    thanks for your support. I was ignorant of that option.

    Regards
    Gulam Dastgir.

    Now this thread is closed.
     
    dastgir,
    #3
  5. 2009/01/18
    PeteC

    PeteC SuperGeek Staff

    Joined:
    2002/05/10
    Messages:
    28,896
    Likes Received:
    389
    Glad to be of assistance :)
     
    PeteC,
    #4
  6. 2009/01/22
    dastgir

    dastgir Inactive Thread Starter

    Joined:
    2005/12/26
    Messages:
    86
    Likes Received:
    0
    Dear PeteC,

    How to make a cell uneditable. The contents should also be not visible in the
    formula bar ie no one can edit the formula, i am defining in it, also no one can
    see it.

    Kind Regards,

    Gulam Dastgir
     
    dastgir,
    #5
  7. 2009/01/22
    PeteC

    PeteC SuperGeek Staff

    Joined:
    2002/05/10
    Messages:
    28,896
    Likes Received:
    389
    This should work for you ....

    To hide the formula in a cell .....

    Select the cells you want to hide, then right click and select Format Cells. Choose the Protection Tab and check the box for Hidden.

    You must also Protect the Worksheet - use a password otherwise the protection can be removed by anybody .....

    Tools > Protection > Protect sheet or Workbook
     
    PeteC,
    #6
  8. 2009/01/23
    dastgir

    dastgir Inactive Thread Starter

    Joined:
    2005/12/26
    Messages:
    86
    Likes Received:
    0
    Dear PeteC,
    I do not want to make the whole sheet uneditable,only those cells where i
    have defined the formula so that no can edit the formula, but can enter the
    figures in the cells to whom the formula is defined.

    Kind Regards,

    Gulam Dastgir
     
    dastgir,
    #7
  9. 2009/01/23
    PeteC

    PeteC SuperGeek Staff

    Joined:
    2002/05/10
    Messages:
    28,896
    Likes Received:
    389
    PeteC,
    #8

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...