Authored By: Billie Hardison
My favorite things to share are Microsoft Excel tips and tricks that I have picked up over the years. Here is my favorite shortcut that often wows people.
Did you know that you can copy information down a column of a spreadsheet with just two clicks? If you are like me, you performed the tedious click and drag for years; but you can accomplish this in a quicker way.
If you enter data into a field in a spreadsheet and then hover over the bottom right corner of that field, you will notice a plus sign appears. While that plus sign is visible, double click, and watch the magic happen!
Bonus: If you are working with numeric data, it will increment automatically for you!
Give it a try the next time you find yourself copying large amounts of data in a column.
If you are an Advocate Capital customer and need help preparing or manipulating data in the Excel application, feel free to contact me at BHardison@AdvocateCapital.com.
Our goal here at Advocate Capital, Inc. is to be more than just a lender. We want to be your complete business partner.