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

"Jake" wrote:

> 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.

Thanks dlw but it did not work. Any other suggestions?

"dlw" wrote:

> in word, highlight it all, pick Format/Borders and shading/ pick None
>
> "Jake" wrote:
>
> > 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.

Jake -

I suggest you explain what you mean by "it did not work."

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

"Jake" <(E-Mail Removed)> wrote in message
newsD14D4D9-3F0F-427D-BD37-(E-Mail Removed)...
> Thanks dlw but it did not work. Any other suggestions?
>
> "dlw" wrote:
>
>> in word, highlight it all, pick Format/Borders and shading/ pick None
>>
>> "Jake" wrote:
>>
>> > 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.

Correct. It'll print without the grid lines. If you are concerned with
the view in Word, paste-->special it as "picture".

Hans

Go to Table->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: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=509561

"Jake" <(E-Mail Removed)> wrote in message
newsD14D4D9-3F0F-427D-BD37-(E-Mail Removed)...
> Thanks dlw but it did not work. Any other suggestions?
>
> "dlw" wrote:
>
>> in word, highlight it all, pick Format/Borders and shading/ pick None
>>
>> "Jake" wrote:
>>
>> > 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.

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

"Mike Middleton" wrote:

> Jake -
>
> I suggest you explain what you mean by "it did not work."
>
> 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
>
> "Jake" <(E-Mail Removed)> wrote in message
> newsD14D4D9-3F0F-427D-BD37-(E-Mail Removed)...
> > Thanks dlw but it did not work. Any other suggestions?
> >
> > "dlw" wrote:
> >
> >> in word, highlight it all, pick Format/Borders and shading/ pick None
> >>
> >> "Jake" wrote:
> >>
> >> > 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.
>
>
>

flummi,

You are correct. It did print without the gridlines and thanks fo helping
out.

Jake

"flummi" wrote:

> Correct. It'll print without the grid lines. If you are concerned with
> the view in Word, paste-->special it as "picture".
>
> Hans
>
>

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

"dlw" wrote:

> in word, highlight it all, pick Format/Borders and shading/ pick None
>
> "Jake" wrote:
>
> > 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.