[Solved] Formatting issue in excel

[mfaisal.ce]

Dear,

I have a file with multiple sheets more than 100. I want same formatting and page size in all Means i want to print all but there are many sheets which are printing empty sheets as shown below.




i need format like below




Can you please help in doing this formatting for all sheets at same time becasue indivisually it will take hours. Moreover, also share the method.

Excel file is attached for rectification.

regards,

 

[mfaisal.ce]

File attached

 

[shamimarita]

Hello Faisal,

It seems the user is facing an issue with formatting and printing multiple Excel sheets simultaneously.
To apply the same formatting across all sheets, s

• Select all sheets >> right-click any sheet tab >> choose Select All Sheets.

Make formatting adjustments on the active sheet, which will be applied across all selected sheets.
For printing, check under Print Settings to ensure that each sheet's print area is set and that blank sheets are excluded.