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 do this, with the 1% cell still copied, select the cells containing the values you want to convert from whole numbers into percentages. If your data is formatted as an Excel table, hover over the ...