rss
Options They need your help All unanswered messages
Search : in
By : Relevance Date Username
Statut : Not resolved

Bulk pasting problem with mac excel

scrshots, on Friday May 2, 2008 12:19:57 PM
Hello,




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.
Configuration: Windows XP
Internet Explorer 6.0
Reply to scrshots  Report this message to moderators Go to last message

1


  • This message seems useful, vote!
  • Report this message to moderators
 jacikechina, on Friday May 2, 2008 02:58:53 PM
Hello



"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.
   
Reply to jacikechina
Ask your question Reply
Cannot copy and pasteHey there, I have a very strange problem with my pc having SP2 installed on it and the fact is that I cant copy and paste in excel nor internet explorer anyone can help me please? en.kioskea.net/forum/affich-21977-cannot-copy-and-paste
Excel: Macro HelpHello, I ned some help setting up a macro for Excel. I have a lost of IDs/SKUs on Sheet 1, and a partial list on Sheet2. What I would like to do is cross-check the two sheets and delete all the rows on Sheet1 that's already listed on sheet2. The... en.kioskea.net/forum/affich-5884-excel-macro-help
How to Cut and Paste in MacHello, I am new to MAC, and i am used to being able to "cut" qand "paste" files like in Windows XP. however in OSX it would seem that the " cut " option is disabled when i click on. Edit while in a finder window. why is this the case ? i would rather... en.kioskea.net/forum/affich-3976-how-to-cut-and-paste-in-mac
Audio Mixer SoftwareAudio Mixer Software For Windows users For Linux users For MacOS X users There is no need to be a professional DJ today to be able to mix some good music with excellent sound effects. Powerful softwares are available and allow you to... en.kioskea.net/faq/sujet-240-audio-mixer-software
Print Screen (Windows, Mac OS X and Unix/Linux)How to make a Print Screen (Windows, Mac OS X and Unix/Linux) What is a Print Screen? How to make a Print Screen (Windows) How to make a Print Screen (Mac OS X) How to make a Print Screen (Unix/Linux) Screen Capture Softwares What is a... en.kioskea.net/faq/sujet-141-print-screen-windows-mac-os-x-and-unix-linux
Excel tips : How to insert date In an Excel cellExcel tips : How to insert date In an Excel cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press “CTRLâ€+ “;†in the chosen cell. To insert current... en.kioskea.net/faq/sujet-313-excel-tips-how-to-insert-date-in-an-excel-cell
Excel Macro; Adding Password (Solved)Hello, Hope you anyone can help me with this... I need to create a macro that unlocks a password-protected sheet with password "password", do some instruction, then locks it again with same password. Thanks in advance for any assistance. zero en.kioskea.net/forum/affich-17268-excel-macro-adding-password
Excel vba if first char of cell is 1 thenHello, I have a question about "if then" in excel vba I've been looking all over the web for an answer or example and now matter what code I try I cannot get the right syntax. I have a column named "code" which contains item codes and I want to... en.kioskea.net/forum/affich-19939-excel-vba-if-first-char-of-cell-is-1-then
Excel autofilter stops filtering (Solved)Hello, I am working with Excel 2003 professional and just yesterday after entering a bunch of records to my file which has about 19,000 rows I discovered that my autofilter just stoped filtering completely. When I clicked the arrow there is no value... en.kioskea.net/forum/affich-5838-excel-autofilter-stops-filtering
Download FfmpegXEncoding will not be any more a mystery for whoever. FfmpegX is the horrible tool of encoding par excellence. It is a graphic interface indicated for Mac. Encoding becomes with more than 20 tools Open Source different including the ffmpeg... en.kioskea.net/telecharger/telecharger-204-ffmpegx
Download DashItGadgets became necessary when they use a computer Mac (or PC). To have them permanently on the office, it is always necessary to go past again by Dashboard. Dashit is a program which allows to support any widget on the office. It is very practical... en.kioskea.net/telecharger/telecharger-306-dashit
Download JarteIf you find that Microsoft Word is too heavy or too bulky for your machine, use "Jarte". Jarte is a text editor based on the motor of Microsoft WordPad of Windows. It starts in the quarter of tower, furthermore he requires no installation, you can... en.kioskea.net/telecharger/telecharger-709-jarte