Thread: [Solved] Print Titles Not Formatting
View Single Post
 
Old 05-16-2011, 09:23 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Quote:
Originally Posted by Redink20 View Post
Hey Tony,
I attached a sample spreadsheet to my first thread - do you see it? If not I can try to get it to you another way...
Hi Redink20
Sorry I missed the fact that you had already included a sample in your first post.
In my first spreadsheet (Output TK Version 1) I have added a border to the rightmost column and also at the end of each page. This solution assumes that no extra columns are added and the width of the columns do not change. Also no extra rows are inserted and the contents do not wrap around.
In my second spreadsheet (Output TK Version 2) I have changed each cell border to light grey so that you have a definitive border around each cell. It does not matter if extra columns are inserted before the last column or extra rows are added before the last row. If they are then you need to add the borders to those extra columns/rows.
Hope this helps.
Tony
Attached Files
File Type: xlsx Output TK Version 1.xlsx (143.0 KB, 11 views)
File Type: xlsx Output TK Version 2.xlsx (141.9 KB, 12 views)
Reply With Quote