Can anyone tell me how to print a blank sheet, so I can fill in the
cells by hand?

thanks

Go to the last cell you want and touch the space bar

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rider" wrote in message
...
Can anyone tell me how to print a blank sheet, so I can fill in the cells
by hand?

thanks

Select the area, then File, Print Area, Set print area, File, Print

Rider wrote:

Can anyone tell me how to print a blank sheet, so I can fill in the
cells by hand?

thanks

Bob I wrote:
Select the area, then File, Print Area, Set print area, File, Print

Rider wrote:

Can anyone tell me how to print a blank sheet, so I can fill in the
cells by hand?

thanks

Sorry Bob,
that doesn't do anything. nothing is printed. maybe i'm doing it wrong
but I tried several times.

thanks

In that case, File, Page setup, Sheet, and tick "Gridlines" and "Row and
Column headings"

Rider wrote:

Bob I wrote:

Select the area, then File, Print Area, Set print area, File, Print

Rider wrote:

Can anyone tell me how to print a blank sheet, so I can fill in the
cells by hand?

thanks


Sorry Bob,
that doesn't do anything. nothing is printed. maybe i'm doing it wrong
but I tried several times.

thanks

Bob,
Sorry that didn't work either. There should be a way to print sheet with
nothing in the cells, but with the grid lines to add info by hand??

thanks

Bob I wrote:
In that case, File, Page setup, Sheet, and tick "Gridlines" and "Row and
Column headings"

Rider wrote:

Bob I wrote:

Select the area, then File, Print Area, Set print area, File, Print

Rider wrote:

Can anyone tell me how to print a blank sheet, so I can fill in the
cells by hand?

thanks


Sorry Bob,
that doesn't do anything. nothing is printed. maybe i'm doing it wrong
but I tried several times.

thanks

Yes that was exactly what should have happened. What appears on the
screen when you select "Preview"? And you say "nothing is printed" that
mean no paper comes out or the page that comes out is blank? Also what
rows and columns did you select as the print area? Does the printer
print the grid lines if you put data in a cell in the Selected print area?

Rider wrote:

Bob,
Sorry that didn't work either. There should be a way to print sheet with
nothing in the cells, but with the grid lines to add info by hand??

thanks

Bob I wrote:

In that case, File, Page setup, Sheet, and tick "Gridlines" and "Row
and Column headings"

Rider wrote:

Bob I wrote:

Select the area, then File, Print Area, Set print area, File, Print

Rider wrote:

Can anyone tell me how to print a blank sheet, so I can fill in the
cells by hand?

thanks



Sorry Bob,
that doesn't do anything. nothing is printed. maybe i'm doing it
wrong but I tried several times.

thanks

This is just a thought...

how about filling as many cells as you need to print with whatever you want,
changing the font to white, and then setting the print area?
--
smither fan


"Rider" wrote:

Can anyone tell me how to print a blank sheet, so I can fill in the
cells by hand?

thanks

Did you try my offering???

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rider" wrote in message
...
Bob,
Sorry that didn't work either. There should be a way to print sheet with
nothing in the cells, but with the grid lines to add info by hand??

thanks

Bob I wrote:
In that case, File, Page setup, Sheet, and tick "Gridlines" and "Row and
Column headings"

Rider wrote:

Bob I wrote:

Select the area, then File, Print Area, Set print area, File, Print

Rider wrote:

Can anyone tell me how to print a blank sheet, so I can fill in the
cells by hand?

thanks


Sorry Bob,
that doesn't do anything. nothing is printed. maybe i'm doing it wrong
but I tried several times.

thanks

Go down to L50 and enter a <space.

Set your printrange to A1:L50

Make sure you are set to print gridlines and you're set to print a blank sheet
with gridlines only.


Gord Dibben MS Excel MVP

On Wed, 18 Jul 2007 09:56:41 -0400, Rider wrote:

Can anyone tell me how to print a blank sheet, so I can fill in the
cells by hand?

thanks

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 sheet, so I can fill in the
cells by hand?

thanks