Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grid without a border?
in Excel 2003 is there a way I can have a gid without having the border?
I've selected "no border" evey way I know and I can't get rid of it...tried to make border print "white"..... Can I make a grid (table) without a border in Word 2003? Don't make me use print shop for my project , please..... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grid without a border?
If you want a "grid" that does not correspond to cell borders, you can create
the cell sizes you want somewhere off the working area of your sheet, and apply borders to that area. Then you can select it and do Ctrl-Shift-Edit CopyPicture and then paste it as a "grid" over your working area.......... hth Vaya con Dios, Chuck, CABGx3 "Wendy" wrote: in Excel 2003 is there a way I can have a gid without having the border? I've selected "no border" evey way I know and I can't get rid of it...tried to make border print "white"..... Can I make a grid (table) without a border in Word 2003? Don't make me use print shop for my project , please..... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grid without a border?
in Excel 2003 is there a way I can have a grid without having the
border? I've selected "no border" every way I know and I can't get rid of it...tried to make border print "white"..... Not sure of your meaning, but maybe this'll get what you want. First select a range, like C5:H25, and use Format Cells Border to get a grid with border. Next select row 4 (before the range) and use the "Borders" button in the "Formatting" toolbar to clear all borders from row 4. Likewise for row 26, for column B, and for column I. Result is a grid of lines but without the bounding-box border. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grid without a border?
Sounds good but " create cell sizes" how?
"CLR" wrote: If you want a "grid" that does not correspond to cell borders, you can create the cell sizes you want somewhere off the working area of your sheet, and apply borders to that area. Then you can select it and do Ctrl-Shift-Edit CopyPicture and then paste it as a "grid" over your working area.......... hth Vaya con Dios, Chuck, CABGx3 "Wendy" wrote: in Excel 2003 is there a way I can have a gid without having the border? I've selected "no border" evey way I know and I can't get rid of it...tried to make border print "white"..... Can I make a grid (table) without a border in Word 2003? Don't make me use print shop for my project , please..... |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grid without a border?
Thanks! I'll copy this and give it a try....
"MyVeryOwnSelf" wrote: in Excel 2003 is there a way I can have a grid without having the border? I've selected "no border" every way I know and I can't get rid of it...tried to make border print "white"..... Not sure of your meaning, but maybe this'll get what you want. First select a range, like C5:H25, and use Format Cells Border to get a grid with border. Next select row 4 (before the range) and use the "Borders" button in the "Formatting" toolbar to clear all borders from row 4. Likewise for row 26, for column B, and for column I. Result is a grid of lines but without the bounding-box border. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grid without a border?
It still prints a border all the way around the grid.
"MyVeryOwnSelf" wrote: in Excel 2003 is there a way I can have a grid without having the border? I've selected "no border" every way I know and I can't get rid of it...tried to make border print "white"..... Not sure of your meaning, but maybe this'll get what you want. First select a range, like C5:H25, and use Format Cells Border to get a grid with border. Next select row 4 (before the range) and use the "Borders" button in the "Formatting" toolbar to clear all borders from row 4. Likewise for row 26, for column B, and for column I. Result is a grid of lines but without the bounding-box border. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grid without a border?
It still prints a border all the way around the grid.
Another thought: Click on File Page setup Sheet and make sure "Gridlines" is not checked. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grid without a border?
but I want the gridlines....just not the outside border.....
I'll try it.... "MyVeryOwnSelf" wrote: It still prints a border all the way around the grid. Another thought: Click on File Page setup Sheet and make sure "Gridlines" is not checked. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grid without a border?
Try highlighting the entire area of cells where the border is and then do
Right-click Format cells BorderTab None........ Vaya con Dios, Chuck, CABGx3 "Wendy" wrote in message ... but I want the gridlines....just not the outside border..... I'll try it.... "MyVeryOwnSelf" wrote: It still prints a border all the way around the grid. Another thought: Click on File Page setup Sheet and make sure "Gridlines" is not checked. |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grid without a border?
I've tried that. Didn't remove the border. W
"CLR" wrote: Try highlighting the entire area of cells where the border is and then do Right-click Format cells BorderTab None........ Vaya con Dios, Chuck, CABGx3 "Wendy" wrote in message ... but I want the gridlines....just not the outside border..... I'll try it.... "MyVeryOwnSelf" wrote: It still prints a border all the way around the grid. Another thought: Click on File Page setup Sheet and make sure "Gridlines" is not checked. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 List does not preserve border style for all rows | Excel Discussion (Misc queries) | |||
Conditional Formatting - Frame cells with Outline Border | Excel Discussion (Misc queries) | |||
cell border colors in Excel | Excel Discussion (Misc queries) | |||
Changing Border Thickness Throughout Document | Excel Discussion (Misc queries) | |||
Border misaligned | New Users to Excel |