ExcelBanter - how do I remove multiple pagebreaks in an excel document in one g

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

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

- - how do I remove multiple pagebreaks in an excel document in one g (https://www.excelbanter.com/excel-discussion-misc-queries/87574-how-do-i-remove-multiple-pagebreaks-excel-document-one-g.html)

Annet Chabot

how do I remove multiple pagebreaks in an excel document in one g

I want to remove multiple pagebreaks in an excel document in one go, is that
possible?

Ardus Petus

how do I remove multiple pagebreaks in an excel document in one g

activesheet.resetallpagebreaks

HTH
--
AP

"Annet Chabot" <Annet a écrit dans le
message de news: ...
I want to remove multiple pagebreaks in an excel document in one go, is
that
possible?

Dave Peterson

how do I remove multiple pagebreaks in an excel document in one g

Hit ctrl-a enough times so that all the cells are selected.
Then Insert|Reset All Page Breaks

Annet Chabot wrote:

I want to remove multiple pagebreaks in an excel document in one go, is that
possible?

--

Dave Peterson

All times are GMT +1. The time now is 12:03 AM.