Discussion on:

Office challenge: How would you enter the same value into numerous non-contiguous cells?

Select the one of the blank cells
Select each additional blank cell using ctrl-click
enter 0 into one of the highlighted cells and click CTRL ENTER

Highlight the cells in question and perform a FInd and Replace. Put nothing in the Find box and 0 in the Replace box then click on Replace All. If it's just numbers in the cells, and no spaces, you're all set.

returns the following dialog:

"Microsoft Office Excel, cannot find any data to replace. Check if your search formatting and criteria are defined correctly. If you are sure that matching data exists in this workbook, it may be on a protected sheet. Excel cannot replace data on a protected worksheet."

1) Highlight the cell to be copied and hit CTRL-C, CTRL-Click each cell you want to paste the value into then hit CTRL-V

2) Highlight the cell to be copied and CTRL-C Twice (this automatically opens the Office Clipboard and pastes the value there), then click a cell you want to paste to and click the clipboard. NOT the best way

3) Select the full area of the sheet to be searched and replaced. (Often Shift-CTRL-END works for this.) Hit ALT-E, E to open Find and Replace. Leave Find blank. Put in 0 in Replace. Hit Replace All

Yes, I'm a keyboard navigator so most of my commands are done via keys

copy a zero into the clipboard, select all cells in the range and "right-click, paste-special, add".

I like the find and replace solution from tink. I just tested and it works like a charm. good one.

I might add that there are some functions (don't remember which, they always catch me by surprise) that don't like 0 formatted with a "-". That is what "comma-style" looks like. So, I also format my numerical data with "number-style" which returns "0" for a zero value.

Choice the one of the blank cells
Choice each additional blank cell, using ctrl-click
enter zero into each of the highlighted cells, then CTRL ENTER

There's no need to enter zero into each of the cells. Just enter it into ONE of highlighted cells then press Ctrl Enter

Select the complete range (Ctrl+A)
Press Ctrl + G (Goto)
Press Alt + S (Special)
Press K (for Blanks) and then press enter

Press 0 and then press Ctrl + Enter to populate all blanks with zero's

Do let me know how it goes!

That's a great way to go if there's a lot of blank cells. So much quicker than individually ctr-clicking each blank cell.

Nice.

(using 2003)

Ctrl-H to open Replace dialogue
leave Find what: blank
enter whatever you need in Replace with:
open up Options and check Match entire cell contents
Alt-A to invoke Replace All

NB if no range is initally selected, this will update every blank cell in the active area (ie not to IV65536) of the worksheet

Select the non-contiguous cells
select 1st one, control click the others
Type a number
Press Control + Enter
All done!

Select the first cell enter 0, then press enter. Copy the cell. Select other non-contiguous cells using ctrl+left click, then ctrl+v. All the cells then have the same value pasted in them.

because they rely on you scanning for and clicking each relevant cell
Much better selecting by using Go to, Special... or Find and Replace (my favourite for this example as it's easily undone or repeated and won't lose your current position/view or empty the clipboard)