+ Reply to Thread
Results 1 to 3 of 3

Expand or delete list frame

Hybrid View

  1. #1
    Registered User
    Join Date
    11-11-2009
    Location
    Midwest, USA
    MS-Off Ver
    Excel 2004 for Mac
    Posts
    1

    Expand or delete list frame

    I have a spreadsheet that somehow has what I think is a list frame in it. It only has 6 out of 8 columns contained in it, and I want to sort ALL my rows by date, but since two of the columns are excluded from the list frame, it doesn't sort them, and all my data no longer matches up correctly. I cannot seem to find a way either to delete this pesky frame, nor to get it to expand to include the currently excluded rows. I know there has to be a simple way to do this, but Help isn't being very helpful...if anybody knows how to remedy this, I would be most appreciative of tips.
    Thanks.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Expand or delete list frame

    Hi,

    Are you using Excel for Mac or Excel for Windows?

    Rgds
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Expand or delete list frame

    Put your cursor IN the framed list and go to DATA > LIST > RESIZE LIST and it should let you reset the boundaries to include all columns.

    If the LIST commands are in a different place in Excel for Mac, press the HELP key and read up on the LIST feature to find it.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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