Blank Sheet with Gridlines
Hi Mike,
Am Tue, 22 Oct 2013 07:48:17 -0700 schrieb Mike Copeland:
Is there some way an Excel file can be created with non-displaying
"dummy rows" that print the sheet's gridlines even when they're "blank"?
(Or is there some other sort of "trick" at play here?) TIA
print without gridlines
Select your data table from A1 to the end = Conditional Formatting =
Use Formula .... = Formula = =Len($A1)0 and choose the expected
border lines for format.
So you have only lines if there are values in A
Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|