+ Reply to Thread
Results 1 to 2 of 2

Make Table Automatically Expand Rows NOT Columns

  1. #1
    Registered User
    Join Date
    07-18-2013
    Location
    Chile
    MS-Off Ver
    Excel 2013
    Posts
    29

    Make Table Automatically Expand Rows NOT Columns

    Hello,
    I was wondering how would one make tables expand only by row and not by columns. I have an excel tab where this is working perfectly however I’m filling up a new table and when I input data on the final column/row, it automatically expands. Now, I do want it to expand by row, just not by column.

    Any ideas? Thanks in advance

  2. #2
    Forum Contributor
    Join Date
    06-30-2015
    Location
    Netherlands
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    145

    Re: Make Table Automatically Expand Rows NOT Columns

    Hi,

    The setting for the table is managed via:
    Excel Options click Proofing, then click the 'AutoCorrect Options' button. On the 'AutoFormat as You Type' tab, check the box labeled "Include new rows and columns in table".

    As you can see the option to auto expand is a combined setting for rows and columns. To the best of my knowledge you can't change this setting.

+ 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. Replies: 3
    Last Post: 02-17-2014, 09:20 PM
  2. Expand a table by adding rows ( table feature 2007 and later)
    By Pepe Le Mokko in forum Excel General
    Replies: 3
    Last Post: 08-13-2013, 05:12 AM
  3. Automatically insert rows and columns as pivot table changes
    By Jayrome in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-07-2012, 03:41 AM
  4. Can i make the columns expand?
    By youngsequan in forum Excel General
    Replies: 0
    Last Post: 12-04-2009, 11:38 AM
  5. Expand Columns (rows) from looking into second worksheet
    By sumomomo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-05-2009, 02:14 PM
  6. Expand & Collapsing Rows/Columns
    By telton in forum Excel General
    Replies: 1
    Last Post: 08-29-2007, 03:47 AM
  7. Expand columns to additional rows
    By sfsdfred in forum Excel General
    Replies: 0
    Last Post: 08-14-2007, 06:00 PM
  8. [SOLVED] How do I make rows expand to fit wrapped text in cells?
    By FRUSTRATED in forum Excel General
    Replies: 3
    Last Post: 05-27-2005, 03:05 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