Remember that when dragging and dropping you holdĭown the CTRL key to copy the selection (notice the small plus Really cool is that you can easily drag and drop from one window Now that you've got both working areas in view, you can easilyĬut, copy, past, move and much more between the windows. ' Windows of active workbook' and click OK. Window, Arrange, select Tiled and put a check mark in Now, to get both of these windows in the same view, select.In the second window browse to the other sheet and range that you want to work with.Is a number following the filename indicating which window it is. You will notice in the Title Bar of the window there Open a new window of the same workbook by clicking Window, New.Go to the first sheet and range that you want to work with.The trick is to get both of these windows in But even working between two windowsĭoesn't help much. It may look likeĪnother workbook but actually it is just another view With virtually no switching back and forth.Įxcel allows you to open a new window of your workbook. Separate parts of your workbook at the same time, but to easily work between them I have a solution that will allow you, not only to see two Tedious switching between sheets, especially if you need to do it To work back and forth between two sheets. Let's assume you have a workbook with several sheets and you want The same time? I have a great tip that will let you do just that. Sometimes you may wish that you could see two parts of your "Helping Average Spreadsheet Users Become Local Spreadsheet Experts" FREE Microsoft Excel Spreadsheet Tips and Tutorials
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |