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
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
Comments
Post a Comment