you can see Column A and Line 1 at the top left of both), if this button is showing in yellow, scrolling in one spreadsheet (the active one has the scroll bar) will move the other spreadsheet up and down or left and right at the same time: This is a really useful function – if you have both spreadsheets lined up to start with (i.e. You can see that the Synchronous Scrolling button is highlighted in the image above. If you have two spreadsheets open in, say, Excel 2010 (from which these screenshots are taken, but the process is the same for Excel 2007, 20), pressing this button will show you both spreadsheets, one above the other (this always reminds me of playing competitive driving games on the games console): In the View tab, you’ll find a button labelled View Side by Side. We’re going to look at the View tab here. The quick way to view two spreadsheets side by side And next week I’ll show you how you can view two sheets from one workbook side by side. I’m going to show you how you can view both (or even lots of) spreadsheets on the same screen, in various arrangements, and then return to viewing only one. Move Spreadsheet 2 across to the right and Spreadsheet 1 will follow it.
… and the other one moves to sit underneath it, inaccessible and impossible to view at the same time as, say, Spreadsheet 1: … and end up with two documents next to each other (you can, of course, move the boundary between them to make one bigger and one smaller):īut, if you’ve ever tried to do this with two Excel spreadsheets, you’ll have found that you move one over … If you’re used to working with Word, you’ll know that if you have two Word documents open in any version of Word, you can pick them both up by the top bar (I usually do it near to the name of the document), slide them across to the left and right until they ping back and fill half of the screen … Why can’t I view two Excel files on the same screen? The problem doesn’t exist in Excel 2013 as you can move spreadsheets around just like you can in Word, however the options still exist for arranging your multiple views (thanks to Alison Lees for pointing out the resolution of the problem).
Search multiple excel files at once how to#
Next week, we’re looking at how to view two sheets from the same workbook side by side, too! This article is valid for Excel 2007, Excel 2010 and Excel 2013 to some extent. This article explains how you can view two Excel spreadsheets next to each other on your screen and compare the two spreadsheets easily (or more, if you want!). In Word, it’s easy to line up two separate documents side by side to look at them both. You’re looking at a spreadsheet and you want to compare it to another one.
0 kommentar(er)
