If you work with large Excel spreadsheets, you know how frustrating it can be to scroll back and forth between different parts of the sheet. Page breaks can help alleviate this issue by allowing you to break up your sheet into smaller, more manageable pieces. Show
While you can insert page breaks manually, there is a much faster way to do it using a keyboard shortcut. In this article, we'll show you how to quickly insert page breaks in Excel using a keyboard shortcut. How to Insert a Page Break in ExcelThere are two ways to insert a page break in Excel: manually or using a keyboard shortcut. To insert a page break manually, click the Insert tab on the ribbon and then click the Page Break button in the Breaks group. This will insert a page break above the active cell. If you want to insert a page break below the active cell, you can select the cell below where you want the page break and then click the Page Break button. You can also insert a page break by right-clicking on the cell where you want the page break and then selecting Insert Page Break from the context menu. To insert a page break using a keyboard shortcut, simply press Ctrl+Shift+Enter. This will insert a page break above the active cell. If you want to insert a page break below the active cell, you can press Ctrl+Shift+Enter and then press the down arrow key. This will move the page break below the active cell. How to Remove a Page Break in ExcelIf you want to remove a page break, you can click on the break line and then press the Delete key. You can also right-click on the break line and select Delete Page Break from the context menu. If you want to remove all page breaks from your sheet, you can click the Page Layout tab on the ribbon and then click the Breaks button in the Page Setup group. This will open the Page Break dialog box. From here, you can click the Remove All button to remove all page breaks from the sheet. How to Use the Page Break Preview Feature in ExcelThe Page Break Preview feature in Excel allows you to see how your sheet will look when it is printed. This can be helpful if you want to make sure that your page breaks are in the right place. To access the Page Break Preview feature, click the View tab on the ribbon and then click the Page Break Preview button in the Workbook Views group. This will open your sheet in Page Break Preview mode. In this mode, you'll see blue lines that represent the page breaks in your sheet. You can drag these lines to move the page breaks. You can also double-click on a blue line to insert a new page break. To exit the Page Break Preview mode, click the Normal button in the Workbook Views group. The Bottom LinePage breaks are a helpful way to break up large Excel spreadsheets into smaller, more manageable pieces. You can insert page breaks manually or use a keyboard shortcut. You can also use the Page Break Preview feature to see how your sheet will look when it is printed. The Excel page break option helps you see where page breaks will appear when your worksheet is printed. In this article I'll show you several ways to insert them manually or by condition. You'll also learn how to remove page breaks in Excel 2010 - 2016, where to find the Page Break Preview, hide and show the marking lines. Page breaks are separators that divide a worksheet into individual pages for printing. In Excel, page break marks are inserted automatically according to the paper size, margin and scale options. If the default settings don't work for you, you can easily insert page breaks in Excel manually. It's really helpful for printing a table with the exact number of pages you want. In this post, I'll show you how to use the Excel Page Break Preview to easily see the changes you make. Also, you'll see how you can adjust the page breaks in the worksheet before printing, how to remove, hide or show page breaks. How to insert a page break in Excel manuallyIf you go to the Print Preview pane and don't like the way your Excel data is laid out for printing across several pages, you can manually insert page breaks where you need them. Below you'll find the steps showing how to do it.
Note. If manual page breaks that you add don't work, you may have the Fit To scaling option selected (Page Layout tab -> Page Setup group -> click Dialog Box Launcher Button image -> Page). Change the scaling to Adjust to instead. On the picture below, you can see 3 horizontal page breaks added. Therefore, if you go to Print Preview, you'll see different parts of data on separate sheets. Insert a page break in Excel by conditionIf you often print your data tables, you may want to learn how to automatically insert page breaks in Excel by condition, for example when a value in certain column
changes. Say you have column named Category and you want each category to be printed on a new page. Below, you'll find several helpful macros and the steps how to add page breaks using the Excel built-in Subtotal functionality. Use macros to add the marking linesBelow you can find two really useful macros. They will remove all default page breaks in your table and will easily add new marking lines at the appropriate locations. Just select the range of cells you want to use for splitting and avoid the headers.
If you are novice in VBA, feel free to read How to insert and run VBA code in Excel 2010, 2013 - tutorial for beginners. Sub InsertPageBreaksIfValueChanged() Dim rangeSelection As Range Dim cellCurrent As Range Set rangeSelection = Application.Selection.Columns(1).Cells ActiveSheet.ResetAllPageBreaks For Each cellCurrent In rangeSelection If (cellCurrent.Row > 1) Then If (cellCurrent.Value <> cellCurrent.Offset(-1, 0).Value) Then ActiveSheet.Rows(cellCurrent.Row).PageBreak = _ xlPageBreakManual End If End If Next cellCurrent End Sub Sub InsertPageBreaksByKeyphrase() Dim rangeSelection As Range Dim cellCurrent As Range Set rangeSelection = Application.Selection ActiveSheet.ResetAllPageBreaks For Each cellCurrent In rangeSelection If cellCurrent.Value = "CELL VALUE" Then ActiveSheet.Rows(cellCurrent.Row + 1).PageBreak = _ xlPageBreakManual End If Next cellCurrent End Sub Use subtotals to insert page breaksHave you ever thought of Subtotal as of an option for inserting page breaks in Excel? This feature actually makes the process rather easy.
You can delete the rows and cells with totals if you don't need them and get your table with page breaks automatically inserted according to the selected settings. How to remove page breaks in ExcelThough it's not possible to remove page breaks that Excel adds automatically, you can easily delete those you inserted manually. You can choose to remove certain marking line or remove all manually inserted page breaks. Delete a page breakPlease follow the steps below to remove a page break in Excel.
Tip. You can also delete a page break by dragging it outside the page break preview area. Remove all inserted page breaksIf you need to delete all page breaks, you can use the Reset All Page Breaks functionality.
Tip. You can also right-click any cell on the worksheet and select Reset All Page Breaks from the menu list. Move a page break in ExcelOne more option you may find helpful is dragging a page break to another location in a worksheet.
Note. After you move an automatic page break, it becomes a manual one. Hide or show page break marksBelow you'll find how to display or hide page breaks in the Normal view
Now you know how to easily turn page breaks on or off in the Normal view. Reset back to the Normal viewNow that all your page breaks found the correct location, you can return to Normal view. It's as simple as clicking on the Normal icon under the View tab in Excel. You can also click Normal Button image on the status bar. That's it. In this article I showed how to use the Excel page break option. I tried to cover all its options and now you know how to insert, remove, show, hide and move page breaks to adjust them before printing. You've also got several helpful macros to add marking lines by condition and learnt to work in the Excel Page Break Preview mode. Please let me know if you have any questions. Be happy and excel in Excel! You may also be interested inBagaimana cara page break di excel?Pada tab Tampilan, klik Pratinjau Putuskan Halaman. , lalu seret garis break halaman ke lokasi baru. Catatan: Saat Anda memindahkan hentian halaman otomatis, penunjuk berubah menjadi hentian halaman manual.
Apa fungsi break pada Excel?Jawaban. Jawaban: Page Break Preview berfungsi untuk menampilkan halaman secara terpisah pada suatu sheet.
Apa fungsi dari Page Break Preview?Jawaban. Page Break Preview Adalah Menampilkan preview potongan halaman jika dokumen akan dicetak. *Page Break Juga digunakan untuk membuat halaman secara terpisah pada suatu sheet.
Bagaimana cara menghilangkan page break di excel?Menghapus break halaman. Pilih lembar kerja yang ingin Anda ubah.. Pada tab Tampilan, dalam grup Tampilan Buku Kerja, klik Pratinjau Hentian Halaman. ... . Lakukan salah satu hal berikut ini: ... . Pada tab Tata Letak Halaman, di grup Penyetelan Halaman, klik Hentian.. Klik Hapus Hentian Halaman.. |