![]() ![]() In this method we will select the area, to be defined as the print area in the Page Setup dialog. Now on the Page Layout tab, you will see an option called Print Area.We are going to use a feature of that tab. If you explore Excel ribbon, you will find Page Layout. You can create your print area very easily. For initializing a certain area, you have two options. ![]() This method can be very handy, if you print a selected area frequently. In this way, we will set a printing area before triggering the print. Method 2: Define the Printing Area in Excel Now you will see the preview area is showing only the selected cells. Now on the Excel Print Settings option click on the list icon of print area settings.Now, Click on File (on the top left of Microsoft Excel) and then select Print or simply press Ctrl+P.Select the range of cells you want to print, let’s assume you want to print the Customer Name, Address and Email only.The first method is easy as the name suggests, you select your desired cells and print. Further Readings 2 Ways to Print Selected Cells in Excel Method 1: Printing a Specific Selection of Cells in Excel ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |