Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Additiona colum in excel download

Additiona colum in excel download

Additiona colum in excel download



I hope somebody can help as this is driving me mad!
Attached is the design view of a report, as you can see there is a dotted line between the FTE and Inspections Performed on Time columns. When I export to excel there is an additional column added between these columns, I presume this is because of the dotted line. My problem is that I don't know why the dotted line appears or how to get rid of it. I've tried resizing the columns and making them all the same size but this line still shows

RE: Additiona colum in excel download

Looks like it might be the cell border. You will have to check the cells both left and right of the line.

Highlight a cell. Right click the cell choose FORMAT CELLS. Click the BORDER tab at the top. Look in the Border diagram box on the bottom right side and see if there is a dotted line.

Another thing you might be able to do is highlight both cells left and right of the line, On the Home tab, in the Editing group, click the arrow next to the Clear button , and then do the following to clear only the formats that are applied to the selected cells, click Clear Formats.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close