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.
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.
