View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Ron Coderre
 
Posts: n/a
Default Filling In Every Blank

Kind of an odd thing to do, but....here goes:

If the entire column is blank,
Select the entire column (click on the column heading to do that)
Type a period
Hold down the [ctrl] key and press [enter]

That will fill the column with periods (.)

OR
If there are some cells with values and you want periods in the blank cells,
Select the entire column (same way as above)

From the Excel main menu:
<edit<goto
Click the [special cells] button
Check: Blanks
Click the [OK] button (that will select the blanks)
Type a period
Hold down the [ctrl] key and press [enter]

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Rebecca" wrote:

Greetings. I am using Excel 2007 (beta), and I can't find this information
by myself, so I am asking the experts in this discussion group for help.
Could you please tell me how I can fill in all the empty blanks in an empty
column with a period ( a ".")? The entire column, to repeat, is completely
empty. And because I am a new user, could you please explain the procedure in
easy English, step-by-step? Thank you very much.