PAPERLESS CONSTRUCT
  • Home
  • Need
  • 3-Steps
    • 1 - Stop Producing
    • 2 - Stop Receiving
    • 3 - Stop Collecting
  • Tech Tips
  • About
    • My Resources

Tech Tips

Get Better EveryDay

Tech Tip Tuesday - Excel - Stop Jumping

3/6/2018

1 Comment

 
Have you ever been working in excel file with multiple tabs, and you have to reference multiple tabs for a report.  
Picture
Most of us, just constantly flip back and forth between two or three tabs, spending more jumping between tabs than actually digesting the data in the excel file. Well there is a really simple way to reduce this switching back and forth by opening the same excel file in multiple windows.

Simply click view > New Window
Picture
This will open a new window of the same excel that can be dragged over to another screen. You know that you have multiple windows open because there is a "1" or "2" next to the file name.
Another cool feature is that when you close the file (file > close) and reopen it, Excel remembers you are using multiple windows. Note: this is not a new instance of excel. Therefore if you update data or a formula that is referenced on another tab, it will update throughout all windows.

As always reach out if you have a questions,
Keep Advancing,
​Ralph
 
1 Comment
Stacy Wilson Bus Crime Scene Photos link
9/9/2021 05:40:59 am

Your article is very useful and good in writing so thanks for sharing your views .
with us.

Reply



Leave a Reply.

    Author

    Ralph Kreider strives to help make the construction industry more effective.

    Archives

    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    July 2017
    June 2017

    Categories

    All
    Bluebeam
    Excel
    Outlook
    Skype For Business
    Windows
    Word

    RSS Feed

    View my profile on LinkedIn
  • Home
  • Need
  • 3-Steps
    • 1 - Stop Producing
    • 2 - Stop Receiving
    • 3 - Stop Collecting
  • Tech Tips
  • About
    • My Resources