Welcome to the { mindfrost82.com } forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact us.

Go Back   { mindfrost82.com } > Gadget Corner > Tech Newsgroups > Microsoft > MS Office > Excel

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-29-2008, 02:06 AM
Octavio
 
Posts: n/a
Lines around cells question

How do I make disappear or how I hide the lines around the rectangles so
they would not be see or they would not print?
Thanks in advance.

Reply With Quote
  #2 (permalink)  
Old 08-29-2008, 02:49 AM
Roger Govier
 
Posts: n/a
Re: Lines around cells question

Hi

Having created your rectangle, right click on the border>Format
Autoshape>Colours and Lines>Line>Colour>No Line

--
Regards
Roger Govier

"Octavio" <inquirer@inquirer.com> wrote in message
news:AB4ED27C-93B3-4BB0-882A-4F62E5BC9431@microsoft.com...
> How do I make disappear or how I hide the lines around the rectangles so
> they would not be see or they would not print?
> Thanks in advance.


Reply With Quote
  #3 (permalink)  
Old 08-29-2008, 09:39 AM
ThatSaid
 
Posts: n/a
Solved : Lines around cells question

Here's what I have,
a permanent menu button to toggle the lines off and on.


In Xl 2003...

Right click on some empty space in the Toolbars on top of the screen.
(Just to the right of the "?" that gives you the Help screens).
Choose "Customize"
Choose the Middle tab "Commands"*.
In the left pane(Categories*) choose "Forms*"
In the right pane choose Show or Hide the Grid.
There's a button there that looks like a cheese grater.
Slide it out of the dialogue box onto the end of an existing toolbar on top
of the screen.

Close the Customize dialogue box.
Now when you click on the cheese grater the grid will toggle on and off.


HTH

ThatSaid


P.S.
*Please excuse if the terminology is not 100% correct.
I'm working with a French version of Excel and translating on the fly.


Reply With Quote
  #4 (permalink)  
Old 08-29-2008, 11:42 AM
Octavio
 
Posts: n/a
Re: Solved : Lines around cells question

Thank you. The button is called "Toggle Button" in my Excel program, and I
put it on top as you suggested and it works ecellently.

Now, second and related question: I have the same Excel page inserted in a
Word Resume, and the page shows the grid lines there. I don't see the
"Toggle Button" of Excel in the Word program, so let me ask, how do I turn
the grid in Word? (Maybe the button has a different name or is hidden there
somewhere or the procedure is different, please advise).



"ThatSaid" <ThatSaid@ThatSaid.net> wrote in message
news:48b7b5ab$0$894$ba4acef3@news.orange.fr...
> Here's what I have,
> a permanent menu button to toggle the lines off and on.
>
>
> In Xl 2003...
>
> Right click on some empty space in the Toolbars on top of the screen.
> (Just to the right of the "?" that gives you the Help screens).
> Choose "Customize"
> Choose the Middle tab "Commands"*.
> In the left pane(Categories*) choose "Forms*"
> In the right pane choose Show or Hide the Grid.
> There's a button there that looks like a cheese grater.
> Slide it out of the dialogue box onto the end of an existing toolbar on
> top of the screen.
>
> Close the Customize dialogue box.
> Now when you click on the cheese grater the grid will toggle on and off.
>
>
> HTH
>
> ThatSaid
>
>
> P.S.
> *Please excuse if the terminology is not 100% correct.
> I'm working with a French version of Excel and translating on the fly.
>

Reply With Quote
  #5 (permalink)  
Old 08-29-2008, 02:12 PM
ThatSaid
 
Posts: n/a
Re: Solved : Lines around cells question


(You can add gridlines in Word,
but they are special Word gridlines and
not Excels gridlines around the cells).


The Excel page that you inserted includes the gridlines.
AFAIK Toggling gridlines in Word will not have any effect on the Excel
"page".


1. If you inserted the image as an image it will not update or "refresh"
itself.
The image will alway remain the same.

2. If it is inserted as an object you can update it.
You may have to
change it in Excel then
force it to refresh itself in Word.

Or maybe - and I don't know much about this -
you may have to
toggle in Excel
then save the Excel file
then refresh in Word.





Reply With Quote
  #6 (permalink)  
Old 08-29-2008, 02:43 PM
Octavio
 
Posts: n/a
Re: Solved : Lines around cells question

Your advise #2 below worked. Thanks!
(I don't use Excel very often, and I have forgotten the specifics, so that
is why I am asking the questions, since these things are easy to forget)

"ThatSaid" <ThatSaid@ThatSaid.net> wrote in message
news:48b7f5c1$0$913$ba4acef3@news.orange.fr...
>
> (You can add gridlines in Word,
> but they are special Word gridlines and
> not Excels gridlines around the cells).
>
>
> The Excel page that you inserted includes the gridlines.
> AFAIK Toggling gridlines in Word will not have any effect on the Excel
> "page".
>
>
> 1. If you inserted the image as an image it will not update or "refresh"
> itself.
> The image will alway remain the same.
>
> 2. If it is inserted as an object you can update it.
> You may have to
> change it in Excel then
> force it to refresh itself in Word.
>
> Or maybe - and I don't know much about this -
> you may have to
> toggle in Excel
> then save the Excel file
> then refresh in Word.
>
>
>
>
>

Reply With Quote
  #7 (permalink)  
Old 08-29-2008, 05:16 PM
=?Utf-8?B?TGlsbHkyMTY=?=
 
Posts: n/a
RE: Lines around cells question



"Octavio" wrote:

> How do I make disappear or how I hide the lines around the rectangles so
> they would not be see or they would not print?
> Thanks in advance.
>

Go to the page layout tab and click on print titles. Find the tab marked
"Sheet". Within this tab, there is a checkbox for "Print Gridlines". Uncheck
this box. This should cure your problem.

Reply With Quote
Reply

  { mindfrost82.com } > Gadget Corner > Tech Newsgroups > Microsoft > MS Office > Excel


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 02:55 AM.


Powered by vBulletin, Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0 ©2007, Crawlability, Inc.
© 1999-2008 mindfrost82.com v11.0


Sponsors:
Credit Cards | Credit Card Consolidation | Loans | Friendster Comments | Masters Degrees Online



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114