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…
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…
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…
