Freeze Panes in Excel solves this problem completely. It locks specific rows and columns in place so they remain visible no matter where you scroll. To set it up, go to the View t ...

Q. Hi, Jim. I work in Excel spreadsheets a lot. Is there a shortcut to changing the direction of the next cell where data is entered? Sometimes I need it to move laterally across the page and other ...

I love productivity systems and apps and lately I’ve developed my own, which requires only a regular spreadsheet–Excel or Google docs will do–and it’s easier and more effective than any I’ve tried. It ...

You’d think stock traders, of all people, would have the best data available. But that wasn’t the case when JPMorgan started bleeding billions on bad trades. Investors got worried. The bank dismissed ...

I am working on a spreadsheet and the values I wasn't sure about I put question marks in so I could fill them in later. Now I want to go back and find them all but I can't figure out how to search for ...

Have you ever found yourself buried under a mountain of Excel spreadsheets, each more complex than the last, and wished for a way to streamline your data management? You’re not alone. Many rely on ...

Microsoft Excel makes it easy to import data from other sources, such as Access and Oracle databases. Doing so, however, may result in poorly formatted data that is difficult to analyze, sort or ...