Use MicrosoftÂ® Excel Differently to Gain a Productive Edge
Issue - Oct 2012
In the "Hidden Secrets in Data Analysis with Excel" course, we share with our participants
many shortcuts that they can tap on to increase their work productivity in Excel tasks. One
of them is to double click on a cell to instantly copy its content down to the last row.
Regardless of how many rows you have in the data set, the job is done in just one second.
After a few more double-click tricks, the participants got really excited and ask if we have a compilation of all the double-click tricks in Excel. That gave us the idea to compile this eBook which lists down all the double-click tricks we could think of. Amazingly, we manage to find 19 of them! So if you think that you are a "mouse lover", go ahead and click on this link to request for this eBook. We believe you will like this gift. It's also our way of saying "thank you for staying on our mailing list!"
Here's a question from our members:
I have a column in which I enter numbers e. g. 1 2 3 4 5 6 7 8 9 10 as on. Suppose if I remove /deleted any number e. g. 3, then further columns should automatically adjusted as 3 4 5 as on. PLEASE refer attached sheet, so you will get exact idea what do I want. THANKING YOU.
If you received this newsletter from a friend and would like to be included in our mailing list, please go to our Excel Today's page.
If you have a facebook account, you can like us at facebook or linkedln. From facebook or LinkedIn, you will be notified on mini cases and ideas how we use Excel on a day to day basis. These tips may not be published in our newsletter.
everydayExcel Business Lab Pte Ltd
Author of "Hidden Secrets of Data Analysis with Excel" and
"Excel Secrets for Highly Effective Marketers"
Received this newsletter from a friend? You can request to be included in our mailing list by signing up at our Excel Today's page. If you have friends whom you think might be interested in this newsletter, feel free to send it to them.