In this example, Cell address C351 is selected as shown in below image. The selected Cell will become the top-left corner Cell of the bottom-right pane, after Excel split the worksheet window into four Split Panes. Step 1 - Select the Cell where you want to split the Excel worksheet window to four panes horizontally and vertically. To split an Excel worksheet horizontally and vertically into four Split Panes, follow below steps. When you split Excel worksheet window into horizontally and vertically, you split Excel worksheet window into four Split Panes. When you split Excel worksheet window horizontally or when you split Excel worksheet window vertically, you split Excel worksheet window into two Split Panes. You can split Excel worksheet window into two or four Panes. Each Pane has separate scrollbar, so that you can scroll them separately. Once the active worksheet is split into different panes, you can compare different areas of worksheet by scrolling horizontally or vertically. There is a feature in Excel, which allows you to split the active worksheet into Split Panes horizontally or vertically. If the worksheet is too large, it is not possible to view different areas of the worksheet at the same time by zooming out the worksheet. When you are working in a very large Excel worksheet, sometimes you may want to view different areas of the worksheet at the same time.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |