Combining Ctrl + Shift + Arrow keys lets you extend your selection in any direction until Excel hits a blank cell. Start from the top-left corner of your data, try Ctrl + Shift + Right Arrow, then ...
To learn more about how to repeat the last action in Excel, read further. If you want to duplicate your actions (specifically related to formatting) without having to repeat them manually each time, ...