Excel tip:Selecting a Large Amount of Data in Excel

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:

Advertisements

2 Comments

Filed under MS Excel

2 responses to “Excel tip:Selecting a Large Amount of Data in Excel

  1. I did not know that! Great!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s