Many people love the “Hide” function for hiding rows or columns, as it is very easy to use:
Category: General
How to Set Headers and Footers When Printing: Two Methods!
Formatting an Excel table for printing is usually troublesome. You have to adapt the print area, select rows and columns to repeat and set the header and footer. In this Excel Tip, we’ll have a look at setting headers and footers.
Remove Duplicates: How to Condense Excel Tables to Unique Items
Now we are coming to a very useful but rather unknown function: Remove Duplicates. Let’s say, you got a list of names and some names are twice on the list. With Remove Duplicates, you can delete those duplicated names automatically so that each name appears only one time.