 Hi, this is Ariel from TechSoup. I'm here to share some of my favorite Excel tips with you. This series of tips I call friends don't let friends scroll in Excel. If you want to go to the bottom corner of your spreadsheet, you can scroll down and to the right, or you can just use a keyboard shortcut. If you hit control and end on your keyboard, you jump to the bottom right corner of your worksheet. Similarly, if you want to go to the top of your spreadsheet, you can scroll around a lot, or you can hit control and home on your keyboard to jump to the top left corner of your spreadsheet. You can also use keyboard shortcuts to select data. If you hit control and shift on your keyboard with your left hand and the down arrow key with your right hand, this will select the entire column of data. You can do the same thing from the bottom of your spreadsheet by hitting control and shift with your left hand and the up arrow with your right hand. This will come in handy in just a second. If you want to copy something all the way to the end of a column, you can click on the bottom corner and drag down, but that can be kind of a bummer and take a long time if your spreadsheet is really long, you'll just be scrolling endlessly. Instead, you can use autofill to copy data to the end of your column. To autofill, you just hold your cursor over the bottom right corner of a cell until it changes to a plus sign. Then you just double click and this will automatically autofill or copy the contents of the cell to the end of the column. If you want to paste a formula or any other data all the way to the end of a column and autofill won't work for some reason, you just copy the cell with the formula in it, scroll to the bottom of your sheet, click on the last cell in that column, then hold control and shift with your left hand and hit the up arrow with your right hand, that was the tip I showed you earlier. This will select the entire column from the bottom cell to the top cell. Then you just keep holding the shift key down and hit the down arrow once. This selects everything in the column except for the cell that you're copying. And then you just hit paste. I hope these tips help you break your scrolling habit and make your work in Excel a little bit more efficient. Thanks for watching and be sure to check out our other videos for more quick tips.