Print Vacationer Conditional with airSlate SignNow

Print byline conditional

hello everyone Mike repple from Excel bytes with today's Excel blog post today we're going to take a look at how you can create a dynamic print area for your workbook let's say you regularly delete or add rows to a certain table or range and you don't want to have to keep redefining the print area this method that we're gonna show today will help you automatically and dynamically adjust the print area of your worksheet so let's see how we can do that in Excel so here we have a small data range and you can see I have nine columns of data the first column just numbers the rows from 1 to 50 but I only have 16 items filled in and if I go to file and print you can see it wants to print in fact two pages of data and I really only want to print the first 16 so I'm gonna go back here I also want to note that if we go to formulas and name manager notice that nothing is defined in the name manager here so what I'm going to do is I'm going to highlight the range I want to print I'm going to go to page layout and print area set print area so now that's defined and if I went to file print notice it'll only print those first 16 items along with my header but also note if I go to formula and name manager now there is a named range called print area that defines it as sheet 1 a1 2 i 17 and that's perfect however if I add a few more rows here I'm gonna just copy that and go down and paste that and if I go to file print notice it'll still only print those first 16 rows I have to manually adjust the print area to add or in some cases remove the rows that I do or don't want to include so let's see how we can automatically adjust that with Excel so the first thing we're going to do is create another named range and define the print area dynamically by using a formula so I'm gonna go to the formulas tab I'm going to click name manager I'm gonna say new and I'm gonna call this dy in print for a dynamic print and in the formula or refers to I'm gonna type equals offset parentheses I'm gonna choose a one is my starting point comma I'm gonna go down 0 over 0 now I have to define the height and width of the range I want to print so I'm going to use the count of function and I'm going to select column I for that so it's going to count the items in column i to define the height of the range I'll close my counter function comma and then the width of my range is going to be 9 because it's 9 columns I'll close that and I'll say okay so now I have my print area that was defined before and now a new name item in the name manager called Dyn print so now what I'm gonna do is I'm going to select print area and I'm gonna go down into the formula area here and instead of having it be defined as a 1/2 i-17 I'm gonna have it be defined as Dyn PRI and T which is that named range that we just created with the offset formula I'll say close it's gonna ask me to save it now if I go to file print you'll see it has the first 16 rows of data plus the headers set there if I add a few rows I'm just going to copy this area here and down to 24 if I go to file print notice it's dynamically adjusted my print area because of the offset function that I put in the name manager for print area that defines it to go to row 24 if instead I maybe delete everything except for the first seven rows I go to file print and you can see it automatically adjusted to only include the first seven rows of my data range to print so I'm gonna hit ctrl Z just to undo that ctrl Z again just to get it back to my original 16 so what is the offset function do well we've used offset in many many of the tutorials that I've done but just as a refresher if I type equals offset you can see it returns a reference to a range that is a given number of rows and columns from a given reference I'll hit tab and what you want to start is with a reference from that reference say how many rows down you want to go to start how many columns over do you want to go from that starting point in our case we put 0 and 0 because I want to start at cell a1 is my beginning point then how high do you want the range that's where we use the count of function in column I to count the number of items there and that's how high the range would be and then in the width we use 9 to define 9 columns that we want to print so by using offset as one of the items in the name manager and define the print area based on that offset function in the dying print name range that we created we were able to dynamically create a print area that you can use and it will automatically adjust as you add or delete rows from your data range and there you have it I hope you like what you see if you do like what you see here please take a minute to share this post on your favorite social network I can be found on Facebook Google+ Twitter Linkedin and YouTube so I hope you enjoy this if you'd like to see more please feel free to stop by my website Excel - bytes comm and I hope you subscribe so have a great day and happy excelling