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.
excel 2000 auto fill
Name: forare Date: May 11, 2005 at 00:23:14 Pacific OS: win2k CPU/Ram: 2.4/512
Comment:
am looking for a way to auto fill values in a column in a way to copy the above cell into the next empty ones under it.
example i need to fill cell b21,b22,b24 exactly as same data as in b20 (b21,b22,b24 are already empy)
Name: Bryco Date: May 11, 2005 at 03:36:18 Pacific
Reply:
Should B24 contain the data that is found in B23 versus B20? If yes, then it can be done easily. If no, then I don't know how to make it happen as you wish.
Regards, Bryan
0
Response Number 2
Name: forare Date: May 11, 2005 at 03:42:20 Pacific
Reply:
yes can you please tell me how
0
Response Number 3
Name: Bryco Date: May 11, 2005 at 05:46:29 Pacific
Reply:
Select all the data in Column B (as this is the data you want to work with).
Go to Edit, Go To, Special, Blanks.
Hit = and the Up Arrow key and then hit Ctrl+Enter key.
This will fill all blank cells with the value of the cell above it.
HTH Bryan
0
Response Number 4
Name: Bryco Date: May 11, 2005 at 05:49:34 Pacific
Reply:
If you don't want to retain the formula in those cells then right click on column B and select Copy; right click on it again and select Paste Special, Data.
If you wanted to do this for the entire sheet and not just Column B then select A1 and then hit Ctrl+Shift+End to select all the active cells in your worksheet and then go to Edit...
Regards, Bryan
0
Response Number 5
Name: callan1 Date: May 11, 2005 at 08:24:34 Pacific
Reply:
Excellent tip - thanks Bryan! That will come in handy.
Summary: We have quite a few users that access our software through Citrix Wframe. We also have an add-in for Excel that will pull data out of our software program. Users do not have this software or add-in ...
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...
0 
