Greetings friends! The tip for today will show you how to select a large chunk of cells in Excel for copying and pasting or for formatting or whatever. Let’s say you copy cell A1 and you want to paste it into cells A2 all the way through A115. Click on cell A1, and copy (whatever way is your favorite). Now click on A2. Scroll all the way down the page until you see A115. Hold SHIFT and click A115, then paste!
If you want to select across a few columns AND down several rows, click on the upper left cell in your range. Scroll to the last row you want to select. Hold SHIFT, and click in the cell furthest to the right in that row. For example, if I want to select columns B through H and rows 2 through 17, I will click in B2, hold shift and click in cell H17. See below: