Limiting viewable or scrollable worksheet size - Microsoft Community

i'm using excel mac 2017.  is there way define size of worksheet.

i'm not referring set print area.    i mean when open excel worksheet

we see active part of worksheet, , not unused rows , columns.

thanks advice.

can following -

1. size of range a1:f78.
2. select column next last column in range. hence, select column g.
3. control (or command) + shift + right arrow select remaining columns
4. right click on column , hide.
5. select row next last row.
6. hence, select row 79.
7. control (or command) + shift + down arrow select remaining rows
8. right click on row , hide

left sheet size.

if want revert -

1. control (or command) + select entire sheet.
2. right click on row , unhide
3. right click on column , unhide

Office / Excel / Mac / Office 2016 for Mac