Microsoft Office Forums Bottom border on every page break

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 01-30-2019, 06:42 AM
Marcia's Avatar
Marcia Marcia is offline Bottom border on every page break Windows 7 32bit Bottom border on every page break Office 2007
Competent Performer
Bottom border on every page break
Join Date: May 2018
Location: Philippines
Posts: 208
Marcia is on a distinguished road
Default Bottom border on every page break

Hi there, I prepare an average of 13 financial reports every month. Some of the reports consist of several pages.These reports are presented in a four column format, each column is banded with a top, left and right border. Before I print a report, I add a bottom border that connects the left and right borders in every page break. When a row is filtered in or filtered out, I must delete the initial bottom border and draw another one at each of the adjusted page break. My brain usually goes on shutdown from the tedium of manually typing a border. I am sure that a macro can perform this task but my knowledge of macro is next to nothing. Please help. A sample format is attached. The macro should run on selected sheets only. Thank you.
Attached Files
File Type: xlsx Bottom Border.xlsx (32.9 KB, 2 views)
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Table bottom border not performing well herpez Word Tables 2 01-16-2017 03:43 PM
How to extend a table bottom border to the end of the page mikemike616 Word VBA 1 08-20-2015 08:08 PM
Paginate table so cell headings appear top of page instead bottom page when no room bottom page mtcn Word Tables 5 12-11-2014 12:49 PM
"First column" in word table page break border mj1856 Word Tables 1 04-25-2012 03:21 AM
Bottom border on every page break Anchoring a section break to the bottom of a page, and having a table pass over it??? h3rk Word Tables 1 11-20-2009 07:34 AM

All times are GMT -7. The time now is 07:47 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd. is not affiliated with Microsoft