From the course: Excel Essential Training (Microsoft 365)
Join today to access over 24,400 courses taught by industry experts.
Splitting screens horizontally and vertically - Microsoft Excel Tutorial
From the course: Excel Essential Training (Microsoft 365)
Splitting screens horizontally and vertically
- [Instructor] When you work with large lists, you might want to see different portions of that list at the same time. Now, we could hide rows, we could hide columns, but a feature that could be overlooked is one called Split. You can split the screen either vertically or horizontally, and then scroll independently on either side of that split. So on this worksheet, which is over 700 rows or so, I want to split the screen horizontally, and the reason is I want to see different people from different departments, even though they're not close together in the list. I don't want to be sorting the data either. So, somewhat arbitrarily, in column A, about halfway down or so, makes no difference where really, I'll click on a cell. And then, on the View tab in the ribbon off to the right, you'll see the word Split, and that introduces a horizontal line, dark gray, right here. I can click and drag to move it up or down if necessary, but I'll leave it right there for now. As I click below the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
