To make all cells the same size in Excel and Google Sheets, select all the columns/row and then click on the Format tool to change the Column width or Row height.

How to lock cells in Excel Open the Excel workbook and select all cells in the worksheet with the cells you want to lock by pressing the Ctrl + A buttons on your keyboard.

To clear formatting from the selected cells in your workbook in Microsoft Excel, you can use Clear Formats, Keyboard shortcuts, Format Painter tool, etc.