+ Reply to Thread
Results 1 to 4 of 4

Table isn't auto expanding. Irregular border appearance

  1. #1
    Registered User
    Join Date
    01-26-2023
    Location
    Australia
    MS-Off Ver
    Mac. 2016
    Posts
    2

    Question Table isn't auto expanding. Irregular border appearance

    Hi there,
    I've created an excel worksheet with the intention of adding data to a table every day.
    The issue I'm having is the table won't auto expand. I'm fairly certain I have the correct settings on.
    Additionally, the border between the bottom two rows appears as two parallel lines. I haven't noticed tables in other excel users' worksheets appearing this way. I'm wondering what these lines might mean?

    Any help would be much appreciated.
    Attached Files Attached Files
    Last edited by treesilver; 01-26-2023 at 09:35 PM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: Table isn't auto expanding. Irregular border appearance

    Try:

    1. Turn the data filt er off.

    2. Delete the final row.

    3. Turn data filter back on again.

    4. Fixed?
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    01-26-2023
    Location
    Australia
    MS-Off Ver
    Mac. 2016
    Posts
    2

    Re: Table isn't auto expanding. Irregular border appearance

    Thanks for finding the solution Glenn!
    Just out of curiosity, is it possible to know what might have caused the change in the first place?

    Thanks again.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: Table isn't auto expanding. Irregular border appearance

    Absolutely no idea!!

    You're welcome.



    It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

    Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Auto Expanding Table From Another Table
    By BillySpivy in forum Excel General
    Replies: 2
    Last Post: 10-06-2021, 05:01 PM
  2. Filtering out Zero values stops auto-expanding table
    By Rogerio2020 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-09-2020, 08:11 PM
  3. Combining auto-locking VBA code and auto-expanding a table
    By DixieLou in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-14-2019, 03:28 AM
  4. Auto Generate Additional Template from Expanding Table
    By schs4 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-26-2016, 01:24 PM
  5. [SOLVED] Table not auto-expanding
    By teenyjem in forum Excel General
    Replies: 3
    Last Post: 01-21-2014, 05:33 AM
  6. auto expanding table move calculates totals down
    By GHServices in forum Excel General
    Replies: 0
    Last Post: 10-10-2011, 01:12 PM
  7. Change highlighted cursor BOX border color (appearance) in Excel
    By J-girl in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-24-2006, 12:55 PM

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