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)
[Source: http://blog.contextures.com/archives/2011/08/31/quickly-copy-excel-formula-down/]
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)
[Source: http://blog.contextures.com/archives/2011/08/31/quickly-copy-excel-formula-down/]
No comments:
Post a Comment