Wednesday, April 27, 2016

Drag down a formula to the end of sheet in MS Excel

After spending a decade in the Linux/Unix environment I am increasingly finding myself using MS tools at work - especially Excel. Before I get around to posting about Macros and Pivot Tables I wanted to document as much mouse-free experience as possible. This post is about mouse-free dragging of a formula across the sheet.

1. Ctrl+Down will tell you the last row in the sheet.
2. Select cell with the formula
3. In the Name box enter the column alphabet:row start to end (d2:d2000 for example)
4. Hit enter
5. Ctrl+D for (drag till end)

fillhandle01
[Source: http://blog.contextures.com/archives/2011/08/31/quickly-copy-excel-formula-down/]

fillhandle02