Windows 10: Why do help and support pop keep appearing on my browser or excel file when I start...

1. I connected an external keyboard and mouse through blue tooth 2. When I use the keys on my laptop and mouse pad on my laptop no issues3. When I use my external keyboard or mouse to enter or type immediately help and support page keep popping up on any tool I use even on browser or excel.4. Should I set up anything on my device to avoid this pop-up?

:)

 

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

 

Excel file

Hi zhiyang....,

I'm assuming that since you're using Excel 2011, that you have a Mac. Have you tried saving the file in the default 2011 format of XLSX?

While I have tested and can open both XLS and XLSX files on my Windows Phone, they were both created in PC versions of Excel 2000 and Excel 2010.

As a test, would you:

• First, try saving the file as XLSX and see if you can access the newer file format on your phone.

Otherwise, try the following as a test:

• Open up a web browser
• Go to Windows Live and login.
• Select "SkyDrive" at the top of the brwoser window
• Select the Excel icon near the top where it says "Create"
• Add a few numbers and do an AutoSum. Maybe add some formatting.
• Close the workbook (File -> Close workbook)
• Next, your SkyDrive file listing will appear with the new file.
• Click the "i" circle to the far right of the new file.
• Now, select "Send a link"
• Enter your e-mail information and click "Send"
• On your phone, open the e-mail and click on the button that says "View document"
• You should be able to view the document.
• If yes, then there is apparently a compatibilty issue on the Mac using XLS and I would try my first suggestion of trying to save the file in a different format like the newer XLSX.

By the way, the procedure gets easier in Windows Phone Mango (coming soon - no official release dates yet except in Japan) as you can save to and access files directly from your SkyDrive. That would eliminate the e-mailing it to yourself steps ... a lot easier!

I hope this helps!

David

 

How to pin an Excel 2007 file to the W10 Start fly-out menu

Thanks Annu.

In Method 1, at step 2, the file I want doesn't already appear in the Start menu. Do mean to browse to the file I want in the File Explorer? If I right click on the file in the File Explorer, "Pin to Start menu" is not an option.

In Method 2, at step 4, I release the left button, but the file doesn't appear anywhere in the Start Menu afterwards. It's not listed along with my Most Used apps, and it's not pinned in the Jump Menu of Excel 2007.

Maybe I misunderstood something in your directions?

Cheers,

Vince