blank sheet

[Rider]

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

thanks

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Jim Cone]

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" <[email protected]>
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

 

[Guest]

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.

 

[Rick Rothstein \(MVP - VB\)]

Can anyone tell me how to print a blank spreed sheet with the grid lines,

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

 

[Guest]

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

Regards

 

[Rider]

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

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Guest]

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.

 

[Guest]

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 types>column
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

 

[Dave Peterson]

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]

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

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Bob I]

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]

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]

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]

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.

 

[Rider]

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

 

[Rider]

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

Rider

 

[Guest]

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