Now you've created a dynamic print area based on the data in column C. This will cause the height of the range to be based on the count of items in column C.ģ) Now change the formula in the Print Area item in the Name Manager to be =DynPrint That creates an item in your Name Manager called Print Area with that range defined:Ģ) Next, create a new item in the Name Manager calling what you want (I'll call mine "DynPrint"), and enter this formula: Well, as you can see on the video, to set up the the print area for a single column, you would follow these steps:ġ) Set any print area for your data range by selecting that range and choosing the Set Print Area from the Print Area drop down on the Page Layout tab of the Ribbon: Recently I had a question come to me asking what if the height of the data range can fluctuate based on several different columns? How do you address that? A similar concept can be used to adjust the width of the print area. In a recent post that I referenced above, you can see how to set up your print area dynamically based on the height of the data in a specific column of your data range. 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 post on this topic can be found here. This is an update to a previous post on setting a dynamic print area, but addresses the issue of determining the height of the print area based on several columns, not just a single column of data.
0 Comments
Leave a Reply. |