+ Reply to Thread
Results 1 to 4 of 4

How to customize standard row thickness?

  1. #1
    Forum Contributor
    Join Date
    10-23-2004
    Location
    Los Angeles
    MS-Off Ver
    2010
    Posts
    253

    Question How to customize standard row thickness?

    I have a table with about 100 rows of data (8 columns). My standard row heights is 24 pixels. Throughout my data set of 100 rows, I randomly have some rows to be taller than others because of the data present on the last column (I have it set to Wrap Text so all the data is seen). I can have on some rows a standards 24 pixel height, and other rows be 48 or 72 pixels because of the amount of characters present on the last column.

    I would like to have my standard row height be of... for example, 30 pixels, or 35 pixels, but for the rows that have lots of data, continue to use the Wrap Text option to continue giving me a custom thickness.

    Is this possible?

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: How to customize standard row thickness?

    The following should work :

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    10-23-2004
    Location
    Los Angeles
    MS-Off Ver
    2010
    Posts
    253

    Re: How to customize standard row thickness?

    Thank you

    Is there a non macro solution?

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: How to customize standard row thickness?

    No . I believe VBA (macro) is the only solution.

+ 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. Excel Chart, How to customize axis units as desired (not excel standard)
    By excelsorusor in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-03-2023, 11:10 AM
  2. How to fix selectable thickness
    By forilohud in forum Excel General
    Replies: 3
    Last Post: 08-21-2016, 02:35 AM
  3. how to change thickness of borders
    By Macu71 in forum Excel General
    Replies: 6
    Last Post: 08-20-2013, 07:28 AM
  4. Plot line thickness
    By pvfoukal in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-02-2011, 09:28 PM
  5. Thickness of error bars
    By nsv in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 06-30-2006, 03:00 AM
  6. Changing Border Thickness Throughout Document
    By Doug in forum Excel General
    Replies: 4
    Last Post: 08-01-2005, 03:05 PM
  7. [SOLVED] Reducing the Thickness of Border
    By Antony in forum Excel General
    Replies: 1
    Last Post: 05-23-2005, 09: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