R
Rider
Can anyone tell me how to print a blank sheet, so I can fill in the
cells by hand?
thanks
cells by hand?
thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
Go to the last cell you want and touch the space bar
B
Bob I
Select the area, then File, Print Area, Set print area, File, Print
R
Rider
Sorry Bob,Bob said:Select the area, then File, Print Area, Set print area, File, Print
that doesn't do anything. nothing is printed. maybe i'm doing it wrong
but I tried several times.
thanks
B
Bob I
In that case, File, Page setup, Sheet, and tick "Gridlines" and "Row and
Column headings"
Column headings"
R
Rider
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
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
B
Bob I
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?
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?
G
Guest
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?
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?
D
Don Guillett
Did you try my offering???
G
Gord Dibben
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
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
G
Guest
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
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