I have to admit that the Mail Merge is one of my favorite options in MS Word and I often use it when I need to send a group of emails or address a large number of envelopes. It is enough to import the contact list and the addressing process is completely automatic. Can something like this be done in Excel as well? Yes, there is an easy way to do that, and you will find out how to achieve this in the text that follows.
If you are a wholesaler or distributor, you will often form more price lists for different groups of partners, which can be retail, wholesale, hotels and restaurants… Wouldn’t it be a good idea to keep all your product and price information in one table and print it, by desired criteria, when needed for each specific customer? Let’s see the practical application of the Advanced Filter option…
If we want to print a large table, it will take up several pages of reports that we have sent to the printer. On that occasion, the table header appears only on the first page. The following text will show the technique used to adjust the layout of the report so that the header is repeated on all pages. Also, we will mention several more useful techniques for preparing for printing regarding quality and the presentation of certain elements of the report.