page break preview

  1. C

    Copy a form multiple times from page break view

    I want to copy many times a form on the same sheet where it is, it is curious, but they use it at work I think to homogenize the records and records. The example I have is to copy the form (first image) 50 times on the same sheet quickly and without having to go down all the way moving the page...
  2. J

    Excel VBA macro to drag off the page break preview right side

    Sub Macro1() ' ' Macro1 Macro ' ' ActiveSheet.VPageBreaks(1).DragOff Direction:=xlToRight, RegionIndex:=1 End Sub I have recorded a macro to drag off the direction of page break to right, I have 30+ sheets and I want that the code to run over all sheets except sheet name "Count" & "Raw...
  3. J

    Cannot click macro button while in page break preview?

    Hello, I am trying to use a macro button that allows the user to set the page breaks. The goal would be to have the button work as listed below... If ActiveSheet is in PageBreakPreview mode, then switch back to normal mode If ActiveSheet is in Normal mode, then switch to PageBreakPreview As...
  4. M

    Automated page breaks created when deleting rows - affecting manual page breaks

    Hi, I am having an issue with an Excel tool we are using to produce reports. The report is a series of pages in an Excel worksheet. The users asked me to add in the ability to choose which pages are printed off, so I wrote a macro that would copy everything to a new sheet, delete superfluous...
  5. A

    Print preview / Print does not match Page Break Preview...???

    I have just switched to Excel 2010, and I am trying to set up a worksheet to print on 2 pages. I have created this file in Excel 2010, so it is not a conversion from an earlier version of Excel. This is a simple task that I have successfully accomplished, oh, 2,659,393,101 times before (give...
  6. R

    Excel 2007 Normal View w Zoom & Page Break Preview

    Hey everybody! We recently converted to Office 2007 at work, and I'm struggling through the change! One thing that I've noticed in Excel 2007 (which doesn't happen to one of my coworkers) is that if my "Normal View" is zoomed (e.g. 75%, 150%) and I change to "Page Break Preview" view then back...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top