Excel Worksheet Tips: Reversing Rows of Data OR Columns of Data – Version 2.0 After creating a procedure to reverse rows or columns of data, I was informed of a much simpler way to do this. Reversing Rows of Data If you have a list of data in multiple rows that you wish to reverse,…
Read More
Excel Worksheet Tips: Reversing Rows OR Columns of Data There are times when you realise your list of data is in the wrong order; for example in rows 1 through 4 you have D then C then B then A. You realise you need the list to be reversed, with the order being A then…
Read More
Excel Worksheet Tips: Switch Between Formula and Results If you have created a worksheet in excel with formula all over the sheet and want to quickly see what the formulae are, use: Ctrl + ~ (Where ~ is tilde; which is located underneath the Esc key) You can even print in this mode and the…
Read More
