ExcelBanter - borders

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

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

- - borders (https://www.excelbanter.com/excel-discussion-misc-queries/161944-borders.html)

hello,
when i print preview, it shows all the borders i have for that spreadsheet.
however, when i print out, all the borders are not appear.
what should i do to fix this problem???
thank you

Do you mean actual "borders" from FormatCellsBorders or just the normal
gridlines?

If the latter, FilePage SetupSheet. Checkmark in "gridlines"

If the former, are they colored borders?

FilePage SetupSheet. Uncheck "Black and White"

Gord Dibben MS Excel MVP

On Fri, 12 Oct 2007 13:50:01 -0700, kim wrote:

hello,
when i print preview, it shows all the borders i have for that spreadsheet.
however, when i print out, all the borders are not appear.
what should i do to fix this problem???
thank you