I am trying to print an order from where I need the gridlines to print. I've
checked the print gridlines box but it just prints the gridlines for the
cells with text in them. How do I print the sheet with all gridlines showing?
Excel will show the gridlines for the cells it thinks it should be printing.
You could put
=quot;quot;
in the bottom right corner of the range and excel will include that cell in the
print range (well, unless you do something to change the print range).
nickjohn wrote:
gt;
gt; I am trying to print an order from where I need the gridlines to print. I've
gt; checked the print gridlines box but it just prints the gridlines for the
gt; cells with text in them. How do I print the sheet with all gridlines showing?
--
Dave Peterson
Alternatley you could select the range of cell you would like to print and
click
Format - Cells - Boarder - and selecto Outline and inside and click OK
quot;Dave Petersonquot; wrote:
gt; Excel will show the gridlines for the cells it thinks it should be printing.
gt;
gt; You could put
gt; =quot;quot;
gt; in the bottom right corner of the range and excel will include that cell in the
gt; print range (well, unless you do something to change the print range).
gt;
gt; nickjohn wrote:
gt; gt;
gt; gt; I am trying to print an order from where I need the gridlines to print. I've
gt; gt; checked the print gridlines box but it just prints the gridlines for the
gt; gt; cells with text in them. How do I print the sheet with all gridlines showing?
gt;
gt; --
gt;
gt; Dave Peterson
gt;
- Sep 23 Tue 2008 20:46
Printing gridlines with empty cell
close
全站熱搜
留言列表
發表留言