Microsoft Excel 51 Splitting the Worksheet View

SimpleTutorials

Microsoft Excel is a powerful spreadsheet application used for organizing, analyzing, and visualizing data. In this course, you will learn the essential skills you need to get started and become confident in using Excel.  In this video lesson, we will learn about Splitting the Worksheet View in Microsoft Excel  You can access the entire Microsoft Excel Course in the following playlist: https://www.dailymotion.com/playlist/xa9hyw

Transcript

00:00So over here, you can see that I have a long inventory list, but let's say I want to go ahead

00:10and view certain portion and other portion together. In that case, what I can actually do

00:14is I can go ahead and split out the work seat view. So I can click on a cell point where I want

00:20the view to be divided from right here, and then I can go ahead over here onto view and then click

00:27on split. Once you do that, over here, you can see that this point has been taken as the split area

00:33and you can go ahead and use the scroll right here on either side. So you can see that I can go ahead

00:39and see four views of the same document. I can similarly go on to certain section right here,

00:45remove the split, add it again to have split like this. You can even go around over here and then

00:51you can also go around over here, remove the split, add the split right here just like this to rearrange

00:56it out as you like. So that is how you can go ahead and then split the work seat view inside of

01:03Microsoft Excel. So if you found this video useful, be sure to hit the like button. Don't forget to

01:09share this app with your friends and family. And for more contents like these, do follow simple tutorials.

Category

Transcript

Be the first to comment

Recommended