Borders in Red "Jim S" <jims03nospam[ at ]qwest.net> 3/22/2007 12:41:35 AM I have a multipage document in excel 2007 and it has borders around each cell but one of the pages got changed by accident and the borders are in red not black and for the life of me I cant seem to change the borders to black. Can someone help? -- Jim

Re: Borders in Red "Lindsay Graham" <LDGraham[ at ]aapt.net.au> 3/22/2007 10:31:22 AM I have Excel 2000, but I presume it is much the same (I guess someone will tell us pretty quickly if I'm wrong): Select the cells with the incorrect borders, choose Format > Cells > Border and select the colour (presumably Automatic) BEFORE you select all the border lines that you want to change from red to black. Lindsay Graham Canberra, Australia "Jim S" <jims03nospam[ at ]qwest.net> wrote in message news:uYssarBbHHA.2552[ at ]TK2MSFTNGP06.phx.gbl... [Quoted Text] >I have a multipage document in excel 2007 and it has borders around each >cell but one of the pages got changed by accident and the borders are in >red not black and for the life of me I cant seem to change the borders to >black. Can someone help? > > -- > Jim >

Re: Borders in Red "Jim S" <jims03nospam[ at ]qwest.net> 3/22/2007 2:27:48 PM No, office 2007 is quite different and when I go to format, cells, it displays borders in red also even though the setting is automatic and it wont change to black. Jim "Lindsay Graham" <LDGraham[ at ]aapt.net.au> wrote in message news:eDgJq0GbHHA.4140[ at ]TK2MSFTNGP06.phx.gbl... [Quoted Text] >I have Excel 2000, but I presume it is much the same (I guess someone will >tell us pretty quickly if I'm wrong): > > Select the cells with the incorrect borders, choose Format > Cells > > Border and select the colour (presumably Automatic) BEFORE you select all > the border lines that you want to change from red to black. > > Lindsay Graham > Canberra, Australia > > "Jim S" <jims03nospam[ at ]qwest.net> wrote in message > news:uYssarBbHHA.2552[ at ]TK2MSFTNGP06.phx.gbl... >>I have a multipage document in excel 2007 and it has borders around each >>cell but one of the pages got changed by accident and the borders are in >>red not black and for the life of me I cant seem to change the borders to >>black. Can someone help? >> >> -- >> Jim >> > >

Re: Borders in Red [Excel 2007] "Bob Buckland ?:-\)" <75214.226(At Beautiful Downtown)compuserve.com> 3/23/2007 6:47:08 AM Hi Jim, Is this a 'print' page on a single worksheet or are you referring to separate worksheets (tabs) as being pages in this case? Was this workbook created new in Excel 2007 or a document created in an earlier version of Excel [You may want to use the link below to also post this to the MS Office Excel discussion group. ============== <<"Jim S" <jims03nospam[ at ]qwest.net> wrote in message news:uDKBI5IbHHA.4176[ at ]TK2MSFTNGP02.phx.gbl... No, office 2007 is quite different and when I go to format, cells, it displays borders in red also even though the setting is automatic and it wont change to black. Jim >> -- Please let us know if this has helped, Bob Buckland ?:-) MS Office System Products MVP >>*Courtesy is not expensive and can pay big dividends<< LINKS A. Specific newsgroup/discussion group mentioned in this message: news://msnews.microsoft.com/microsoft.public.excel or via browser: http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel B. MS Office Community discussion/newsgroups via Web Browser http://microsoft.com/office/community/en-us/default.mspx or Microsoft hosted newsgroups via Outlook Express/newsreader news://msnews.microsoft.com

Re: Borders in Red Tim Feld 3/28/2007 1:10:52 AM Highlite the stubborn cells, right-click and choose "Format Cells". Choose the "Border" tab. Choose "Automatic" for color (or any other color you desire). Here's the tricky part that drove me nuts for a few minutes...after you have chosen the color, make sure to click the borders that you want in the border graphic to the right of the color drop-down menu (or you can click on the "Outline" and/or "Inside" boxes above it). The borders in that small graphic will change to the color you chose in the drop-down. Then click OK. I found that without that last step, it reverts back to the originial color. Seems kind of silly to me, but that's how it works. Tim "Jim S" wrote: [Quoted Text] > No, office 2007 is quite different and when I go to format, cells, it > displays borders in red also even though the setting is automatic and it > wont change to black. > > Jim > > "Lindsay Graham" <LDGraham[ at ]aapt.net.au> wrote in message > news:eDgJq0GbHHA.4140[ at ]TK2MSFTNGP06.phx.gbl... > >I have Excel 2000, but I presume it is much the same (I guess someone will > >tell us pretty quickly if I'm wrong): > > > > Select the cells with the incorrect borders, choose Format > Cells > > > Border and select the colour (presumably Automatic) BEFORE you select all > > the border lines that you want to change from red to black. > > > > Lindsay Graham > > Canberra, Australia > > > > "Jim S" <jims03nospam[ at ]qwest.net> wrote in message > > news:uYssarBbHHA.2552[ at ]TK2MSFTNGP06.phx.gbl... > >>I have a multipage document in excel 2007 and it has borders around each > >>cell but one of the pages got changed by accident and the borders are in > >>red not black and for the life of me I cant seem to change the borders to > >>black. Can someone help? > >> > >> -- > >> Jim > >> > > > > > > >