Imagine a table. Columns A1..AA100.000. Column B is a calculation column.
I change the calculation in B1, copy it with <CTRL><C>, click on <CLTR><shift><arrow down> and click <CTRL><v>.
This procedure works perfectly when column B has values, but with B empty (so for the first time) these keycombination ends up on the bottom of Excel.
I navigate around this by first clicking <CTL><SHIFT><END> and go back with <SHIFT><Arrow LEFT>, but is there a better way to select all records of B (so that I have all records between B1 and B100.000?
Bookmarks