Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Borders on Excel Cells at the Bottom of a Page

Status
Not open for further replies.

TDAA

Geotechnical
Jul 28, 2005
600
I have developed a sheet that allows me to summarize information off of a sheet in excel. The sheet is also printed as a table for insertion into a report, to show a table of lab testing results.

I have the formatting of the sheet to have a double line at the bottom of the page. This all works for me, but others have started to use the worksheet and seem to have a tough time working without adding or deleting lines, and thus messing up the format. The sheets always print to show the full page grid, even if the cells are empty.

Is there a non-macro (preferred) way to have the last row of cells automatically formatted with a double line at the bottom? This way, people that have a hard time using the sort features can add and remove lines as they wish.

Thank you for any input.
 
Replies continue below

Recommended for you

Maybe lock the cell?

"Do not worry about your problems with mathematics, I assure you mine are far greater."
Albert Einstein
Have you read FAQ731-376 to make the best use of Eng-Tips Forums?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor