I am writing a business plan which of course will include a number of charts
and figures. I would like to use Excel to enter the data and then copy it to
Word without gridlines.
in word, highlight it all, pick Format/Borders and shading/ pick None
quot;Jakequot; wrote:
gt; I am writing a business plan which of course will include a number of charts
gt; and figures. I would like to use Excel to enter the data and then copy it to
gt; Word without gridlines.
Thanks dlw but it did not work. Any other suggestions?
quot;dlwquot; wrote:
gt; in word, highlight it all, pick Format/Borders and shading/ pick None
gt;
gt; quot;Jakequot; wrote:
gt;
gt; gt; I am writing a business plan which of course will include a number of charts
gt; gt; and figures. I would like to use Excel to enter the data and then copy it to
gt; gt; Word without gridlines.
Jake -
I suggest you explain what you mean by quot;it did not work.quot;
In my experience, an Edit | Copy in Excel followed by a Edit | Paste in Word
yields a table in Word, displayed on screen with very light borders but
displayed in Word's Print Preview without any borders (particularly when the
table is formatted the way dlw suggested). Specifically, what is happening
or not happening?
- Mike
www.mikemiddleton.com
quot;Jakequot; gt; wrote in message
news
gt; Thanks dlw but it did not work. Any other suggestions?
gt;
gt; quot;dlwquot; wrote:
gt;
gt;gt; in word, highlight it all, pick Format/Borders and shading/ pick None
gt;gt;
gt;gt; quot;Jakequot; wrote:
gt;gt;
gt;gt; gt; I am writing a business plan which of course will include a number of
gt;gt; gt; charts
gt;gt; gt; and figures. I would like to use Excel to enter the data and then copy
gt;gt; gt; it to
gt;gt; gt; Word without gridlines.
Correct. It'll print without the grid lines. If you are concerned with
the view in Word, paste--gt;special it as quot;picturequot;.
Hans
Go to Table-gt;Hide Gridlines
If you have borders placed in excel then you will have to remove them
before
copying to Word or they will always show up.--
mphell0
------------------------------------------------------------------------
mphell0's Profile: www.excelforum.com/member.php...oamp;userid=30153
View this thread: www.excelforum.com/showthread...hreadid=509561quot;Jakequot; gt; wrote in message
news
gt; Thanks dlw but it did not work. Any other suggestions?
gt;
gt; quot;dlwquot; wrote:
gt;
gt;gt; in word, highlight it all, pick Format/Borders and shading/ pick None
gt;gt;
gt;gt; quot;Jakequot; wrote:
gt;gt;
gt;gt; gt; I am writing a business plan which of course will include a number of
gt;gt; gt; charts
gt;gt; gt; and figures. I would like to use Excel to enter the data and then copy
gt;gt; gt; it to
gt;gt; gt; Word without gridlines.
Also in Word under TABLE click on hide gridlines.Mike,
You are abslutely correct. I had not attempted to print the document and as
you said the table was displayed in Word with light borders. After reading
your reply I printed the document and there are no gridlines.
Thank you so very much!!
Jerry
quot;Mike Middletonquot; wrote:
gt; Jake -
gt;
gt; I suggest you explain what you mean by quot;it did not work.quot;
gt;
gt; In my experience, an Edit | Copy in Excel followed by a Edit | Paste in Word
gt; yields a table in Word, displayed on screen with very light borders but
gt; displayed in Word's Print Preview without any borders (particularly when the
gt; table is formatted the way dlw suggested). Specifically, what is happening
gt; or not happening?
gt;
gt; - Mike
gt; www.mikemiddleton.com
gt;
gt; quot;Jakequot; gt; wrote in message
gt; news
gt; gt; Thanks dlw but it did not work. Any other suggestions?
gt; gt;
gt; gt; quot;dlwquot; wrote:
gt; gt;
gt; gt;gt; in word, highlight it all, pick Format/Borders and shading/ pick None
gt; gt;gt;
gt; gt;gt; quot;Jakequot; wrote:
gt; gt;gt;
gt; gt;gt; gt; I am writing a business plan which of course will include a number of
gt; gt;gt; gt; charts
gt; gt;gt; gt; and figures. I would like to use Excel to enter the data and then copy
gt; gt;gt; gt; it to
gt; gt;gt; gt; Word without gridlines.
gt;
gt;
gt;
flummi,
You are correct. It did print without the gridlines and thanks fo helping
out.
Jake
quot;flummiquot; wrote:
gt; Correct. It'll print without the grid lines. If you are concerned with
gt; the view in Word, paste--gt;special it as quot;picturequot;.
gt;
gt; Hans
gt;
gt;
dlw,
Thanks for taking the time to help me with the problem. Your solution
worked after I took the time to pring the document.
Jake
quot;dlwquot; wrote:
gt; in word, highlight it all, pick Format/Borders and shading/ pick None
gt;
gt; quot;Jakequot; wrote:
gt;
gt; gt; I am writing a business plan which of course will include a number of charts
gt; gt; and figures. I would like to use Excel to enter the data and then copy it to
gt; gt; Word without gridlines.
- Jun 22 Fri 2007 20:38
How do I copy cells from excel into word without the gridlines?
close
全站熱搜
留言列表
發表留言