Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Expanding the Excel Workbook

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Ontario
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there a way of expanding the workbook beyond column IV, which I believe is the last column as it seems to be the end column in every workbook I am using.

    I tried running a search on this site but it continues to result in errors so I apologize if this question has been answered previously.

    Any thoughts would be appreciated.

    Thanks
    Sean

    [ This Message was edited by: sean98 on 2002-04-05 09:35 ]

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    60
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sean

    IV is the last column for excel.

    If you need anything bigger then I beleive the only way is to tie to other sheets or workbooks.

    Other than that I think Lotus has more columns if you want to change programs.

    HTH

    Dan.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    If you short of columns remeber you could transpose

    or split over more than one sheet.


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,940
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    The Office Spreadsheet control (which is basically a cut down version of a normal Excel worksheet) has 702 columns. You could use it to store data and then extract into a regular worksheet for more advanced manipulation of the data.

    There's plenty of info on the net - type Microsoft Office Spreadsheet Control into a search engine. If you have any problems please post back.

    Regards,
    Dan

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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