Skip to main content

Excel Tricks

In this post we document some of the Excel tricks which you might find useful.


How to copy a formula to a range of cells
http://superuser.com/questions/180345/apply-formula-to-a-range-of-cells-without-drag-and-drop


  • First put your formula in F1.
  • Now hit ctrl+C to copy your formula.
  • Hit left, so E1 is selected.
  • Now hit Ctrl+Down. This will travel all the way down until a blank is hit, in this example its E20000.
  • Now hit right so F20000 is selected.
  • Now hit ctrl+shift+up. Now you will be selecting F1:F20000.
  • Finally either hit ctrl+V or just hit enter to fill the cells.

Comments

Popular posts from this blog

Advantages and Disadvantages of Electro-oculography (EOG)

In the previous post we looked at what is EOG? In this post we will look at the advantages and disadvantages of EOG.

How to Convert Excel Charts into High Resolution Images

Microsoft Excel is widely used to generate graphs and to analyse data due to its simple graphical user interface. Have you ever tried to convert the charts into images? If yes, you might have used "Print Screen" feature to easily convert the charts into images. However most of the scientific journals require the images in high resolution TIFF format. So in this post we will look at how to convert Microsoft Excel Charts/Graphs easily into high resolution images.

Online Radio Stations

Some of the popular Tamil radio stations are listed here. You can listen to those radios here.