Posts

How to Create a Mail Merge From Excel to Word

Image
First, create a table in Excel with two columns: the first for names and the second for addresses. Close Excel and open the invitation format we created earlier in Microsoft Word. Next, go to the Mailings menu, select Select Recipients, and then select Use an Existing List. A new window will appear. Locate the Excel file we created earlier. Next, click the Excel file and click Open. A new window will appear. Select the sheet containing the table, then click OK. To display the Excel data in the Word file, first place your cursor where you want it to appear, for example, in the names section. Select Insert Merge Field, then select Name. The name column heading will appear where you placed the cursor. Next, place your cursor in the addresses section, then return to Insert Merge Field, and select Address. To display the list of names and addresses, simply click Preview Results. The column names will change to the list of names and addresses in the Excel file. To change the name and address...

How to Print Using F4 Paper Size in Microsoft Edge

Image
First, go to the print view in Microsoft Edge. Then, scroll down until you find "Print using system dialog," and click it. A different print screen will appear, and then select "Preferences." This will take you to the Canon IP2770's printing preferences. In the "Printer Paper Size" section, select "Custom." A new "Custom Paper Size" window will appear. Set the width and length of F4 paper. The length of F4 paper is 33 cm and the width is 21.5 cm. Then, click "OK" to save the settings, and click "OK" again to close the Canon IP2770's printing preferences. Click "Print" to continue printing and see the results. That's how to print using F4 paper size in Microsoft Edge. I hope this tutorial is helpful. Also, check out the video tutorial I've prepared below. Good luck!

How to Print a Two-Page PDF on One Sheet in Nitro PDF Pro

Image
First, open the PDF file using the Nitro PDF Pro application, then go to the Print view. Then, scroll through the settings on the left side until you find Page Scaling. Click Page Scaling and select Multiple Pages. The settings below will appear. Set the Pages per sheet to 2 by 1, and the print preview will automatically change. To change the display from Portrait to Landscape, go to Print Properties. I'm using a Canon printer, so the print properties display will adjust depending on the printer brand. In the Canon printer's Print Properties, you can change the orientation in the Quick Setup section, then select Landscape at the bottom. Click OK to save the settings, and the print preview will change to Landscape. Then click Print to proceed to printing, and you can immediately see the results. That's How to Print a Two-Page PDF on One Sheet in Nitro PDF Pro. I hope this tutorial is helpful. Please also check out the video tutorial I prepared below. Good luck!

How to Remove Filter Marks in Microsoft Excel

Image
There are two ways to remove filter marks in Excel. The first way is to go to the Home menu in Microsoft Excel, then select Sort & Filter. Then select Filter to disable the filter in the Excel worksheet. For the second way, select all cells with filter marks, then press the Delete key on your keyboard, and the filter marks will automatically disappear. That's How to Remove Filter Marks in Microsoft Excel. I hope this tutorial is helpful. Also, check out the video tutorial I've prepared below. Good luck!