Learn how to setup Excel to view two sheets side-by-side in the same workbook using the New Window feature. This technique is great for writing formulas, copying and pasting data, or comparing two or more sheets. It saves time from having to navigate between two tabs that are not close to each other in the workbook.
I explain shortcuts to setup the split screen view, and how to use Synchronous Scrolling to visually compare two different sheets with similar data.
Read the full blog post:
Additional resources:
View Multiple Windows in Split Screen View:
5 Keyboard shortcuts to Paste Values in Excel:
Shortcuts for Pasting Values with the Mouse:
Nguồn: https://bus-rush.info/
Xem thêm bài viết khác: https://bus-rush.info/cong-nghe/
Perfect thanks sir !!
is it working on mac ?
life saver
thanks
ok – did not know about this and love it.
Thank you for this useful video!
Is it possible to view two sheets side-by-side inside same app window (old style Office 2010 view, without having toolbars for each sheet)? Thanks
Thank you so much. Really helpful and the first video that came up in a Bing search.
OK, now do one where you save two workbooks at the same time while continuing to work on a 3rd. Other than as legacy-ware why is this atrocity still a valid business tool?
How about this, do one where you have multiple panes open for various data sources and intersperse the excel panes in between the data sources so that you don't have to go looking for the right sheet.
Ty for this!
Thanks, sir.
Thanks It's realy Helpful
This is definitely a game changer. Really wanted this feature for a while. Thank you for the quick video.
Thank you Sir!
AWESOME, THANK YOU JON!!!!
Wish I had googled this years ago!! Thanks for the great help.
Excellent tip! Thanks
I can't tell you how many times I have used a screen copy to do this. Thank you for this short but useful video!
Thank you! Very useful information and easy to follow instructions.
very very useful
Did not know about such possibility. But this is very helpful! Thank you!
Thanks for sharing this.