ExcelBanter - Excel 2003

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel 2003 - Cell Borders (https://www.excelbanter.com/excel-discussion-misc-queries/115640-excel-2003-cell-borders.html)

oceanmist

Excel 2003 - Cell Borders

My spreadsheet has borders around all 4 edges of every cell. In the title row
Ihave auto filter on.

When I filter the data and preview, there is no outer border showing at the
bottom.

How do I do this?

Dave F

Excel 2003 - Cell Borders

When you have the filter set, go to Edit--Go To--Special--Visible cells only
and then apply the borders.

Dave
--
Brevity is the soul of wit.

"oceanmist" wrote:

My spreadsheet has borders around all 4 edges of every cell. In the title row
Ihave auto filter on.

When I filter the data and preview, there is no outer border showing at the
bottom.

How do I do this?

All times are GMT +1. The time now is 04:11 AM.