Discussion on:
View:
Show:
I frequently copy expressions down many rows, and thought I was doing it efficiently - until I read this tip. This tip was excellent.
Handy thing to know, but I don't understand the point of step 2, pressing [Ctrl][Enter]. It works without doing that.
What ctrl-Enter does is keep you in the same cell (and not go down to the cell below) - it actually save you having to arrow back up to the previous cell.
I alway show the "double-click on fill handle" method of copying formulas to my students - it is a lfe saver for large documents.
I alway show the "double-click on fill handle" method of copying formulas to my students - it is a lfe saver for large documents.
The thing I found fascinating about this tip was that it was a replacement for a method of entering formulas which I was not familiar with previously. The Select cells/Ctrl-Enter method might work well for people who have trouble with double-clicking on the fill handle (I am a trainer and a number of my students find this challenging). It is always nice to discover an alternative method of doing something.
i would like to change no of stations by changeing the formula, can i know how to change
300+20.200 to 30+020.200.
Thanks and regards
300+20.200 to 30+020.200.
Thanks and regards
Very Very Handy - Excellent Tip !
Thanks a lot !
Thanks a lot !
The tip is excellent indeed because it reminds us that double-clicking the fill handle does the job (no need to [Ctrl][Enter], just [Enter] as usual in step 2)
This tip doesn't work for more complicated formulas. A better way for me is to copy the original formula, type where you want it to go in the name box and then paste it. For example if my formula is in cell M1 I select that cell and press Ctrl+C. Then if I want to copy it to M2 to M15 I put M2:M15 in the name box and press Ctrl+V. Also only three steps and much more flexible than the original tip.
how we use formula for 300+20.2 to 30+020.2
- Keyboard Shortcuts:
- Prev
- Next
- Toggle
