How-To Geek on MSN
How to use Watch Window in Excel to track key formulas and their results
Track key cells across sheets and workbooks without switching tabs, keeping your most important data always in view.
Microsoft Excel allows you to split the Excel window into separate panes on the same worksheet. This allows you to work on different areas of a spreadsheet without having to scroll between them or ...
How-To Geek on MSN
I stopped freezing panes in Excel. These tools work better
Stop sacrificing screen space—Excel tables, Watch Window, Focus Cell, and split views keep context without locking rows.
I sometimes work on multiple Excel docs. The problem is, they all open in one window so I can't have them side by side. Is there a way to make them work more like, well, almost any other document ...
Excel puts lots of great tools on your desktop, but what each one of them does isn’t always obvious, especially since so many Excel features are hidden. Would you like to create multiple lines of text ...
Q Every now and then the tabs at the bottom of an Excel workbook disappear. I don’t know what I did to cause that to happen, and I can’t figure out how to get the tabs to reappear. Please help. A Any ...
If you work with multiple Excel files over the course of a workday, and especially if you use a dual-monitor setup, you might wonder how you can launch each Excel file in its own window so you can ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results