ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   show page breaks (https://www.excelbanter.com/setting-up-configuration-excel/50393-show-page-breaks.html)

Me2Ewe

show page breaks
 
Could someone tell me the registry settings for me to get the options to
change. I want it to show page breaks all the time instead of going into
options to check the box.
Thank you
B



Dave Peterson

I don't think that there is a registry setting for this.

But when I want to see those dotted page break lines, I just hit the print
preview icon (and close it as soon as it opens).

Be aware that displaying those pagebreaks can cause some macros to slow down to
a crawl.

Another option would be to record a macro when you toggle that setting. Then
run that macro whenever you need to.

Me2Ewe wrote:

Could someone tell me the registry settings for me to get the options to
change. I want it to show page breaks all the time instead of going into
options to check the box.
Thank you
B


--

Dave Peterson

Pank

Go to the VIEW menu, then select Page Break Preview

Hope this helps.

Pank

"Dave Peterson" wrote:

I don't think that there is a registry setting for this.

But when I want to see those dotted page break lines, I just hit the print
preview icon (and close it as soon as it opens).

Be aware that displaying those pagebreaks can cause some macros to slow down to
a crawl.

Another option would be to record a macro when you toggle that setting. Then
run that macro whenever you need to.

Me2Ewe wrote:

Could someone tell me the registry settings for me to get the options to
change. I want it to show page breaks all the time instead of going into
options to check the box.
Thank you
B


--

Dave Peterson



All times are GMT +1. The time now is 05:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com