Filling up a column with the same value

L

laredotornado

Hi,

I'm using Excel 2008 for the Mac (10.6.3). I want to populate every
row in my CSV file with a zero except for the header row. What is the
easiest way to do that?

Thanks, - Dave
 
D

Dave Peterson

In excel for windows, I'd do this:

Select the range that gets the 0's.
type 0
hit ctrl-enter to fill the selection with 0's.

I _think_ that the control key on wintel machines is the equivalent to the cmd
on mac's. (But I'm not sure!)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting date format 4
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Trouble with a page break 1
Find values across a row and return a text value from the same column 2
Having Blank Cells, etc. ? 1
Variable Column Lookup 7
CSV all in one column problem 2
How do I combine these columns into one? 2

Top