software

I have a spreadsheet that a foreman wants to have a continuous page but he
wants to have certain wording to print when he tells it to. I can't figure
out how to do this. Below is what he wants to print on every sheet. How do
I do this?
1. Place inspection code in column quot;Cquot; and an A or R in the accept/reject
colum
2. Fill out Nonconformance Report for rejected items, enter NCR no. in
column marked A/R.
3. Acceptance criteria AWS D1.1 latest edition Section 6. File Reports in
appropriate job file.
INSPECTOR: ____________________________
DATE:_________________CONTRACT NO.
_________________________If I read you correctly, you want all that printed at the top of every
printed page no matter what on that sheet the foreman chooses to print. Is
that correct?
If so, then do this. At the top of that spreadsheet, type exactly what
you want printed at the top of every printed sheet. Let's say that takes 9
rows. With that sheet on the screen, click on File - Page Setup. Select
the quot;Sheetquot; tab. Find the text space that is labeled: quot;Rows to repeat at
top:quot; In that space put quot;1:9quot; without the quotes. Click OK. Done. Please
post back if this doesn't answer your question. HTH Otto
quot;Maryquot; gt; wrote in message
...
gt;I have a spreadsheet that a foreman wants to have a continuous page but he
gt; wants to have certain wording to print when he tells it to. I can't
gt; figure
gt; out how to do this. Below is what he wants to print on every sheet. How
gt; do
gt; I do this?
gt; 1. Place inspection code in column quot;Cquot; and an A or R in the accept/reject
gt; colum
gt; 2. Fill out Nonconformance Report for rejected items, enter NCR no. in
gt; column marked A/R.
gt; 3. Acceptance criteria AWS D1.1 latest edition Section 6. File Reports
gt; in
gt; appropriate job file.
gt; INSPECTOR: ____________________________
gt; DATE:_________________ CONTRACT NO.
gt; _________________________
gt;
Actually I want to print all of this at the bottom of every page. How do I
go about doing that?

quot;Maryquot; wrote:

gt; I have a spreadsheet that a foreman wants to have a continuous page but he
gt; wants to have certain wording to print when he tells it to. I can't figure
gt; out how to do this. Below is what he wants to print on every sheet. How do
gt; I do this?
gt; 1. Place inspection code in column quot;Cquot; and an A or R in the accept/reject
gt; colum
gt; 2. Fill out Nonconformance Report for rejected items, enter NCR no. in
gt; column marked A/R.
gt; 3. Acceptance criteria AWS D1.1 latest edition Section 6. File Reports in
gt; appropriate job file.
gt; INSPECTOR: ____________________________
gt; DATE:_________________CONTRACT NO.
gt; _________________________
gt;

Mary
Look at Page Setup as before, but look at the Header/Footer tab. There
you have a block into which you can write a footer to go at the bottom of
the printed page. I don't know how long a footer can be but give that a
try. HTH Otto
quot;Maryquot; gt; wrote in message
...
gt; Actually I want to print all of this at the bottom of every page. How do
gt; I
gt; go about doing that?
gt;
gt; quot;Maryquot; wrote:
gt;
gt;gt; I have a spreadsheet that a foreman wants to have a continuous page but
gt;gt; he
gt;gt; wants to have certain wording to print when he tells it to. I can't
gt;gt; figure
gt;gt; out how to do this. Below is what he wants to print on every sheet. How
gt;gt; do
gt;gt; I do this?
gt;gt; 1. Place inspection code in column quot;Cquot; and an A or R in the
gt;gt; accept/reject
gt;gt; colum
gt;gt; 2. Fill out Nonconformance Report for rejected items, enter NCR no. in
gt;gt; column marked A/R.
gt;gt; 3. Acceptance criteria AWS D1.1 latest edition Section 6. File Reports
gt;gt; in
gt;gt; appropriate job file.
gt;gt; INSPECTOR: ____________________________
gt;gt; DATE:_________________ CONTRACT NO.
gt;gt; _________________________
gt;gt;