+ Reply to Thread
Results 1 to 4 of 4

Problem with Autofit column width

  1. #1
    Registered User
    Join Date
    06-19-2022
    Location
    Argentina
    MS-Off Ver
    2019
    Posts
    2

    Problem with Autofit column width

    Hello. I applied Autofit Colum Width to some columns. After this, if I want to set a default width to all columns, it works only for the columns that were not autofit. How can I set a default column width for all columns after autofit some columns? It's like to disable autofit for those columns but there is no option to do that.

    Look at this example. I applied autofit to columns A, B and C. Next I want to set a default width for all columns, I changed my mind about autofitting columns A, B and C. So I apply the default width for all columns option, and now it works only for columns D, E, F, G, H, etc., but it doesn't apply to columns A, B and C anymore.
    ex.PNG

    Thanks your your help.
    Last edited by daniel_garcia; 06-19-2022 at 06:46 PM.

  2. #2
    Valued Forum Contributor rollis13's Avatar
    Join Date
    01-26-2012
    Location
    Cordenons
    MS-Off Ver
    Excel 2016 32bit - Win 11
    Posts
    935

    Re: Problem with Autofit column width

    Take note of your Default Width, select the entire sheet then use from the menu bar Column Width and input the same value as Default Width.
    Last edited by rollis13; 06-19-2022 at 07:12 PM.

  3. #3
    Registered User
    Join Date
    06-19-2022
    Location
    Argentina
    MS-Off Ver
    2019
    Posts
    2

    Re: Problem with Autofit column width

    Quote Originally Posted by rollis13 View Post
    Take note of your Default Width, select the entire sheet then use from the menu bar Column Width and input the same value as Default Width.
    It worked. Thank you!

  4. #4
    Valued Forum Contributor rollis13's Avatar
    Join Date
    01-26-2012
    Location
    Cordenons
    MS-Off Ver
    Excel 2016 32bit - Win 11
    Posts
    935

    Re: Problem with Autofit column width

    Thanks for the positive feedback , glad having been of some help.

+ 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] Autofit column width not working
    By mstimmsy in forum Excel General
    Replies: 3
    Last Post: 05-18-2022, 05:56 AM
  2. [SOLVED] Autofit column width across all columns
    By Thistledown in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-22-2021, 08:55 AM
  3. [SOLVED] Setting up row height and autofit column width with VBA
    By jaredli in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-20-2020, 07:23 PM
  4. [SOLVED] Autofit Column Width
    By plans in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-06-2015, 01:45 PM
  5. Quick Question on Column Width Autofit
    By dellphinus in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-04-2010, 04:19 PM
  6. autofit cells in column width
    By Boethius1 in forum Excel General
    Replies: 5
    Last Post: 04-11-2006, 09:55 PM
  7. autofit Column width- Ajit
    By Ajit Munj in forum Excel General
    Replies: 3
    Last Post: 02-24-2005, 02:06 PM

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