Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Fill down destination
Name: babbage00 Date: April 7, 2004 at 18:43:29 Pacific OS: w98 CPU/Ram: 900 /256
Comment:
does anyone know a way to fill down to a certain cell w/o dragging.
situation: i am in cell a27 and i want to fill a formula that adds .01 to the previous cell all the way down to cell a1027....... tell me there is an easier way than dragging?
Name: Report_2 Date: April 7, 2004 at 22:37:48 Pacific
Reply:
If there are no empty cells in the range of A27:A1027 then wave over the bottom right hand corner of A27 so that you see the Black Crosshairs icon and then double click on it to envoke the Autofill function or
If there are no empty cells in the adjacent column down to B1027 then it will work or
Place any data in A1027 just to fill the cell. Then place your formula in A27, hit enter.
Right click on A27 and select Copy.
Then hit Ctrl+Shift+down arrow to select the column down to A1027 (last filled cell) and
then hit the Enter key to copy the formula into all of those cells.
Summary: Can anyone tell me how to enter 01/001 in a cell and fill down so that the next will be 01/002 and so on. Need help otherwide I need to type it out hundreds of time. ...
Summary: Hi Jennifer, Yes it is excel, 2000 pro, the format used is Custom and dd-mm-yy. if I select the first of the month, say 01.04.04 and try to fill down by draging, the next date shows as 01.04.05. so th...
Summary: Here's an example I'd use to see if I'm correct with what you are asking: A B C D E Total Name2 43 27 48 100 Name3 45 30 41 88 Name4 etc. etc. etc. ...
0 
Outlook Signatures
