Option 1 – Hold down the Ctrl key on your keyboard and click each row individually. If you want to print specific rows that are not next to each other, then you have a couple of options. ![]() To undo this setting so that you can print the entire spreadsheet, click Print Area again, then click Clear Print Area. Now when you open the Print menu, the preview will only show the rows that you just selected. Step 4: Click the Print Area button in the Page Setup section of the ribbon, then select Set Print Area. Step 3: Click on the top-most row that you want to print, then drag your mouse down until the desired rows are selected. Step 2: Click the Page Layout tab at the top of the window. Step 1: Open the spreadsheet in Excel 2013. So continue below to learn how to set up your spreadsheet. Fortunately it is possible to do this by using the Print Area feature option in Excel.Īside from saving ink and paper, selectively printing certain rows will make it easier for your spreadsheet’s readers to see the important information in your document. For example, you may find that you only need to print a specific set of rows from your spreadsheet and you want to save the ink and paper that would be wasted by needlessly printing the entire thing. We have written previously about printing in Excel 2013, such as this article about how to print all of your columns on one page, but there are many other ways that you can customize the way that a spreadsheet prints.
0 Comments
Leave a Reply. |