"Jones" is the 23rd tab, "Finklestein" is the 24th tab, and "Washington" is the 25th tab.
On the tabs, sheet "Smith" is the 8th tab. I have also noted that the manner that the sheets display on the tabs is different than the way they are displayed in the VBA project. Attempt three will display sheet "Smith", but print sheet "Washington". If I do it again, sheet "Smith" is dipslayed in print preview, but sheet "Finklestein" will be printed to the PDF. It does not matter whichpreview I print from.
But the sheet that prints out to the PDF is sheet "Jones".
Your browser can’t show this frame.I am running Excel 2007 on windows 7. To see the steps for switching between view, and adjusting the page breaks, watch this short video. Maybe it’s just my computer though – if you try it, please let me know if you see the same thing. I had problems dragging the dashed line in Excel 2013 – the pointer and the grey line didn’t stay in the same place. Go to any one of sheets, select the data in the sheet, and press Ctrl + C keys to copy. Click the New Sheet button (or press Shift + F11 keys) in the Sheet Tab bar to create a new worksheet.
If you don’t like the position that an automatic page break falls, you can drag it to a new location, where it becomes a manual page break. This method will guide you to copy data from each sheet and paste as linked pictures in a new blank sheet, and then print the new sheet in Excel. It shows all the automatic page breaks, as dashed blue lines. It’s a great way to see how the printed pages will look, before you actually print them. and Page Setup dialogs in the middle of the screen and the Print Preview on.
At the left, click the Normal View command.Īnother way to switch between views is to use the small icons at the bottom right of the Excel window:ĭon’t give up on Page Break Preview though, just because it has that annoying “” in the middle of it. The other set is called the Different First Page, which you can select from.To go back to the regular worksheet view: That page number is a sign that you are in Page Break Preview, and you can turn that setting off and on. How did it get there, and how can you get rid of it? Page Break Preview That “” doesn’t appear when you print the sheet, but if you’ve never seen it before, it can be annoying. If you’re familiar with this, maybe you can answer my question, further down, about using it in Excel 2013. Have you seen this? When you open an Excel file, or switch to a different worksheet, there’s a large “” watermark in the middle of the sheet.