+ Reply to Thread
Results 1 to 3 of 3

Height of excel rows increases when printing

  1. #1
    Registered User
    Join Date
    07-12-2019
    Location
    Mannheim, Germany
    MS-Off Ver
    2016
    Posts
    5

    Height of excel rows increases when printing

    To save as much space as possible, I adjusted the height of rows in a way that there is only a small space between text and upper and lower cell border. When printing, for some rows this space becomes bigger and I don't know why and how to avoid that. This happens to rows with wrapped text (but only to some, not to all cells with wrapped text). This "change" is already visible in the print preview but not in the page break preview.

    Does anybody knows the cause for this and how to avoid it?

    Thank you.

  2. #2
    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,936

    Re: Height of excel rows increases when printing

    Probably not the answer you wanted, but remove meregd cells and avoid using them if at all possible. They cause all sorts of problems with formulas and other functions.
    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

  3. #3
    Registered User
    Join Date
    07-12-2019
    Location
    Mannheim, Germany
    MS-Off Ver
    2016
    Posts
    5

    Re: Height of excel rows increases when printing

    Unfortunately this is indeed not helping me, because the excel sheet is mainly a text sheet, most of the cells include long texts. Not using "wrap text" but doing it manually would cause an impossible expenditure of time :/

+ 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. Printing a document where the Doc number increases each print job
    By THC1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2016, 01:20 PM
  2. Replies: 1
    Last Post: 09-25-2015, 11:49 AM
  3. Replies: 11
    Last Post: 05-27-2015, 03:43 AM
  4. Replies: 4
    Last Post: 03-21-2015, 08:18 PM
  5. counting increases and decreases across rows
    By Northern in forum Excel General
    Replies: 1
    Last Post: 09-25-2010, 09:31 AM
  6. Replies: 1
    Last Post: 09-19-2005, 10:05 PM
  7. change excel row height without showing hidden rows
    By LL in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-15-2005, 02: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