Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TugboatEng 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
Joined
Jul 28, 2005
Messages
600
Location
US
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.
 
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

Back
Top