Windows 10: How to Copy Data from Protected Excel Sheet

I received a password-protected Excel on my Windows 10 computer, and I do have access to view the sheet, but I am unable to copy and paste any of the data. I have tried a few methods including right-clicking, copying and pasting, and even using a third-party software, but nothing seems to work. Is there a way to bypass the protection for me to copy data from protected Excel sheet? Any help would be greatly appreciated.

:)

 

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

 

Missing function like data validation function in excel sheet accessed in SkyDrive

Hi niharbiswas,



Welcome to the Microsoft Community forum. I'm here to assist you. I'd need more information from you for investigation. Please answer the following:

• Where are you opening the excel sheet? Is it on your phone's browser or on the SkyDrive app?
  
• What is your phone exact model, OS and OS version?
• Does the problem happen on all your excel sheets including files uploaded from a computer and newly created ones?
  
• Does the problem happen if you access the excel sheet on the Excel client a computer?

We look forward to your reply.



Note: Some functions and features in Office are not available for Office Web Apps access. This includes data validation function.

Thank you!