Probably every Excel user has experienced the following situation: You’ve just finished editing in Excel and during the saving process, Excel crashed. You can’t avoid Excel crashing completely, but you can make sure that the latest possible version of the workbook is saved. Excel provides a AutoRecover function, which saves your Excel table periodically.
Category: General
How to Unhide All Rows or Columns in Excel at Once
Many people love the “Hide” function for hiding rows or columns, as it is very easy to use:
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.