How to Auto-Fit active screen to fit all sizes of screens

[skf786]

Hi,

I have an opening 'Home' sheet of my dashboards that I made to exactly fit the screen (Cells A1 to M22). im working on my 14" screen laptop. when I shared the file with my boss who opened it on his gigantic desktop screen, we could see the cells to the right and bottom of my opening page i.e. columns N,O and P and Rows 23, 24...30.

is there a way to autofit the opening sheet to stretch and fit in any screen size?

thank you

Khalid

 

[RedBeard]

This might be of use: How to Fit Your Excel Spreadsheet to Your Screen
Perhaps this: https://www.excelcampus.com/vba/resize-dashboards-for-screen-sizes/
Maybe this: [Solved] VBA: Autofit workbook to fit user's screen