Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Feb 2002
    Location
    US
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    first column cover second column (97 sr2)

    My problem here is that the data in first column cover the second column if the second column cells are empty.(see the attachment). I want to be able to see all the empty cells in the second column.
    thank you in advance.
    Attached Files Attached Files

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: first column cover second column (97 sr2)

    I only know of two ways to accomplish this:

    1- Make the first column wide enought for the longest data. Using Format/Column/Autofit Selection will do this.

    2- Put a single quote in all of the empty cells in the second column.
    Legare Coleman

  3. #3
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: first column cover second column (97 sr2)

    Set column A to the desired width and format the cells in column A to alignment/wrap text. Your last entry is very long and using autofit column width will probably not give you a disired result. If you put ' in the empty cells in column B you will not be able to read the ends of the longer text entries in column B.

    Hope this is of some help,

    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

  4. #4
    Lounger
    Join Date
    Feb 2002
    Location
    US
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: first column cover second column (97 sr2)

    Thank you for your helpful idea.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •