ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I print a blank grid in Excell? (https://www.excelbanter.com/excel-discussion-misc-queries/37797-how-can-i-print-blank-grid-excell.html)

Paul0

How can I print a blank grid in Excell?
 
I want to be able to print a worksheet with grids only.

Pam Coleman

If you go to Page Setup and select sheet, there is an option under print what
to select grids.

"Paul0" wrote:

I want to be able to print a worksheet with grids only.


Gord Dibben

Paul

Excel will not allow you to print a blank sheet.

Workaround...........

On a new worksheet in A1 enter a space(using spacebar).

In L52 enter a space.

You now have a print area of A1:L52

Make sure you have gridlines checked in Page SetupSheet options.

Alternative........select A1:L52 and put borders around the cells.


Gord Dibben Excel MVP

On Fri, 29 Jul 2005 11:45:06 -0700, "Paul0"
wrote:

I want to be able to print a worksheet with grids only.




All times are GMT +1. The time now is 12:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com