close

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.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()