+ Reply to Thread
Results 1 to 7 of 7

quickly adjust row heights

  1. #1
    Forum Contributor
    Join Date
    11-30-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2007
    Posts
    212

    quickly adjust row heights

    I am working spreadsheet that needs to print to fit existing forms. I have figured out the height of each row for a page so everything ends up in the right place. Is there a way to duplicate those various heights for the rest of the pages?
    "Laugh? I thought I'd die!"

    Jimbo?

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,503

    Re: quickly adjust row heights

    Format painter?
    Last edited by Sam Capricci; 05-23-2014 at 06:11 PM.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: quickly adjust row heights

    If you click on a cell in the 1st worksheet, then click onteh tab of the last worksheet, this will "group" all your sheets.

    Now, whatever you do to 1 sheet, will get done to all the sheets...if you adjust the height of row 2, all row 2's get adjusted. If you enter in A1 =B1, then that will be entered in all A1's etc

    When done, right-click a tab and select Ungroup
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Contributor
    Join Date
    11-30-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2007
    Posts
    212

    Re: quickly adjust row heights

    FDibbins - that's a good trick. I had no idea.
    Sambokid - I don't know what format painter is. I will see what I can find about it.

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: quickly adjust row heights

    Format painter is the little paint brush on the Home tab in the left corner. you click a cell (or range) containing the format you want to copy, click the format painter, then click the cell (or range) that you want to copy the format to - really cool

  6. #6
    Forum Contributor
    Join Date
    11-30-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2007
    Posts
    212

    Re: quickly adjust row heights

    Best. Lesson. Ever!!!!

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: quickly adjust row heights

    Happy to help and thanks for the feedback

+ 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 Adjust Stacked Column Need to Adjust Legend
    By tbren in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-29-2013, 01:56 PM
  2. adjust logarithmic scale + adjust chart
    By voltaire101 in forum Excel General
    Replies: 5
    Last Post: 08-05-2010, 08:12 PM
  3. Different row heights in same row
    By grievousangel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-09-2009, 06:43 AM
  4. Replies: 1
    Last Post: 01-16-2009, 05:31 PM
  5. Replies: 1
    Last Post: 06-23-2006, 10:06 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