To change all rows or columns at once, click on the unmarked corner header at the upper left (top of row 1 - left of column A), which will highlight all the cells. Then select Row/Height or Column ...