Windows 10: Colum repetition

SirI have excel sheet as below :Name male/female. Can I create a macro for second colum to enter with a key pressing for male/female?To enter male a key press as macro. Same wa for female.

:)

 

Envath shows folder repetition

Thanks for the response.
I have seen there as you suggested. It shows as below.



Finally I tried adding one path to user only there.
Now checking again shows that first set of path is for system and second set is for that particular user.

 

End of extended support for Office 2007 on October 10, 2017 Office

Assuming you have an older Office version such as my MSOffice 2007 [because current Office versions do not seem to work in the same way]:-

Step 1 - Run this Powershell PS1 file to create a list on your Desktop
Code:

It is based on code posted by 1981DMC in getting list of installed Office packages - SpiceWorks
I have not tested this with any Desktop paths containing special characters such as ampersands [&].

Step 2 - Open the list in Excel, freeze the top row, add AutoFilter to the top row so you can filter by blanks in the HelpLink column and delete those rows [those rows are not updates]. Save the file as an Excel file.

Step 3 - What you are left with are Office updates. There are a few repetitions in the list, because Windows records some of them twice, so use AutoFilter to sort them into DisplayName alphabetical order so you can spot and delete many of the repetitions. Control panel, Programs & features, View installed updates also repeats some entries.

Step 4 - Use normal Excel text manipulation functions to extract KB numbers into a column of their own. The HelpLink column is probably the easiest one to work with.

Step 5 - You could then be cautious and check against the list in the Office 'group' of Control panel, Programs & features, View installed updates to check for additional entries to add to OfficeUpdatesList.xlsx. I have just done so and the list produced in Step 1 matched completely [once you decide that repetitions in either list do not matter].

I have no idea if this procedure applies to later versions of MSOffice. I only have MSOffice 2007.


All the best,
Denis

 

Envath shows folder repetition

"Envath" shows folder repetition as shown below.



How to rectify it?