View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default 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