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

thanks

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

This works... Put a blank space in any cell, check the Print Gridlines
option in PageSetup/Sheet.

Rick

Enter a space in the top left and bottom right cell.
In File | Page Setup | Sheet (tab)...
checkmark "Gridlines"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


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

thanks

Try highllighting the area in your spreadsheet you would like to print and
then select Format Cells Border Outside and Inside OK and then
print.

"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

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

This works... Put a blank space in any cell, check the Print Gridlines
option in PageSetup/Sheet.

Sorry, not "any cell"... the "last cell" that you want printed on the sheet.

Rick

Hi Rider,
Go to 'File' 'Page Setup' select the 'Sheet' tab.
Under the 'print' option, select 'Gridlines.
Click 'Ok'

Regards


"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

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

Mine worked for me. I'm using Excel 2003 if that matters. The procedure I
followed was to open a new, blank worksheet, go to

Filel/Page Setup

click the Sheet tab on the dialog box that appears and on Print/Gridlines
(if it is on already, click it off and then on again), then click OK. This
placed the sheet print area outline on my grid. I place a blank space in the
bottom-right cell in the top-left marked off area. I then printed sheet 1 of
1 and it worked fine for me.

Rick


"Rider" wrote in message
...
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

Ok, lets try this,
Select all the cells Ctrl A
Then, under the Formatting menu bar, you'll
see the Border picture, next to it, there is a tiny down arrow,
click on it, and it will show you 12 options. Select the option B3

That will put a border around all the cells. So next time you print the
sheet, it will show with grids.

Regards.


"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

good day Rider,

here's another one trick *without a keyboard*...
using your mouse
select the range say a1 to j10...
then click the chart wizard button...select the standard typescolumn
then follow the *wizard*

u can see more than the gridlines...u can roam around the built-in chart and
remove whatever u dont like....

just assuming that u may also like to graph ur own needs...
keeping busy with your other hand <g.

try to see it..

--
regards,
driller

*****
- dive with Jonathan Seagull



"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

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

You're welcome, but I have no idea why your printer refuses to print the
base grid lines. But since the desired end result was achieved, you have
a good one.

Rider wrote:

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