Thursday, January 12, 2017

Copying the Contents of a Cell to the Bottom of the Column

I find it really annoying when I'm working in a large spreadsheet and have to copy a formula that I just entered all of the way down to the bottom of the column. Mind you, this isn't much of a problem if the spreadsheet only goes down to the bottom of the screen, but I often work with spreadsheets that contain information on students in multiple buildings; this can mean that I'm dealing with thousands of rows of information. Having to click on the "auto fill" cursor (you know, the little plus sign in the lower right hand of the cell) and drag down through thousands of rows can be a real pain...if only there were an easier way.

Monday, January 9, 2017

How To Join Multiple Cells In A Spreadsheet.

In my last post, I showed you how to take information from one cell and split it into two different cells. In this post, I'm going to show you how to take multiple cells and combine their data into one cell.

There are a couple of ways to merge the cells, but they are both based on the concatenate feature. When you concatenating things, you are linking, or joining them together. In the example that we'll be looking at today, we're going to be taking lists of student first and last names that we have in different cells and putting them together in a different cell.