Excel calculates wrong. Yes, in some cases, Excel will return wrong results. You don’t believe me? Then type the following formula into an empty Excel cell: =1*(0.5-0.4-0.1). The result should be 0. But what does Excel show? -2,77556E-17. This is just a simple example, but when it comes to larger Excel models it can be quite… Continue reading Wrong Calculations: Why Does Excel Show Wrong Results & How to Fix It
Category: General
How to Work on Several Excel Worksheets Simultaneously
Sometimes you want to do changes to several worksheets at the same time. That requires, that all the worksheets have the same structure. So, how to do that?
How to Avoid Data Loss by Setting a Shorter AutoRecover Period
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.
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.