Windows 10: Why when I copy and paste data from an excel sheet into whatsapp, it automatically, a...

Why when I copy and paste data from an excel sheet into whatsapp, it automatically, a duplicate of the data in text is created below. How can I prevent this from happening?

:)

 

Help needed with Excel Attendance Sheet

You use the Data tab, Data validation facility to do this.

If you want a coherent explanation then look in Excel Help. Here's the relevant extract from Excel 2007 Help. Excel 2007 Help - Data Validation.pdf

My example:
- I have written them in what seems to me to be the order of easiest explanation.
- You'd actually set them up in the reverse order - step 3, step 2, step 1.

1 The result - my dropdown list. I select the cell then click on the dropdown arrow that appears next to it.




2 To set this up, select the whole column [or individual cells] where you want the dropdown to appear then click on the Data tab then the Data validation control. You need to
- select In-cell dropdown
- set the Allow entry to List
- in Source, enter the worksheet name & cell range where you have written the allowable entries - you will generally want to use absolute cell references such as those shown [$ in a cell address means absolute and will not vary as you copy the formula all the way down your column - look this up if you are not familiar with it because it needs a bit of getting used to].




3 Write out the list of allowable entries that will appear in your dropdown list.




Job done.

Denis

 

Copy Column Headings in Excel from Sheet 1 to Sheet 2 - How?

I have Microsoft Office 2016 Excel on Windows 10.

I want to copy “Column Headings only in Excel” from Sheet 1 to Sheet 2. I do not want to copy data from Sheet 1.
I tried some Google searches and had trouble following and understanding some of the steps.

In one of the search links I tried, a note said in effect, the column spacing in Sheet 1 did not match Sheet 2 spacing and would not allow me to proceed. So, maybe this can’t be done. I’m sure there were probably other issues, as well.

If what I want to do is possible, please don’t hesitate to make it “simple” in your response.

Thanks,
Jerry

 

Excel sheet is automatically open

Why Excel sheet is automatically pop-up many sheets when I turn on my PC