Lines around cells question

  • Thread starter Thread starter Octavio
  • Start date Start date
O

Octavio

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

Having created your rectangle, right click on the border>Format
Autoshape>Colours and Lines>Line>Colour>No Line
 
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.
 
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).
 
(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.
 
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)
 
Octavio said:
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.
Click to expand...
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.
 
Back
Top