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.
Thursday, January 12, 2017
Monday, January 9, 2017
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.