If the worksheets that you want to view are in the same workbook, do the following:.Open the workbook or workbooks that contain the worksheets that you want to view at the same time.View multiple worksheets at the same time In each workbook window, click the sheet that you want to compare.In this dialog box, under Compare Side by Side with, click the workbook that contains the worksheet that you want to compare with your active worksheet, and then click OK. Note If you keep more than two workbooks open, Excel displays the Compare Side by Side dialog box. On the View tab, in the Window group, click View Side by Side.Open both of the workbooks that contain the worksheets that you want to compare.View two worksheets of different workbooks side by side To restore a workbook window to full size, click Maximize at the upper-right corner of the workbook window.If you resize the workbook windows for optimal viewing, you can click Reset Window Position to return to the original settings.Note This option is available only when View Side by Side is turned on. To scroll both worksheets at the same time, click Synchronous Scrolling in the Window group on the View tab.In the workbook window, click the worksheets that you want to compare.On the View tab, in the Window group, click New Window.Knowledge is power - if you don't know what's available you can miss an opportunity or spend hours trying to jury-rig a solution by cobbling together other functions.View two worksheets in the same workbook side by side in Excel 2007, 2010, 2013 & 2016 You can't add these to any favourites list but you can make your own 'Check these out' list Similarly, open the Function Wizard window and check out the functions available (made easier bc you can do so by category).

If so, add it to your QAT and try it out.Ģ. open the Customize Quick Access Toolbar window and just scroll through the list of commands available (Note: some are only available thru customisation as they are not on the inbuilt menu!) and see what each tool does and whether it may be useful to you. I'm from the same era: Learned 123 in 1984/85 from a 5.25' floppy tutorial, & Multiplan, then progressed thru Symphony, Supercalc, back to 123, and then Excel 4 & 5 in 1995 - and have never looked back! That's the beauty and ugliness of Excel - there are more tools & features than you can ever learn or know about!

Office 365 mac excel merge workbooks