I have a formula which i want to paste into 10,000 cells at once. because they are cells 1 to 10,000 in one column so it is relatively easy to select all 10,000 of them. however, when I press the paste button, it only pastes into the first cell, leaving the other 9,999 calls alone. my father knows the appropriate shortcut for windows, but that can't help me as I am using a mac and he has forgotten how to do this via the menus. any help would be much appreciated.

Sorry this is not what you want, I've no idea, but, I'm intrigued. What are you doing that requires 10,000 cells with the same formula in each? Hope you don't mind me asking. It's not that I can't remember things as I get older, it's just that my hard drive's full.

"how to do this via the menus." Edit, Paste. Try pasting the formula into the first cell, copy the formula from that first cell, select the other 9,999 cells, go to Edit, Paste. Otherwise, I would suspect your issue is related to cell referencing within your formula as Excel works the same in Windows as in MACs. Another method to use if the column to the left and adjacent to your target column contains data for the 10,000 rows is to paste as noted before into the first cell, place the cursor over the bottom right hand corner of the cell causing the cursor to change to a "+" symbol then simply double click on it to copy it down to the last adjacent cell. HTH Bryan

Are you copying all 10,000 cells? Life's more painless for the brainless.

Although we can't really tell from where we're sitting, we'll assume that you are actually selecting the 10,000 cells to paste the formula into. That said, if neither of the following methods work, please post the formula along with exactly what you are trying to do and we'll see if we can help. 1 - Enter A10000 in the Name box and hit enter to select A10000. 2 - Scroll up to A1 3 - Hold the shift key while clicking A1 to select A1:A10000. 4 - Type your formula into the formula bar 5 - Hold the Ctrl key and hit enter. Or, Enter the formula in A1 and drag it down to A10000. Or use this code: Sub FormulaTenK() Range("A1:A10000").Formula = "=B1*6" End Sub

I solved the problem (analyzing all movements of the s&p500 between june 13th, 1968 and march 3rd, 2008) Thanks to a variant of bryco's second method (see response two). The variant was just to paste the formula into cell one and make the curser a plus sign and select all 10,000 cells while holding the mouse button. then let go of the button. DerbyDad03's second method also worked. Thanks for the help.

That still doesn't answer the question as to why you couldn't just paste the formula in after selecting 10,000 cells. Oh well....