Here is a problem I have latly,
I am using Databases of over 30,000 rows, now , somtimes i want to write a formula for each cell, ofcourse I can do Draggdown, how ever for few hundreds rows it can be just fine , but for 30,000 it takes long time with just sitting with my finger on the mouse butten...
is there more simple way to do it ?
Thank you!
Hover the cursor over the right hand corner of the formula cell. It should change to cross hairs (+), then double click
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Its not what i ment...
I know how to drag...... but i want to drag it without having to drag 30000 cells....
i am looking for more si,ple way to drag this cells.
That's what happens, double click & the formula will copy to the last row of data
Ohhh!! now i understand , Sorry
Thank you very much!
No problem. It's a handy little trick
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks