I have Excel 365 which operates differently but it finally worked with Paste Special.
Thank you for your help. Charles. On Fri, Oct 21, 2022 at 3:31 PM Hastham S <hasth...@yahoo.com> wrote: > Hi > > Which version of MS XL are you using ? > Which operating system - MAC or Windows ? > > *Did you check the help URL that I had posted* > > for example in EXCEL 2003, this is what you do > > - > - *Select the cell(s) whose values should be copied.* > - *From the Edit menu, select Copy. ... * > - *Select the first cell where the results should be pasted.* > - *From the Edit menu, select Paste Special... ... * > - *Under Paste, select Values.* > - *Click OK* > > > > do you see a box like this when you click on paste special ? or what do > you see? > [image: Inline image] > > > > regards > > > > On Friday, October 21, 2022 at 10:24:14 PM GMT+4, charles meyer < > reachmepl...@gmail.com> wrote: > > > Hi, > > Thanks for the well wishes. > > I highlighted the last column with all the total numbers of that judge's > scoring for that judge. > > I then drag the highlighted numbers in each cell in each frew for that > column down from the first to the last story. > > I right clicked and chose Copy. > > I then opened a blank worksheet and there are 2 (two) Paste Specials. > > I chose the 1st and it doesn't paste in the numbers so I then chose the 2nd > Paste Special but that didn't paste in the numbers either. > > I'm not sure what's going wrong? > > Thanks. > > On Fri, Oct 21, 2022 at 1:44 PM Hastham S <hasth...@yahoo.com> wrote: > > > Hi Charles > > > > Great to know you are safe. > > > > Regarding the copy paste, I think you are just doing normal Control + C > > and Control + V *which will copy the formulae* > > > > Please try paste special - paste values, when you paste on to the summary > > sheet > > > > Paste values In MS Excel : > > Copy and paste specific cell contents > > < > https://support.microsoft.com/en-us/office/copy-and-paste-specific-cell-contents-a956b1c3-cd5a-4245-852c-42e8f83ffe71 > > > > > > Copy and paste specific cell contents > > > > > > < > https://support.microsoft.com/en-us/office/copy-and-paste-specific-cell-contents-a956b1c3-cd5a-4245-852c-42e8f83ffe71 > > > > > > Paste values In Libre Office calc : > > Paste Special > > <https://help.libreoffice.org/latest/ro/text/shared/01/02070000.html> > > > > Paste Special > > > > <https://help.libreoffice.org/latest/ro/text/shared/01/02070000.html> > > > > Hope this helps > > > > regards > > Hastham / Subu > > > > > > > > > > > > > > > > > > > > > > On Friday, October 21, 2022 at 09:10:07 PM GMT+4, charles meyer < > > reachmepl...@gmail.com> wrote: > > > > > > Hi All, > > > > > > > > So grateful to have survived Hurricane Ian and to be able to help others > in > > the community. > > > > > > > > It seems Excel isn’t as straight forward as I’d like. > > > > > > > > Perhaps this is easier to do in Calc? > > > > > > > > I opened a blank worksheet and thought I’d create the first column of > rows > > with each cell populated with the name each a story. I then created > columns > > with the heading of the name of each judge. > > > > > > > > So, 50 rows (each story) and 4 columns comprised of each judge name and > > then the last column named Total for total of points summed from each of > > the judge’s scores. > > > > > > > > When I copy by highlighting all the score numbers from a judge’s total > > score column and the paste those scores into the 1st cell under the > column > > for that judge I get #REF! in each cell. > > > > > > > > Is there a way to copy all those judge’s scores from each judge’s scoring > > worksheet and pates them into a column for that judge in a new worksheet > so > > I have all the scores from all the judges and in the 4th column I can > just > > Click that Z Sum tab to add all 3 scores for each story (and then > hopefully > > sort them by highest score to lowest? > > > > > > > > I’ve never taken any Excel nor Calc class which taught this. > > > > > > > > Thank you so much. > > > > > > > > Best, > > > > > > > > Charles. > > > > -- > > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > > Problems? > > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > > Posting guidelines + more: > https://wiki.documentfoundation.org/Netiquette > > List archive: https://listarchives.libreoffice.org/global/users/ > > Privacy Policy: https://www.documentfoundation.org/privacy > > > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy