Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Feb 2002
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Bullet or Numbered List (Excel XP)

    Is there a similar option for inserting bullet or number list in excel like the one in word? I have a 7 page form that i have to had numbers to rows without inserting a column or additional rows. I would appreciate any help, thanks. <img src=/S/bash.gif border=0 alt=bash width=35 height=39>

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Bullet or Numbered List (Excel XP)

    For bullets, see <post#=63079>post 63079</post#>. For numbers, it is easiest to insert a narrow column and use a number format such as "#,##0." If you cannot insert a column, what kind of data do you have on this form?
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bullet or Numbered List (Excel XP)

    If you can't insert a column in your current spreadsheet, can you copy the column which you want formatted to an empty document, insert a column and reformat there, and copy the data back to the original workbook?

    eg, copy the column into column 1 of an empty worksheet. Copy this formula into cell B1:
    =ROW(A1) & " " & A1
    and copy this formula down for every cell which has data in column A. Highlight column B, and copy it. Go back to your original worksheet, then Edit, Paste Special, Values
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  4. #4
    New Lounger
    Join Date
    Feb 2002
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bullet or Numbered List (Excel XP)

    Thanks for the info! I couldnt insert a row due to macros - its an employee evaluation form.

  5. #5
    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

    Re: Bullet or Numbered List (Excel XP)

    Could you write it in word with all the formatting at your fingertips and then copy the text (or sections) if appropriate and then PASTE - Special - Picture into excel?

    You get the formatting as you want it and the added benefit of screwing around with the HR people since the words you put in are NOT text but actually a picture.

    Steve

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bullet or Numbered List (Excel XP)

    <hr>added benefit of screwing around with the HR people <hr>
    <img src=/S/rofl.gif border=0 alt=rofl width=15 height=15>
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  7. #7
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    London, United Kingdom
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bullet or Numbered List (Excel XP)

    Attached is an Example of a formula that I use. I originally found this formula on John Walkenbach's website. It has come in very useful.
    Attached Files Attached Files

Posting Permissions

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