To set multiple print areas in your sheet, hold Ctrl as you select each group of cells. Then, go to the Page Layout tab and click the Print Area drop-down arrow in the ribbon. You can set one or more print areas in the same Excel sheet. This saves you from having to select it every time you want to print. And let me know if you have any questions., you can choose a designated print area in Microsoft Excel. Take a few minutes and watch the video for a visual example of the process. So, start playing with the various values in column "J" and see how it affects the print range. The next two cells tell the OFFSET function how many rows high and how many columns wide we want the print range to be. That's now the upper left corner of our print area. Then we tell the OFFSET function to go down the number of rows that are in cell J1, over the number of columns that are in cell J2. We're starting in cell A2 as our reference or anchor point. So how does the OFFSET function work? Here is the syntax and the formula color coded: So we need to use those cells to enter in the data to control our print area: You'll see that it references cells J1, J2, J3, and J4. So, if you remember the OFFSET function we used: Then, we need to edit the Print Area entry so that it refers to DefinePrint:Īnd now our three entries look like this: Next, if we look at our Name Manager, we'll see this: Now, let's add a new entry to the Name Manager called "DefinePrint" (you can actually call it anything you want, just make sure you follow Excel's naming convention), and enter this formula: Now if we look at the Name Manager, we'll see two entries: You can do that also from the Page Layout tab: Nets, let's set the Print Titles so that we have the headers print no matter what section of our data range we choose. We can do that by highlighting any range of our data, going to the Print Area of the Page Layouts tab and selecting Set Print Area: So the first thing we'll want to do is set a print area. Now, first, if we go to the Name Manager on the Formulas tab, we'll see that it's empty: So let's say we have a data range like this:Īnd you may only want to print certain sections of it, but also want the headers to print. When you get a preview, look for Download in the upper right hand corner. You can download the file here and follow along. The previous tutorials can be found here. In previous tutorials we looked at dynamically and automatically setting your print area, and this just takes that to the next level. In this tutorial we will look at how to use the OFFSET function to specifically define the part of your data range you want to print, just by entering a few numbers in four cells.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |