If I choose to Print this page, even though I only want to print the 17 rows with data, you can see that Excel wants to print all 51 rows: Here I have a data range that has a header plus 50 rows for data: If you get a preview, look for the download arrow in the upper right hand corner. You can download the file here and follow along. In this tutorial we are going to discuss a process using the OFFSET function to automatically adjust your print area as you add or remove rows of data. ![]() Often you may have a data range that you add or remove rows, and you need to keep redefining the print area manually.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |