Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Wiggum
 
Posts: n/a
Default only last cell on page to have bottom border (cell area outline)

Is there a way to place a bottom border on only the cell that is the last for
a page. I'd like to outline (frame) the cell area on the page. It appears
that I can outline the entire work area such that the first page has a border
on the top and on the sides. Subsequent pages are side bordered and the
final page is side bordered with a bottom border.
  #2   Report Post  
dave m
 
Posts: n/a
Default

Assuming you mean you want the border when you print your pages. remove all
borders, go to View-page break preview. in this mode you can highlight the
cells inside the page lines and then box then using the Borders button or by
using Format-Cells-borders-Outline.
If your row and column numbers are constantly changing you may want to
consider not formatting borders on cells and just adding a page border before
you print.


Hope this helps,

Dave

"Wiggum" wrote:

Is there a way to place a bottom border on only the cell that is the last for
a page. I'd like to outline (frame) the cell area on the page. It appears
that I can outline the entire work area such that the first page has a border
on the top and on the sides. Subsequent pages are side bordered and the
final page is side bordered with a bottom border.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Border misaligned Carole Drake New Users to Excel 0 April 23rd 05 01:30 AM
Border misaligned Carole Drake New Users to Excel 0 April 23rd 05 01:29 AM
How to create thin cell border Dale Fox Excel Discussion (Misc queries) 4 December 7th 04 04:37 AM
1 Page for every CELL!! Naomi Excel Discussion (Misc queries) 5 December 3rd 04 10:25 PM
Same Cell Header For Every Page localhost Excel Discussion (Misc queries) 1 November 26th 04 02:40 PM


All times are GMT +1. The time now is 01:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"