Results 1 to 5 of 5

remove unwanted line padding in cells while showing all the text

Threaded View

  1. #1
    Registered User
    Join Date
    10-21-2014
    Location
    Midwest
    MS-Off Ver
    2000
    Posts
    12

    remove unwanted line padding in cells while showing all the text

    This came up before and I believe there were several approaches. This is for a simple 3-column time sheet for itemizing date, services, and billable time. 3 columns: date (about 10 wide), details (about 80 wide) and # of hours (about 10 wide). The "details" columns are the problem. In some cells, there is an extra line of spacing before and/or after the text. It looks like cell padding. And in some cells one or more of the bottom lines do not appear. Adjusting word wrap, row auto fit, column auto fit, alignment, and "number" (general, text) characteristics sends you in circles--the text in some cells will appear correct, but then in other cells there will be extra line spacing and in others the text does not all appear. Sometimes it seems the problem is also related to the printer, but changing printers does not make the problem disappear. Some problem cells show the extra line spacing while in Normal mode, while other cells appear OK but then show the extra spacing only in print preview.

    Some discussions posit that this happens when you paste text from other programs. OK. But I also have this where I am making original entries in each cell. Some discussions target number of lines in the cell, but I have some cells with 2 lines of text and no line spacing before, while other 2-line cells are nice and tight.

    Adjusting margins seems to create tighter middle column cells sometimes.

    All help greatly appreciated.

    p.s. I am using, and prefer, excel 2000 (Yes, 2000)
    Last edited by GaryMN; 07-18-2017 at 08:44 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Unwanted line between text boxes
    By RookA1 in forum Word Formatting & General
    Replies: 2
    Last Post: 06-22-2017, 10:22 AM
  2. want to remove unwanted text from my sheet
    By notbanme in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-24-2016, 01:52 AM
  3. Replies: 7
    Last Post: 05-15-2015, 11:57 AM
  4. [SOLVED] Remove unwanted text/ numbers from name
    By MATU70 in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 05-13-2014, 02:31 PM
  5. Remove unwanted cells
    By C-Shore in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-09-2011, 12:04 PM
  6. Excel 2007 : Remove Unwanted Text from Cells
    By rickygzz in forum Excel General
    Replies: 6
    Last Post: 08-01-2011, 10:28 PM
  7. Replies: 1
    Last Post: 10-14-2005, 10:05 AM

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