Excel 2024: New Scrolling Tricks
December 25, 2024 - by Bill Jelen
Excel now offers horizontal scrolling and smooth scrolling. To scroll with the mouse wheel:
- Spin the mouse wheel to scroll vertically through the grid
- Ctrl+Spin the mouse wheel to change the Zoom level.
- Ctrl+Shift+Spin the mouse wheel to scroll horizontally. This functionality was added to Microsoft 365 during 2021.
Smooth scrolling is a popular improvement, particularly for people who store a lot of text in a cell. Before Smooth scrolling, the following worksheet could be scrolled to show "In B2 and B3" or "In B4 and B5" at the top of the worksheet. There was no way to leave Excel parked with half of row 1 scrolled off the screen.
Now, with Smooth Scrolling, you can scroll part way through a cell. In the figure below, you can see that half of cell A1 is scrolled out of view.
You could even scroll sideways and have part of the column visible.
Note: By default, when you scroll with the mouse wheel, it jumps three lines a a time. Visit the Control Panel and search for Scrolling to find these settings.
This article is an excerpt from MrExcel 2024 Igniting Excel
Title photo by Hana Banacka on Unsplash