Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Copying from Excel minus grid lines
Name: ngkh Date: November 29, 2006 at 07:05:57 Pacific OS: Windows XP SP2 CPU/Ram: Pentium 4/256MB Product: Packard Bell iMedia
Comment:
How can I copy text from excel spreadsheet and paste onto Word or Outlook without the grid lines showing ?
Name: Jennifer SUMN Date: November 29, 2006 at 08:26:32 Pacific
Reply:
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.
0
Response Number 2
Name: ngkh Date: November 29, 2006 at 09:07:34 Pacific
Reply:
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%
0
Response Number 3
Name: Jennifer SUMN Date: November 29, 2006 at 09:55:41 Pacific
Reply:
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.
0
Response Number 4
Name: ngkh Date: November 29, 2006 at 11:03:31 Pacific
Reply:
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
0
Response Number 5
Name: Grok Lobster Date: November 29, 2006 at 11:19:32 Pacific
Reply:
I agree with Jennifer. What version of Office?
0
Response Number 6
Name: ngkh Date: November 29, 2006 at 11:35:39 Pacific
Reply:
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.
0
Response Number 7
Name: Jennifer SUMN Date: November 29, 2006 at 16:03:41 Pacific
Reply:
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.
0
Response Number 8
Name: ngkh Date: November 30, 2006 at 06:27:59 Pacific
Reply:
Thanks Jennifer, I guessed you may be right; upgrading them may solve my problem.
0
Response Number 9
Name: OtheHill Date: December 7, 2006 at 14:51:43 Pacific
Summary: Hi there, Could anyone help me maybe with the following. I´m trying to copy paste a lot of graphs from excel to ppt with a macro i found somewhere else on this forum. It´s: Sub CreateNewPowerPointPr...
Summary: Excel, blank spread sheet open... The grid lines are visible that divides all the rows and columns... I select a block of cells, say from A1 to D10 and then I choose to fill in the block with a yellow...
Summary: Take it from start. U open ur master doc in word and have a copy of it. Ur file in excel, must be at 1st line "name of fields" i mean 1 row=1 field name (column a = name; column B = adress, and so on....
0 
