Tips:. To remove the panes, on the Window menu, click Remove Split, or drag the split bar back to the edge of the window. You cannot split a sheet and freeze parts of that sheet at the same time. View multiple sheets in one workbook. Open the workbook that you want to view.
On the Window menu, click New Window. Switch to the new window, and then click the tab for the sheet that you want to view. Repeat steps 2 and 3 for each sheet that you want to view. On the Window menu, click Arrange. Do one of the following: To arrange windows So that they appear like this Click As equally sized, tiled squares Tiled Horizontally from top to bottom Horizontal Vertically from right to left Vertical In an overlapping cascade from top to bottom Cascade. Select the Windows of active workbook check box. View multiple workbooks.
Open all the workbooks that you want to view. On the Window menu, click Arrange. Do one of the following: To arrange windows So that they appear like this Click As equally sized, tiled squares Tiled Horizontally from top to bottom Horizontal Vertically from right to left Vertical In an overlapping cascade from top to bottom Cascade.
You can access the VBA environment in Excel 2011 for Mac by opening the Visual Basic editor. First, be sure that the Developer tab is visible in the toolbar in Excel. The Developer tab is the toolbar that has the buttons to open the VBA editor and create Form Controls like buttons, checkboxes, etc.
Apple's line of Mac computers come with the OS X operating system, which does not include basic Windows applications such as Microsoft Office. Apple's word processor is called Pages and comes with the Mac, but you must purchase iWork to use it. IWork also includes Numbers, which is Apple's equivalent of Excel, and Keynote, which is comparable to PowerPoint. IWork applications allow you to export your documents to Windows format and open Windows formatted files, such as Word documents, on your Mac.
Microsoft Office is also available for Mac, in which case you can open any Office document format. If you haven't bought iWork or Microsoft Office for Mac, you can use Apple's TextEdit application or download a free office software package such as OpenOffice.