+ Reply to Thread
Results 1 to 2 of 2

Does Excel have Section breaks like Word

  1. #1
    Registered User
    Join Date
    01-12-2010
    Location
    Hollywood, MD
    MS-Off Ver
    Excel 2003
    Posts
    1

    Does Excel have Section breaks like Word

    Hi All: I am trying to develop a work book that combines several different data types/ Functions. on the first set of rows I want to set up and format it for collection information like names, addresses, phone numbers, email, etc. These data items varies in width size.

    on the 2nd part of the form, I wnat to collect inventory data. Data that is very consistant in format ie dat length.

    In the past, I have used cells merge to make thing look good to account for different cell sizes in the same column but different rows. However, this creates problems when I later merge data to another spreadsheet that has differnet formats.

    I was thinking if Excel has Section breaks like word, then formating of sections would be independent of each other and my problem would be solved.Any help would be greatly appreciated!

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Soes excel have Section breaks like word

    First: on worksheets that will contain raw data (as opposed to a report or "form") avoid the use of merged cell altogether.

    Second: a data worksheet should only contain related raw data. Never mix the data types. In your case contact info and inventory data should have their own sheet.

    Set up each worksheet in the classic database structure;
    First data row = header row (identified "fields" of info
    All rows below header = records
    No blanks rows or columns, a blank cell is OK - just don't use blank rows or columns to separate data

    With the right structure you can extract information, create reports, do analysis, etc. quite easily.

    The Excel "section breaks" are called " worksheets.
    Use them to your advantage.
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

+ 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