mlo356
10-19-2016, 05:30 AM
Hi All,
I have continuous (no blanks) data in cells A1 through B10. Currently, I am selecting the cells A1:B1 and using the END function to move to the last row of the dataset which is the range A10:B10. Now I have A1:B10 selected. What I am wanting to do is select the second to last row (A9:B9). At this point I will have A1:B9 selected. SO, I am wanted to move to the end of the data set and then back up one row. How would I do this? I tried offset but it shifts the entire selection and I am only wanting to “back up” a row. I would usually do this with SHIFT+UP ARROW.
Thanks!
I have continuous (no blanks) data in cells A1 through B10. Currently, I am selecting the cells A1:B1 and using the END function to move to the last row of the dataset which is the range A10:B10. Now I have A1:B10 selected. What I am wanting to do is select the second to last row (A9:B9). At this point I will have A1:B9 selected. SO, I am wanted to move to the end of the data set and then back up one row. How would I do this? I tried offset but it shifts the entire selection and I am only wanting to “back up” a row. I would usually do this with SHIFT+UP ARROW.
Thanks!