Scroll donw to the end of a same data bloc within a column in Excel

Copper Contributor

Hi, 

I manage very big tables. I need to access the last cell within a column. 

Let's say we have column A with Month. I have 5000 lines with january, then 2300 lines with february, 3000 for March as an exemple. The column is sorted ascending. Now I would like to scroll down to the last cell before the next month. Let's I'm in A2, and I like a short cut to get to line A5000, just before the change to February. 
Does anyone kon

1 Reply

@niamorsch 

You can try ctrl+F and in "find what" enter "february". Then click "find next" or enter. This returns the first cell with "february" which is one cell below the last cell with "january".