Saturday, November 17, 2012

Excel Tricks

Keep the header row displayed when scrolling down a large sheet

 Assume that you have a large table that you need to scroll to the bottom and at some point the header row disappears. The solution is to click just below the header row and from Window menu select Freeze Pane. Now the header row will be visible throughout the scrolling.


-
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Continuously monitor GPU usage

 For nvidia GPUs do the follwing: nvidia-smi -l 1

  • Invalid annotation object error in PDFs
    If you used Adobe acrobat to annotate a PDF file and you had Acrobat crashed or had to restart the computer abruptly during the annotation p...
  • TexShop MacTex US letter PDFs
    By default when you install MacTex and use TexShop for writing and compiling latex you will get PDFs with page size A4. This is all fine for...
  • Anaphora Cataphora and Co-refernce
    These three terms are explained below. Anaphora is a back ward reference. Ex: I gave a banana to the monkey which it ate. Here "it"...