blank sheet

It does work--Don's suggestion to your first post worked fine for me.

Put a space character in A1.
Put a space character in the bottom right corner of the range you want printed.

Make sure that you're printing gridlines, too:
File|page setup|sheet tab|check Gridlines.


Rider wrote:

Sorry guys, none of the suggestions work. I can't believe someone hasn't
done this before here. I guess it can't be done.

thanks

Rider wrote:
Can anyone tell me how to print a blank spreed sheet with the grid
lines, so I can hand write my own info?

thanks

--

Dave Peterson

what do you mean by a space character? Do I highligh A1 hit the space bar?
thanks

Dave Peterson wrote:
It does work--Don's suggestion to your first post worked fine for me.

Put a space character in A1.
Put a space character in the bottom right corner of the range you want printed.

Make sure that you're printing gridlines, too:
File|page setup|sheet tab|check Gridlines.


Rider wrote:
Sorry guys, none of the suggestions work. I can't believe someone hasn't
done this before here. I guess it can't be done.

thanks

Rider wrote:
Can anyone tell me how to print a blank spreed sheet with the grid
lines, so I can hand write my own info?

thanks

what do you mean by a space character? Do I highligh A1 hit the space bar?

Yes (for the procedure I posted also). What you are doing is putting a
character in the cell so Excel won't see the sheet as empty and you are
using a blank space so it won't show up in the print out.

Rick

What we are having trouble with is why you can't do it. We all have
absolutely no problem doing what you describe. So perhaps you may tell
us what does happen when you view the Print preview of the selected
area? And what actually happens when you tell it to print?

Rider wrote:

Sorry guys, none of the suggestions work. I can't believe someone hasn't
done this before here. I guess it can't be done.

thanks

Rider wrote:

Can anyone tell me how to print a blank spreed sheet with the grid
lines, so I can hand write my own info?

thanks

I just selected a few cells by typing some letters in each. I went and
checked the print Gridlines and tried printing but only the letters came
out not the lines.

I've tried doing all the suggestions, and I know that a few have tried
and gotten blank cells with the gridlines showing, but I can't. So, it
must be me. I totally don't know Excel, someone mentioned there was a
Border icon and I don't even show that, so I don't know what to do. I
guess I'll go without doing this. Thanks for the help anyway.



Bob I wrote:
What we are having trouble with is why you can't do it. We all have
absolutely no problem doing what you describe. So perhaps you may tell
us what does happen when you view the Print preview of the selected
area? And what actually happens when you tell it to print?

Rider wrote:

Sorry guys, none of the suggestions work. I can't believe someone
hasn't done this before here. I guess it can't be done.

thanks

Rider wrote:

Can anyone tell me how to print a blank spreed sheet with the grid
lines, so I can hand write my own info?

thanks

That's ok, we can work your system around it. Do this, Select the area
you are going to use, then R-click in the area, pick Format Cells, then
Border, Select Color "Black" and then click Outline and Inside buttons
and OK. Then try the printing.

Rider wrote:

I just selected a few cells by typing some letters in each. I went and
checked the print Gridlines and tried printing but only the letters came
out not the lines.

I've tried doing all the suggestions, and I know that a few have tried
and gotten blank cells with the gridlines showing, but I can't. So, it
must be me. I totally don't know Excel, someone mentioned there was a
Border icon and I don't even show that, so I don't know what to do. I
guess I'll go without doing this. Thanks for the help anyway.



Bob I wrote:

What we are having trouble with is why you can't do it. We all have
absolutely no problem doing what you describe. So perhaps you may tell
us what does happen when you view the Print preview of the selected
area? And what actually happens when you tell it to print?

Rider wrote:

Sorry guys, none of the suggestions work. I can't believe someone
hasn't done this before here. I guess it can't be done.

thanks

Rider wrote:

Can anyone tell me how to print a blank spreed sheet with the grid
lines, so I can hand write my own info?

thanks

Bob,
TADDDDDDDDDDDDAAAAAAAAAAAAAAAAAA, Hurray, Yeppppy, Awesome!!!!!

That did it. Now I will try to set the size of the cells and go from there.
Thanks Bob, your explanation did the trick, for me anyway. Thanks to all
for helping out, probably if I wasn't a block head, I would of had this
done already. Thanks again.



Bob I wrote:
That's ok, we can work your system around it. Do this, Select the area
you are going to use, then R-click in the area, pick Format Cells, then
Border, Select Color "Black" and then click Outline and Inside buttons
and OK. Then try the printing.

Rider wrote:

I just selected a few cells by typing some letters in each. I went and
checked the print Gridlines and tried printing but only the letters
came out not the lines.

I've tried doing all the suggestions, and I know that a few have tried
and gotten blank cells with the gridlines showing, but I can't. So, it
must be me. I totally don't know Excel, someone mentioned there was a
Border icon and I don't even show that, so I don't know what to do. I
guess I'll go without doing this. Thanks for the help anyway.



Bob I wrote:

What we are having trouble with is why you can't do it. We all have
absolutely no problem doing what you describe. So perhaps you may
tell us what does happen when you view the Print preview of the
selected area? And what actually happens when you tell it to print?

Rider wrote:

Sorry guys, none of the suggestions work. I can't believe someone
hasn't done this before here. I guess it can't be done.

thanks

Rider wrote:

Can anyone tell me how to print a blank spreed sheet with the grid
lines, so I can hand write my own info?

thanks

Bob,
Let me ask, how do I set the size of the cells I want. Something to do
with first selecting all the cells I'm using?????

thanks


Bob I wrote:
That's ok, we can work your system around it. Do this, Select the area
you are going to use, then R-click in the area, pick Format Cells, then
Border, Select Color "Black" and then click Outline and Inside buttons
and OK. Then try the printing.

Rider wrote:

I just selected a few cells by typing some letters in each. I went and
checked the print Gridlines and tried printing but only the letters
came out not the lines.

I've tried doing all the suggestions, and I know that a few have tried
and gotten blank cells with the gridlines showing, but I can't. So, it
must be me. I totally don't know Excel, someone mentioned there was a
Border icon and I don't even show that, so I don't know what to do. I
guess I'll go without doing this. Thanks for the help anyway.



Bob I wrote:

What we are having trouble with is why you can't do it. We all have
absolutely no problem doing what you describe. So perhaps you may
tell us what does happen when you view the Print preview of the
selected area? And what actually happens when you tell it to print?

Rider wrote:

Sorry guys, none of the suggestions work. I can't believe someone
hasn't done this before here. I guess it can't be done.

thanks

Rider wrote:

Can anyone tell me how to print a blank spreed sheet with the grid
lines, so I can hand write my own info?

thanks

Bob,
Figured out how to resize the cells, thank you for your help.

Rider

Rider wrote:
Bob,
Let me ask, how do I set the size of the cells I want. Something to do
with first selecting all the cells I'm using?????

thanks


Bob I wrote:
That's ok, we can work your system around it. Do this, Select the area
you are going to use, then R-click in the area, pick Format Cells,
then Border, Select Color "Black" and then click Outline and Inside
buttons and OK. Then try the printing.

Rider wrote:

I just selected a few cells by typing some letters in each. I went
and checked the print Gridlines and tried printing but only the
letters came out not the lines.

I've tried doing all the suggestions, and I know that a few have
tried and gotten blank cells with the gridlines showing, but I can't.
So, it must be me. I totally don't know Excel, someone mentioned
there was a Border icon and I don't even show that, so I don't know
what to do. I guess I'll go without doing this. Thanks for the help
anyway.



Bob I wrote:

What we are having trouble with is why you can't do it. We all have
absolutely no problem doing what you describe. So perhaps you may
tell us what does happen when you view the Print preview of the
selected area? And what actually happens when you tell it to print?

Rider wrote:

Sorry guys, none of the suggestions work. I can't believe someone
hasn't done this before here. I guess it can't be done.

thanks

Rider wrote:

Can anyone tell me how to print a blank spreed sheet with the grid
lines, so I can hand write my own info?

thanks

Hi,

Hi,

This works. You can think about your convience with this example.

Do the following:

Procedure 1:

1. Click cell A1 and press the space bar.
2. Type a Character and highlight the character.
3. On the Font menu, click Cell. The Format cells dialog appears.
4. Click the Font Tab.
5. In the Color list, click the White color.
6. Click OK to save the settings and return to the Worksheet. The Worksheet
cell A1 contains text which cannot be seen.

Procedure 2:

1. Click Cell F16 and press the space bar.
2. Type a Character and highlight the character.
3. On the Font menu, click Cell. The Format cells dialog appears.
4. Click the Font Tab.
5. In the Color list, click the White color.
6. Click OK to save the settings and return to the Worksheet. The Worksheet
cell F16 contains text which cannot be seen.
7. Now hight the reange A1:F16.

Procedure 3:

1. On the File menu, click PageSetup. The Page Setup dialog box appears.
2. Click the Sheet tab, and then click the Gridlines checkbox under the
Print section.
3. Click OK to return to the worksheet. Do not deselect the range selection.
4. On the File menu, click Print. The Print dialog box appears.
5. Under Print What section, click Selection, and then click OK.

This will print the page with selected range with the gridlines.

This is just an example to you a printed output of cll with gridlies and
without content. This will give you an overview of how to get your solution
get done.

Challa prabhu

"Rider" wrote:

Can anyone tell me how to print a blank spreed sheet with the grid
lines, so I can hand write my own info?

thanks