Blank Sheet with Gridlines

[Mike Copeland]

I'm trying to create a worksheet for manual entry via Excel, and
although I clicked the Gridlines box in Page Setup/Sheet, the only
gridlines that print are around lines that contain content (at this time
only the title row). I know that I can print all lines & cells with
gridlines, but I don't know how. Please advise. TIA

 

[GS]

I'm trying to create a worksheet for manual entry via Excel, and

although I clicked the Gridlines box in Page Setup/Sheet, the only
gridlines that print are around lines that contain content (at this
time only the title row). I know that I can print all lines & cells
with gridlines, but I don't know how. Please advise. TIA

You will print gridlines when you have rows with content. Blank cells
included!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Mike Copeland]

You will print gridlines when you have rows with content. Blank cells
included!

I'm trying to replicate a "form" that I've been given: it's a page
that has no content except for the header row. Somehow this Excel
spreadsheet has been created so that even though all rows are empty, all
rows on the page print. (The form is meant to be filled in manually...)
All I have to work from is the printed sample page.
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

 

[Claus Busch]

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.

 

[GS]

I'm trying to replicate a "form" that I've been given: it's a page
that has no content except for the header row. Somehow this Excel
spreadsheet has been created so that even though all rows are empty,
all rows on the page print. (The form is meant to be filled in
manually...) All I have to work from is the printed sample page.
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

Actually, yes there is some 'trick' at play (I suspect)! Being a forms
designer myself, I commonly turn gridlines of and create 'field' boxes
using the dotted border style for internal 'gridlines' and the solid
line style for boxing in an area. This may be applied via
ConditionalFormatting in cases where I want the 'effects' to be dynamic
in context with data entry.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Mike Copeland]

Hi Mike,

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

I don't understand this - perhaps I didn't make my needs clear. 8<{{
I created a new worksheet, placing a header row with values for the
columns I intend to (manually) fill in. The worksheet is just that: an
empty form for someone to write in data values (date, amount, name,
etc.).
I have a sample of such a worksheet that has this, and the entire
sheet's gridlines show even though there is no data in any of the cells
- it's an empty form, that's all. I'm trying to recreate this form on
my system (Office 2003) and my wife's (Win7 & Office 365). (I can't get
this to work on either system...)
I'm a neophyte on special processing and formatting.
I tried to follow your suggestion above, but I don't understand the
last parts ("choose the expected border lines for format. So you have
only lines if there are values in A"). I am also confused by the "print
without gridlines" statement, which seems to contradict the whole
concept I'm trying.
Also, why would anything print out if the lengths of data cells were
0?
I apologize for my ignorance, but my experience level with Excel is
minimal. Please advise.

 

[Claus Busch]

Hi Mike,

Am Tue, 22 Oct 2013 09:47:17 -0700 schrieb Mike Copeland:

I have a sample of such a worksheet that has this, and the entire
sheet's gridlines show even though there is no data in any of the cells
- it's an empty form, that's all. I'm trying to recreate this form on
my system (Office 2003) and my wife's (Win7 & Office 365). (I can't get
this to work on either system...)

please have a look:
https://skydrive.live.com/#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
for the workbook "Borders"
There are borders in it if cells in column A are filled


Regards
Claus B.

 

[Claus Busch]

Hi Mike,

Am Tue, 22 Oct 2013 18:55:38 +0200 schrieb Claus Busch:

https://skydrive.live.com/#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
for the workbook "Borders"

download the file with a rightclick. In Skydrive .xls is not supported
and the borders look thicker than in the real sheet.
Then you can put the cursor into the table and select Conditional
Formatting to see the formula and the formatting.


Regards
Claus B.

 

[GS]

Ok.., I thought you were trying to simulate gridlines in a designed
form layout! My bad!!

I suspect you have not defined your Print_Area, and so no gridlines
show in PrintPreview (with Gridlines checked in the Sheet tab of
PageSetup). In order to print default gridlines you must have a defied
Print_Area!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[GS]

Well, I have it working. Not sure it's "legal", but I (1) clicked
Gridlines and (2) placed a blank in each Column A cell down the page.
This "kludge" produced what I needed.
Thanks to all who offered help. 8<}}

Well that's not a good idea because those cells now contain false
values! If you simply set your Print_Area all will work as expected...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Mike Copeland]

Well that's not a good idea because those cells now contain false
values! If you simply set your Print_Area all will work as expected...

Understood. However, the purpose was only to produce a form to be
used for manual data entry, so there's no risk of the worksheet being
used within Excel. (I thought the whole project was going to be easier
than in, say, Word - not sure it was...8<}}

 

[GS]

Understood. However, the purpose was only to produce a form to be

used for manual data entry, so there's no risk of the worksheet being
used within Excel. (I thought the whole project was going to be
easier
than in, say, Word - not sure it was...8<}}

Understood!

Frankly, I have no use for Word as there's nothing I can't do in Excel
that could be done in Word. That said, I think you chose well to do
this in Excel as it's much better suited (IMO) for designing forms.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion