fixed : how to duplicate a calendar event on iPhone (or iPad)

Question :

I am used to arranging my Calendar events mainly on my Mac, because I think I have more options there tan on my iPhone and iPad. But at this moment I do not have my Mac at hand and I want to duplicate (or copy-paste) a calendar event that is already in my Calendar to another date… but there doesn’t appear to be a simple button to do so…

Is there really no way to duplicate a calendar event on an iPhone/iPad ?

 

Answer :

Yes, there is an option built into iOS/iPadOS to do so, but it’s not as straight forward as you might like :

  • open the Calendar app
  • go to the calendar event you want to duplicate (or copy-paste)
  • click on it, so the Event Details page will open
  • then click on Edit (top-right), so the Edit Event page will open
  • then click on the tiltle of your event, so the red cursor line appears
  • then click-and-hold on the title of your event again, and when you release the pop-up options will appear in black, then choose Select All
  • the title of your event will now be entirely highlighted in red, and slightly different pop-up options will appear in black, this time choose Copy
  • then click Cancel (top-left)
  • then click on the date (in red) top-left
  • in Calendar-roll page, scroll to the date where you want to place the duplicate calendar event
  • then click + (the red plus-sign top-right), so a New Event page will open
  • click-and-hold on Title (in grey), and when you release the pop-up options will appear in black, then choose Paste
  • now, the event name will be pasted, and the Location-line will be pushed downward to make way for a Suggeted Event
  • click on the Suggested Event and all the additional settings of the original event will be filled out (put differently : you now have a duplicate of the original event)
  • now, adjust all details, like date, time, calendar, alerts, etc. to your liking
  • when ready, click Add (top-right in red)

That’s it… you now have a copy-pasted (and edited) the original event !

enjoy 😉

fixed : copied Excel data only shows zeros instead of original values

Question :

I have this data-range in MS Excel that I want to copy from one page to another, but when I do, in the area that I want to copy to, all cells are filled with zeros…

…the original data has disappeared…

How can I fix this ?

Answer :

Just use the “Paste Special”-option from the Edit-menu, like this :

– in MS Excel, go to the data that you want to copy

– select the range of data you want to copy

– press CMD + C (or choose “Copy” from the Edit-menu)

– then go to the area you want to copy the data to, and select the upper-left cell of the area you want the copied data to appear in

–  then press SHIFT + CMD + V (or choose “Paste Special” from the Edit-menu)

– in the pop-up window that appears, select “Values” (the option third from the top) instead of “All” (which was the first option from the top), and click “OK”

– now the original data will appear

…that’s it !

Enjoy ! 😉

Donate Button (all)

fixed : copy a row into a column (or a column into a row) in MS Excel

Question :

I have this column full of data in MS Office’s Excel, and now I need the exact same data range in another spreadsheet, but this time as a row…

Do I really need to re-type all data ?

Isn’t there an easier solution ?

Answer :

Yes, there is a far simpler way to copy data from a row into a column (and vice versa) in Excel.

You can just copy & paste, or “Paste Special” to be exact… it goes like this :

– in Excel, select the range of cells you want to use (or copy)

– then press the CMD + C key-combo (or select “Copy” from the Edit-menu)

– then go to the page (a.k.a. “sheet”) you want the copy the data to, and select the upper-left cell of the area you want the copied data to appear in

– then press the SHIFT + CMD + V key-combo (or select “Paste Special” from the Edit-menu)

– …and in pop-up window that opens, put a check-mark in front of “Transpose” and click “OK”

– now the data from your original row (or column) will ‘magically’ appear as a column (or row)…

…that’s it !

enjoy ! 😉

Donate Button (all)