Another very handy tip to know is how to quickly and easily shift rows around when you’re sorting data on an Excel sheet – for example, if you want to group names and addresses. Of course, you could write a complex statement to achieve this, but for a small list it’s much quicker just to shift the rows around – and by far the best way to do it is to move the data to Word, use Word commands, and then paste it all back to Excel:
1. Copy the rows and columns which contain the relevant data and paste it all into a Word document. It will look like a table and retain all your formatting
2. Select entire rows or parts of rows..
3. Press SHIFT-ALT-UP-ARROW and SHIFT-ALT-DOWN-ARROW to slide them up and down.
4. Once the rows are as you want them, you can paste them back into Excel.
5. (Be careful that you put them back in exactly the right position!)
 |
0 comments:
Post a Comment