+ Reply to Thread
Results 1 to 2 of 2

Cell height difference in normal and print preview window

  1. #1
    Registered User
    Join Date
    04-05-2016
    Location
    India
    MS-Off Ver
    2013
    Posts
    78

    Cell height difference in normal and print preview window

    This is regarding a formatting problem in excel. I have a sheet with bill of quantities (BOQ). The column under ‘description’ in the BOQ is horizontally justified. The height of cell in the normal working window (viewed at 100% zoom) and Print Preview are shown differently which causes some of the data to be clipped vertically.

    I have attached the excel file. See the item with Sl. No. 1.0, 1.3, 2.0 etc. The print copy has the height of cells as shown in the preview but not the normal working window (viewed at 100% zoom).

    Because of this I have to check the height of each cell in the print preview manually and adjust so that no part of the ‘Description’ is cropped.

    Kindly provide a solution.

    Note: Initially, I adjusted the height of the cell by selecting the complete sheet and double clicking on the height marker in the left side.
    Attached Files Attached Files
    Last edited by melvinkoshy; 04-08-2016 at 10:20 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    04-12-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010, 2013, 2016, 2019, Office 365, Google Spreadhsheet
    Posts
    640

    Re: Cell height difference in normal and print preview window

    Hi Melvinkoshy,

    It is better to attach your file here as the link you provide is forcing to install some app before downloading your sample file.

    You can simply attach your file by going on "Go Advanced" option, scroll down and click on Manage Attachments and upload your file.

    Thanks,
    Anil Dhawan

+ 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. Replies: 8
    Last Post: 05-03-2019, 09:10 AM
  2. Replies: 2
    Last Post: 07-30-2013, 01:52 PM
  3. Row height; normal view and print preview
    By jlt199 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-30-2013, 12:19 AM
  4. Normal Print Preview
    By brandonduginski in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-27-2013, 02:07 PM
  5. Replies: 0
    Last Post: 12-01-2011, 03:46 PM
  6. [SOLVED] No colur in normal view but is in print preview
    By Lenoire77 in forum Excel General
    Replies: 2
    Last Post: 06-20-2006, 03:40 AM
  7. [SOLVED] Print Preview is normal, but numbers do not print, just narrative
    By Jackstewart in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-01-2006, 06:10 PM
  8. [SOLVED] Preview Print different to Normal View
    By Vic in forum Excel General
    Replies: 0
    Last Post: 03-02-2006, 08:10 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