Copying from Excel minus grid lines

Packard Bell iMedia
November 29, 2006 at 07:05:57
Specs: Windows XP SP2, Pentium 4/256MB
How can I copy text from excel spreadsheet and paste onto Word or Outlook without the grid lines showing ?

See More: Copying from Excel minus grid lines

Report •


#1
November 29, 2006 at 08:26:32
If you're copying only text, the gridlines will NOT show. If you're doing a screen print, then they will.

Life is more painless for those who are brainless.


Report •

#2
November 29, 2006 at 09:07:34
Jennifer, try typing the following into excel (Text in column A, numbers in B and C respectively) and then copy onto Word or Outlook and you'll notice the grid lines do show :

Short KO 0.4M NZD Call USD Put 0.6792 5.17%


Report •

#3
November 29, 2006 at 09:55:41
Well, I don't know what's supposed to be in which column, but regardless, no gridlines when I copy and paste the data from one application to another.

Life is more painless for those who are brainless.


Report •

Related Solutions

#4
November 29, 2006 at 11:03:31
Jennifer, try copying this to excel and then copy from excel onto Outlook. For me, gridlines still show even though I change to gridlines off and color white under "Tools" "View":

Column A Col B Col C Col D
ShortKIKO5.5NZDPut 0.8207 5.17% 0.7988


Report •

#5
November 29, 2006 at 11:19:32
I agree with Jennifer. What version of Office?

Report •

#6
November 29, 2006 at 11:35:39
Grok n Jennifer,
I'm using Excel 97 and copying to Outlook 2000. Try copying the following from column A to D after typing them in the respective columns I have indicated on the left and see if the gridlines appear?

Column A : Short 0.4M NZD Call CHF Put 0.6800

Column B: 5.17%

Column C: 0.6792

Column D: 0.7051

I went to "Options" "View" and removed the check mark for gridlines and under "color", enable "white". I copied from column A to D onto Outlook and the gridlines still appear.


Report •

#7
November 29, 2006 at 16:03:41
This behavior doesn't repeat for me in Office 2003, XP, or 2000. I haven't used Office 97 for years, so I'm guessing it may be a compatibility issue since there were many changes made to the Office suite after Office 97 was released. The programs are very different now.

I can't resist asking why you'd be using Excel 97 and Outlook 2000. Why not upgrade the entire suite?

Life is more painless for those who are brainless.


Report •

#8
November 30, 2006 at 06:27:59
Thanks Jennifer, I guessed you may be right;
upgrading them may solve my problem.

Report •

#9
December 7, 2006 at 14:51:43
Maybe updating your office suite will help. Look here: http://office.microsoft.com/en-us/d...

Report •


Ask Question