How to turn on View Side by Side Sheet option in Microsoft Excel
I am using Excel 2007. Want to see two sheets in same workbook. Help tells me how to do it with the "View Side by Side" option, but that option is grayed out for me. Help nicely notes that this function works only when the "View Side by Side" option is turned on, but doesn't tell me how to turn it on!
Re: How to turn on View Side by Side Sheet option in Microsoft Excel
Open two workbooks > (will enable the 'View Side by side' option). Now click on the option. (If this do not work click on the 'Restore down' button once and try again). If you want to compare the sheets of same workbook (right click the sheet tab> create a copy).
Re: How to turn on View Side by Side Sheet option in Microsoft Excel
I re-read Help and realized I had skipped a step - opening the new window. Now everything works as expected. This is not a tough job. If you cannot find anything just follow the help below.
View two or more worksheets at the same time