Resize Excel scroll bar to smaller sized spreadsheet

Опубликовано: 12 Октябрь 2024
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting

25,684

How to reset your Excel scroll bars so that their size makes more sense and does not seem to indicate that it is a massive spreadsheet.
------------------------------------------------------------------------------------------------------------------------------------------------------

✅- Free check of your Excel Skill Level- https://excel-skills-assessment.com/s...
🏅- Test employee Excel skill levels- https://excel-skills-assessment.com/e...
🏆- Improve you Excel Skill Levels- https://online-excel-training.auditex...
🇿🇦- Our main website- https://www.auditexcel.co.za/blogs/

------------------------------------------------------------------------------------------------------------------------------------------------------
⏲Time Stamps
00:00 Scroll bar is too big implying spreadsheet is bigger than is
00:20 Find the last cell Excel sees as active
00:45 Remove the unnecessary cell (1 option)
00:55 Remove all columns/ rows that you see as unnecessary in one go (RECOMMENDED)
01:09 You need to Save, Close, Re-Open to see the reset scroll bar