The ability to move columns in Excel is a great benefit when dealing with long strands of data in Excel. Here's how to do it.
Restoring the drag-and-drop menu in your Excel Pivot Table is typically a quick fix. By using either right-click options or ribbon commands, you can easily access the field list again. If all else ...
You can freeze a row in Excel through the "Freeze Panes" menu. This lets you scroll through a spreadsheet without that frozen data leaving the screen.