+ Reply to Thread
Results 1 to 2 of 2

set row height AND atuo adjust?

  1. #1
    Forum Contributor
    Join Date
    01-01-2006
    Posts
    122

    set row height AND atuo adjust?

    can you set the row height on a workbook to a certain height and then set it to auto adjust to not go smaller than what you set it at. I hope i worded that correctly.

    at work i have excel 2002 and at home i have 2007 thanks
    "I wish I knew half of what you guys have forgotten"

  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: set row height AND atuo adjust?

    Hi,
    As far as I'm aware there is no sort of minimum height parameter associated with the AutoRowHeight functionality
    Row heights are set at sheet level not workbook.

    To bring any sort of control to row heights you'd need to write a small macro which first set text wrapping, then autosets all the row heights and finally loops through each row to detect a height less than your minimum and reset it to the minimum.

    Regards
    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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