If you selected multiple print areas, cycle through the pages by clicking the arrow at the bottom of the preview pane to view one print area per page.Ĭlick the preferred options for “Printer” and “Settings.” Examples of “Settings” options include “Print Active Sheets,” “Print on Both Sides,” “Portrait Orientation” and “Fit All Columns on One Page.”Ĭlick the “Print” button.
The selected cells will change color as you click the next group of cells.Ĭlick the “Page Layout” tab on the command ribbon.Ĭlick “Print Area” in the “Page Setup” group to open a short list of two options: “Set Print Area” and “Clear Print Area.”Ĭlick “Set Print Area.” Your selected area will show an outline of broken lines.Ĭlick the “File” tab on the command ribbon to show a list of options.Ĭlick “Print” to display a preview of the selected cells in the right pane. If we want to print non-adjacent cells, we can set multiple print areas by holding down the Ctrl key while we click the cells we want to print. To select multiple print areas, hold down the “Ctrl” key on your keyboard and click each area on the worksheet. The selected cells will display a dark outline. Go to Page Layout > Page Setup > Print Area > Set Print Area. 3 Masuk ke menu File dan pilih Cetak atau Print. Select the range of cells that you want to set as the print area in that Excel worksheet. Klik dan tahan sel pertama dan tarik kursor sampai Anda telah menyorot seluruh bagian yang ingin Anda cetak.
Klik ganda lembar kerja atau masuk ke File > Buka atau File > Open di Excel. Click and drag the cursor to highlight those cells for the selected print area. Metode 1 Mencetak dari Pilihan 1 Buka lembar Excel.
0 kommentar(er)
