Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grid Lines
How do i print grid lines WITHOUT the text in the grid lines?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grid Lines
So, you want blank graph paper?
Try he http://office.microsoft.com/en-us/templates/CT101448201033.aspx?av=ZXLThat's Microsoft Graph paper templates. "Julie" wrote: How do i print grid lines WITHOUT the text in the grid lines? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grid Lines
Thanks foir repling Lauren, but I do not want graph paper. I do have some
text in some of the grids. It only prints where the text is. I do need for it to be both. Julie "Lauren Giles" wrote: So, you want blank graph paper? Try he http://office.microsoft.com/en-us/templates/CT101448201033.aspx?av=ZXLThat's Microsoft Graph paper templates. "Julie" wrote: How do i print grid lines WITHOUT the text in the grid lines? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grid Lines
Oh, got it. I'm just going to restate what you want for my own benefit: you
have a worksheet with text in some places and blank in others, but you want the grid lines to stay there, even if there's no text in them. Got it. Okay, are the empty cells formatted to actually have grid lines (not the default gray lines that don't print)? Highlight the cells you want to have the grid lines, then Format Cells Border. Make sure you choose visible lines (like black) and apply them. I'm guessing you've already done this, right? Well, it won't print all of those lines there unless you put something in a box at the bottom right. Make the print lines visible so that you can see which box is the bottom right. Put a space in that box. Now, print preview. That should make the whole page have the gridlines, even the boxes without text. "Julie" wrote: Thanks foir repling Lauren, but I do not want graph paper. I do have some text in some of the grids. It only prints where the text is. I do need for it to be both. Julie "Lauren Giles" wrote: So, you want blank graph paper? Try he http://office.microsoft.com/en-us/templates/CT101448201033.aspx?av=ZXLThat's Microsoft Graph paper templates. "Julie" wrote: How do i print grid lines WITHOUT the text in the grid lines? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grid Lines
It sounds like excel is only printing the range that has values (or formulas) in
the cells. You could also use: Select the range to print file|print area|set print area or select the range to print File|Print Check Selection on that dialog (lower left corner) Excel "knows" how much to print by where values or formulas have been. Instead of a space character like Lauren suggested, I use: ="" in the bottom right corner of the cell to print. I find that that is easier to see in the formula bar and because it's kind of a weird formula, it serves as a reminder why it's there. Julie wrote: How do i print grid lines WITHOUT the text in the grid lines? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grid lines in Excel not showing.Have tools,options,view/grid cked | Excel Discussion (Misc queries) | |||
Grid Lines | Excel Discussion (Misc queries) | |||
Grid Lines | Excel Discussion (Misc queries) | |||
Grid lines | Excel Discussion (Misc queries) | |||
printing grid lines when grid lines is checked | Setting up and Configuration of Excel |