![]() |
|
|
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. |
|
|||||||
![]() |
|
|
LinkBack | Thread Tools | Search this Thread | Display Modes |
|
|||
|
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. |
|
|||
|
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. |
|
|||
|
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. > |
|
|||
|
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. |
|
|||
|
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. > > > > > |
|
|||
|
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. |
![]() |
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|