Control, Shift, Down is a shortcut that I use so much, I think I could do it in my sleep.
This function allows you to quickly and easily highlight sections of information within your spreadsheet without having to use the scroll button or toolbar.
For example, I want to highlight an entire column of data so I can copy it into another column. I would select the first cell of data, A2, for example. When I hit control, shift, down simultaneously on my keyboard, Excel will automatically highlight data from that cell down, as long as it contains data. Now you can copy and paste without having to hold the scroll button and drag down.
You can do this in any direction by using the arrow buttons on your keyboard. You can highlight multiple rows or columns.
Be Careful: If there is a gap in your data, the control, shift, down function will stop highlighting when it reaches a blank cell. Be sure you get all of the data intended.
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.
Here at Advocate Capital, Inc., we are constantly looking for ways to improve. We love feedback from our customers and implement suggestions often. If you have a question or idea for an Excel tip that you would like to see, please let us know!
Training Specialist
Photo Credit: Konstantin Chagin