Home |
Search |
Today's Posts |
#1
|
|||
|
|||
adding a border in Excel when row is the last one?
how to do it?
|
#2
|
|||
|
|||
Hi Rick
you can do this using conditional formatting - choose your data rows starting from row 1 and going down as far as you think you might have data in the future choose format / conditional formatting choose formula is in the white box type =AND(OFFSET($A1,1,0)="",OFFSET($A1,0,0)<"") click on the format button, click on the borders tab and set a bottom border click OK twice Cheers JulieD "Rick" wrote in message ... how to do it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Opening an Excel file | Excel Discussion (Misc queries) | |||
Excel 97 - Adding Every 8th Row - Formula should work, but doesn't | Excel Worksheet Functions | |||
What is the formula for adding mulitple numbers in one excel cell. | Excel Discussion (Misc queries) | |||
Adding a chart to a Word template linked to an Excel doc. | Excel Discussion (Misc queries) |