Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.
2. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'



Undo sort in Excel

A common query is how to undo sort in Excel, i.e. you have sorted some information and for whatever reason need to unsort it again, back to its original sort order.

YouTube Return to the original sort order

Undo just after you have done the sort

If you have just sorted it, then you can simply push the undo button and it should go back to the original. The only time this would be a problem is if, while doing the sort, Excel warns you that the file is so big that undo will be disabled.

Undo sort much later- undo button won’t work

However, you may find that you require the unsort much later in the process, maybe after deleting various items to clean the data. You want the original sort order but don’t want to undo all the cleaning and work you have done.

In this case, right at the beginning you should include a sort order column as shown below. Important is that you don’t use a formula in this column or make sure that you copy/ paste as values the numbers. Now you can delete rows and sort in various ways, and when you want to go back to the original sort order, then just sort on this column.


Undo sort in PowerPivot

Performing an undo sort in PowerPivot is much easier, as a button has been provided to do this very thing.

When you are in the PowerPivot window and have sorted some tables, you will see that the ‘Clear Sort’ button becomes available (as shown below). Click the button and you will go to the original sort order.


Invert/ Reverse COLUMNS in Excel