Print Ranges are used to just print a specific area of a spreadsheet and
not all the cells that contain any data (including spaces). The
dollarsigns in the definition make it an absolute definition, that
doesn't change when you add data close to the range. The range only
changes if you add or delete cells within the range.
This also works in formulas by the way. If you use a dollar sign before
the column or row it doesn't change when you copy the formula to another
cell.
Arnold Huzen
Bernard Bychan schreef:
Thank you very much Arnold!
It helped:
Format --> Print Ranges --> Edit
I changed "$A$1:$E27" to "$a$1:$E29"
But I don't understand, why the program is not adjusting these ranges
automatically as usually.
Bernard
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
