large number of spreadsheet filesit will be much quicker to write python program to do it rows and columns can also be hidden entirely from view or they can be "frozenin place so that they are always visible on the screen and appear on every page when the spreadsheet is printed (which is handy for headerssetting row height and column width worksheet objects have row_dimensions and column_dimensions attributes that control row heights and column widths enter this into the interactive shellimport openpyxl wb openpyxl workbook(sheet wb active sheet[' ''tall rowsheet[' ''wide columnset the height and widthsheet row_dimensions[ height sheet column_dimensions[' 'width wb save('dimensions xlsx' sheet' row_dimensions and column_dimensions are dictionary-like valuesrow_dimensions contains rowdimension objects and column_dimensions contains columndimension objects in row_dimensionsyou can access one of the objects using the number of the row (in this case or in column_dimensionsyou can access one of the objects using the letter of the column (in this casea or bthe dimensions xlsx spreadsheet looks like figure - figure - row and column set to larger heights and widths once you have the rowdimension objectyou can set its height once you have the columndimension objectyou can set its width the row height can be set to an integer or float value between and this value represents the height measured in pointswhere one point equals / of an inch the default row height is the column width can be set to an integer or float value between and this value represents the number of characters at the default font size ( pointthat can be displayed in the cell the default column width is characters columns with widths of or rows with heights of are hidden from the user working with excel spreadsheets