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.

Editing Excel (Office 2007)

Discussion in 'Other PC Software' started by tanya, 2009/08/12.

  1. 2009/08/12
    tanya

    tanya Inactive Thread Starter

    Joined:
    2002/07/28
    Messages:
    264
    Likes Received:
    0
    Hi,
    Windows XP, Office (excel) 2007.
    How do I edit an office 2007 spreadsheet so it has only 2 rows (I.e. A and B)?
    I don't know how many columns I will need but would also like to limit them.
    Thanks
     
    tanya,
    #1
  2. 2009/08/12
    PeteC

    PeteC SuperGeek Staff

    Joined:
    2002/05/10
    Messages:
    28,896
    Likes Received:
    389
    I doubt you can do that - the no. of available rows and columns are probably hard coded into the program.

    However this is an approach I use in 2003 ....

    Set up the spread sheet with the no. of rows/columns required

    Add a border to the spreadsheet area to be used together with column borders and cell borders if required.

    Then Tools > Options > View and under Windows Options uncheck gridlines

    Result see attached.
     

    Attached Files:

    PeteC,
    #2


  3. to hide this advert.

  4. 2009/08/12
    tanya

    tanya Inactive Thread Starter

    Joined:
    2002/07/28
    Messages:
    264
    Likes Received:
    0
    [...]
    [...]

    Hello and thanks for replying.
    I don't know how to set up the spreadsheet to have 3 rows and 9 columns to begin with (as you have in the Excel.jpg).
     
    tanya,
    #3
  5. 2009/08/12
    PeteC

    PeteC SuperGeek Staff

    Joined:
    2002/05/10
    Messages:
    28,896
    Likes Received:
    389
    Click on the cell which will be the top left cell in your mini spreadsheet and holding down the left mouse button drag to highlight/select the required cells. Then proceed as I posted

    If the position of the mini spreadsheet is not in the right place in the window horizontally adjust by deleting or changing the width of the blank columns to the left and for the vertical position by adding or deleting rows above. Best to do this before hiding the gridlines.
     
    PeteC,
    #4
  6. 2009/08/12
    tanya

    tanya Inactive Thread Starter

    Joined:
    2002/07/28
    Messages:
    264
    Likes Received:
    0
    [...]

    Thanks -- Still working on it...
     
    tanya,
    #5

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