#How to change print area in excel 2013 pdf#
#How to change print area in excel 2013 plus#
#How to change print area in excel 2013 download#

Note: Once you have converted to PDF, you cannot revert it back into an Excel sheet.

#How to change print area in excel 2013 pdf#

If you had checked the box next to вЂ Open file after publishingвЂ™, Excel will open your saved selection in your default browser or PDF viewer. You will find the selected range of cells saved into a PDF file.

Finally, click on Save to save the selection and close the Save As dialog box.

Check or uncheck the options that you need.

You will see more options at the bottom of the Save As dialog box, like options for optimizing your PDF file, and opening the PDF file after publishing.

Click OK to close the Options dialog box.

Under the вЂ Publish whatвЂ™ section, select the radio button next to the вЂSelectionвЂ™ option.

This will further open a new dialog box for you to enter your options.

Click on the Options button (located towards the bottom of the dialog box).

From the dropdown menu that appears, select PDF.

In the field next to вЂ Save As TypeвЂ™, click on the dropdown arrow.

If not, then leave the filename as it is. In the field next to вЂ File NameвЂ™, type the name you want to give the new file, if you want to save the PDF with a different name.

This will open the Save As dialog box.

If you are asked which folder you want to save to, then select the relevant folder.Select Save As from the options on the left sidebar (if youвЂ™re on older versions of Excel, select Save As from the File menu).In our example, we will select the range A1:F18. Select the range of cells that you want to save in the PDF file.To save a selected range of cells to PDF, here are the steps that you need to follow:

This is a very commonly used method as it is simple and can usually be applied to any Excel version. Method 1: Saving a Selection to PDF using the Save As Dialog Box We will apply the above three methods to save only the shaded portion of the sheet to PDF. Throughout this tutorial, we will be using the following dataset. Method 3: Saving a Selection to PDF using VBA.Method 2: Saving a Selection to PDF using the Publish As Dialog Box.Method 1: Saving a Selection to PDF using the Save As Dialog Box.You can make that dynamic also by using a similar process for the width. The height is defined by the COUNTA function, and we used 9 to define the width, since that is the number of columns in our range. The last two arguments define the size of the range. So, in our example, the reference was cell A1, we went down zero rows and over zero columns, which kept cell A1 as our starting point. The OFFSET function 'Returns the reference to a range that is a given number of rows and columns from a given reference'. Let's take a quick refresher on the OFFSET function. Now, whenever we add or remove items from our data range, the height of the print area will automatically adjust based on the number of items within column 'I'. Next, let's redefine the Print Area item to reference the DynPrint item we just entered: Now we have two items in the Name Manger: How do we create a process that will automatically adjust the height of the range based on the number of rows that contain data? Easy! We'll set up another item in the Name Manager and use the OFFSET function to dynamically define the height.ДЇirst we are going to create another item in the Name Manager, call it 'DynPrint' and insert the following formula in the 'Refers to' area: If I highlight the range I want to print, go to the Page Layout tab and choose Set Print Area, Excel will then define the print range that I want:ДЄnd notice that Excel has defined that range in the Name Manger:Д«ut if I add or remove rows of data, Excel will still print $A$1:$I$17. 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:

#How to change print area in excel 2013 plus#

Here I have a data range that has a header plus 50 rows for data:

#How to change print area in excel 2013 download#

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.