Monthly Archives: October 2012

Using Freeze Panes in Excel Spreadsheets

When you are working on a spreadsheet, it can be really irritating if your column titles disappear off the top of the page as you scroll down.

To keep column titles in view all the time, use Freeze Panes.

Click on the view tab to get the Freeze Panes option, and click on the little arrow next to it. You have three choices – to freeze the top row, freeze the first column (useful if you are scrolling off to the right), or Freeze Panes.  If you click in to a cell, then choose Freeze Panes, the rows above that cell and the columns to the left of that cell will remain in view all the time while the rest of the spreadsheet scrolls.

Tidy up – empty the recycling bin, and defrag the disk

When you delete something, it goes in to the recycling bin; it doesn’t actually get deleted until you empty the recycling bin.  If you delete something by mistake, you can recover it from the recycling bin before you empty it.

To recover something from the bin, right click on the Recycle Bin icon with the mouse, then choose Open, select the item you want to keep, and choose Restore.

To empty the bin, right click on the Recycle Bin icon with the mouse, then choose Empty Recycle Bin, it will ask if you’re sure, say yes.

Every so often it is a good idea to defrag the disk, especially after you’ve deleted a lot of stuff.  (When you are using your PC, the free memory space gets fragmented over time, and this can slow things down a bit.  When you do a defragment all the free memory space is tidied up.)

To defrag the disk, go to the control panel (from the Start menu) and choose System and Security, then Administrative Tools, then Defragment Your Hard Drive.
A new window opens, showing the status of the hard disk – if it is very fragmented, then choose the Defragment Disk button.
Now sit back and let it get on with it!