|
||
 |
||
| August 28, 2018 | ||
| Hi fellow Excel Addict, | ||
We are back from our vacation in Alberta and so proud
of our beautiful, new granddaughter. I'm also happy that the nice summer weather has stayed around because we are now having nicer weather back in Newfoundland than we left behind in Alberta. The downside is that it makes it hard to stay inside working on my computer when the sunshine and warm temps are beckoning me outside. However, I do have an 'Excel in Seconds' tip for you today that hopefully may be a solution if this problem has occurred to you. If you find this tip helpful, I hope you'll share it with others who may also benefit from it. Keep on Excelling, Francis Hayes (The Excel Addict) Email: fhayes[AT]TheExcelAddict.com |
||
|
|
||
Discover what email marketing can do for your company...  |
||
|
|
||
|
||
| |
||
|
||
|
If
you
have a favourite quote, send it to me and I
may post it in my newsletter.
|
||
 |
||
| Restore Original Order After Sorting Unsorted Data | ||
Sometimes you need to temporarily sort data in your spreadsheet. However, if the data isn't sorted to begin with, you may decide against it because you may be afraid you won't be able to put it back in its original order.  1) Temporarily insert a blank column immediately to the left of your data; 2) Type a heading (e.g. Seq) for the new column on the same row as the headings for the rest of your data; 3) Enter 1 in the first cell, 2 in the second cell and drag the Fill Handle to continue the sequence of index numbers to the bottom of your data;  4) Select all of the data you want to sort, including this column; 5) Sort your data on whatever column(s) you want;   This is such a simple solution to a common problem encountered in Excel. Of course, if you are just doing a quick, temporary sort, you can skip all of this and simply Undo the Sort.  However, using an index column gives you the ability to do various manipulations on your data, knowing that you can easily restore it back to its original order. |
||
|
|
||
| 'Excel in Seconds' with The Excel Addict | ||
| Restore Original Order After Sorting Unsorted Data | ||
| If you've found this tip helpful, please share it. | ||
|
|
||
|
||
 |
||
| Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are EVER not completely satisfied with anything I recommend, please let me know and you will get your money...GUARANTEED. You can't lose. | ||
|
"Spreadsheets Tips From An Excel
Addict" is a weekly publication of
TheExcelAddict.com.
Copyright Francis J. Hayes All Rights Reserved. 8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630 |
