LinkBack URL
About LinkBacks
Hi All,
I have a column of 20,000 cell. I need to fill it out with the same value which is ( Number 1). Is there any way to do that through Excel?
Hi All,
I have a column of 20,000 cell. I need to fill it out with the same value which is ( Number 1). Is there any way to do that through Excel?
In the Names box (left of the formula bar), enter A1:A20000. That will select all of those cells.
Enter 1 in the formula bar, press and hold the Ctrl key, then press Enter.
Entia non sunt multiplicanda sine necessitate
Great tip, shg, now - if only I can remember that
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks