putting line at the end of each page

[vinumv]

Dear all,

Hope you all are fine. I am seeking for a help from you all. May be it is very simple. But, am not able to crack it down. I would like to put a line at the end of each page in XL work sheet. More clear, I need not want to use the border option or drawing line maually at each page. My search, is If I draw a line in the end of a first page of a worksheet, it should automatically reflect in all other remaining pages.

Can you suggest a simple method to do so. I feel if it is in the top of a page we can use page set up and go for rows to repeat at top. Whereas to get a line at bottom am feeling bit tricky.

Expect your valued suggestion.

with best regards

Vinu

vinumv


#2 Today, 02:10 PM
cycling-rod is Offline:
Registered User Join Date: Aug 2004
Posts: 188

One simple way is to fill colour a row with black and then close it up with the cursor to make a thick line. Copy and paste this line down the sheet wherever and above the dashed lines marking the page length on the spreadsheet appear.
Another simple way is to use: =REPT("_",1000) in A54 (if row 54 marks the last row in a Print Preview). The under score "_" is the character to form the line, and the 1000 is the number of times to repeat "_" (adjust the 1000 for length as required). Format the row to thicken the line and close up the row height to something like 7.50. Then copy and paste down the sheet on every 54th row.
Hopefully, someone will produce a way to put a line at the foot of each page using code.

cycling-rod
View Public Profile


#3 Today, 03:36 PM
olasa is Offline:
Registered User Join Date: Dec 2004
Location: Sweden
Posts: 283

...if so, then I would add: =IF(MOD(ROW(),54)=0,REPT("_",100),"")
ROW() will return the row number that the formula is located in.
MOD(..,54) will calculate the remainder (54/54=0, 541/54=1, ...)

But I would prefer to use Conditional Formatting with the Condition1: Formula Is:
=MOD(ROW(),54)=0 and format the Boarder line (see encl. picture).

Ola Sandström


Note:
All your printing area must be marked when the Condition is entered.
Attached Images Clipboard01.jpg (84.6 KB, 2 views)


olasa


#4 Today, 06:39 PM
vinumv is Online:
Registered User Join Date: Mar 2005
Posts: 4

Thanks a lot for both of urs effort and contribution.

What I found is, the formulas are helpful when the row height is constant through out the spreadsheet. Whereas in my cases, the row height varies in each page according to the matter what I fill in the cell. So, when it counts the multiples of 54, the second line goes in the row 108, which apparently am getting in the begining of third page whereas I would like to get the line at the end of Page-2.

As such, it will be really appreciated if you can come up with the idea of putting line in the footer or something like that.

with regards

Vinu

vinumv
View Public Profile


#5 Today, 07:28 PM
olasa is Offline:
Registered User Join Date: Dec 2004
Location: Sweden
Posts: 283

Dealing with variable row heights are quite a different matter (=cell(..) can calculate column width but not height).
Try to post your question in the programming forum and see if they can come up a solution.

Good luck
Ola

since this is the suggestion from Ola am putting my prob in the programming forum to get a solution.

with regards
Vinu

[vinumv]

Dear all,

Please do come up with the solution for this prob.

thanks

Vinu