Home > Documents > Excel > Where is Split Panes in Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365

 

Where is Split Panes in Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365?

• Find the feautre on Classic Menu
• Find the feature on Ribbon interface

Excel provides a function which will split your worksheet into independent panes so as to view and edit data easily. You can split the worksheet horizontally or vertically. One question is, when upgrading the Office from 2003 version to 2007, 2010, 2013, 2016, 2019 and 365, many users find it hard to get this function. They do not know where to find out the option. The topic here discusses two ways to get the Split Panes function, and hope it can help.

Now let’s see where the Split is in Excel 2007/2010/2013.

Find the feautre on Classic Menu

Just take Microsoft Excel 2010 for example, which is similar as in Excel 2007/2013. With Classic Menu for Excel 2007/2010/2013/2016/2019 installed, you can click Menus tab to get back the classic style interface.

• On Menus tab, click Window menu

• Choose the Split in the menu

---

If you have not Classic Menu for Excel 2007/2010/2013/2016/2019 installed, you can …

• Click View tab

• Move to Window group

• Click the Split button

---

More Related Articles...

• Where is Conditional Formatting
• Where is Page Setup
• Where is Tools Menu
• Where is Undo
• Where is Macro
• Where are Pivot Table and PivotChart Wizard
• Where is Print Preview
• Where is Help Button
• Where is Goal Seek
• Where is Edit Menu
• Where is Decrease Decimal Button
• Where is Specify Decimal Place

Classic Menu for Office

Brings the familiar classic menus and toolbars back to Microsoft Office 2007, 2010, 2013, 2016, 2019 and 365. You can use Office 2007/2010/2013/2016 immediately without any training. Supports all languages, and all new commands of 2007, 2010, 2013, 2016, 2019 and 365 have been added into the classic interface.

		Classic Menu for Office It includes Classic Menu for Word, Excel, PowerPoint, OneNote, Outlook, Publisher, Access, InfoPath, Visio and Project 2010, 2013, 2016, 2019 and 365.
		Classic Menu for Office 2007 It includes Classic Menu for Word, Excel, PowerPoint, Access and Outlook 2007.

Screen Shot of Classic Menu for Excel