+ Reply to Thread
Results 1 to 2 of 2

Viewing Sections of Large Spreadsheet

  1. #1
    Registered User
    Join Date
    Sarasota FL
    MS-Off Ver
    Excel 2007

    Viewing Sections of Large Spreadsheet

    Spreadsheet organizes information on our clients. First three columns A,B & C contain name, account number and account type. There are 300 rows of client names in column A but we will need to add and delete these rows as clients come and go.

    Additional information about these clients continues in subsequent columns to the right. We need to group these information columns into "sections" that display columns of related data....let's say columns of information about their "home", "business", "children", etc. Sections will have different numbers of columns.

    Since this spreadsheet will have many columns to the right of A,B & C is there a way to specify and view a "section" so that only columns A, B & C and the columns of that specific section are displayed, e.g., I want to only look at information about "home" which might be many columns to the right?

    Thanks in advance.


  2. #2
    Valued Forum Contributor tlafferty's Avatar
    Join Date
    United States, Tacoma, WA
    MS-Off Ver
    Excel 2010, Excel 2013 Customer Preview

    Re: Viewing Sections of Large Spreadsheet

    Sure - use a custom view:
    Hide the columns you don't want to show, then click the View tab, and in the Workbook Views group, click Custom Views. Give you view a name. Unhide everything, then give the unhidden version the name NormalDefault.
    If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
    Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...

    Thomas Lafferty

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


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