Stop sacrificing screen space—Excel tables, Watch Window, Focus Cell, and split views keep context without locking rows.

Impress your coworkers with these nifty tricks.

With Microsoft's introduction of Excel 2007, users had to abandon their previous habits and relearn Excel's menu structure. The familiar menu bar vanished in lieu of the "ribbon," which categorizes ...