From the course: Excel Essential Training (Microsoft 365)
Join today to access over 23,200 courses taught by industry experts.
Splitting screens horizontally and vertically
From the course: Excel Essential Training (Microsoft 365)
Splitting screens horizontally and vertically
- [Instructor] On this worksheet called Split Screen, imagine that we'd like to see people from a certain training department and also people from another training department. This list is sorted by department name but the two lists that we're trying to view at the same time are not next to one another. Now, possibly we could be using a filter or maybe we could hide all the rows between the two but it might work best if we simply split the screen and you can split the screen either horizontally or vertically and as we'll see a bit later, even both ways. So let's imagine that we'd like to have a horizontal line across the screen roughly halfway down. Let's click over in column A, row eight, row nine. It doesn't have to be perfect. It makes no difference really. More or less halfway down the screen. And then on the View tab in the ribbon, we want to click Split and a horizontal line is introduced. We see it right here, but even…
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.