Filling In Every Blank

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You do realize that an entire column in xl2007 has one million rows?
Select the cells, press the "." key, hold down the C'trl key and press the
Enter key. That works in the earlier versions, of course MS may have
"improved" things.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Rebecca" <[email protected]>
wrote in message
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.
 
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
 
It was pretty fast, at least as fast as filling 65536 cells in previous
versions

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 
I wasn't even sure that xl2007 had column headings.
With 1mm rows there has to be tradeoffs.
As somebody once said...
"Never be first with the newest or last with the oldest."

Regards,
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html



"Peo Sjoblom" <peo.sjoblom@nw^^excelsolutions.com>
wrote in message
It was pretty fast, at least as fast as filling 65536 cells in previous
versions
Regards,
Peo Sjoblom
Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 
Back
Top