Forum Discussion
CoxyTJW
Feb 23, 2026Copper Contributor
Copying column widths and row heights from one sheet to another
Hello everyone. I have to reformat a rubbish PDF i get sent everyday so i can make it legible. i have arranged the cell widths and heights and cut and pasted the data but there are 14 columns and as ...
Olufemi7
Feb 26, 2026Iron Contributor
HelloCoxyTJW,
Yes. You do not need to manually resize columns and rows each day. The simplest solution is to create one sheet formatted exactly as required with the correct column widths and row heights, then copy that sheet each day and paste your new data into it so the layout remains consistent. Alternatively, save the formatted workbook as an Excel template (.xltx) and use it daily. If you prefer automation, you can use a short VBA macro to copy column widths and formats from a template sheet to your working sheet. Keeping one clean template sheet and reusing it daily is the most efficient and maintainable approach.