How to filter data with merged cells in Excel: ?

Filter and view all the related data on the merged cells

I have  data in both Columns and Rows  Merged , My problem was that I need to filter the data by column  and when I do this the data showed is only for the 1st row of the merged cells.

The solution could be by simple Filtering tricks  options and  better than adding any codes

HYG How to do this 

https://www.youtube.com/watch?reload=9&v=-Udd6Nc74dY

Another Two Techniques

Tehnique 1
https://www.youtube.com/watch?v=up3ZzvjXX44&pbjreload=10

Technique 2
https://www.youtube.com/watch?v=7L8Aq8lrR1k

How to Change Default Location for Outlook Data File (PST & OST)

Is there a way to change the default location of new .pst file when create a new e-mail account in Outlook? Different versions of Outlook use different default locations to store pst files. In this tutorial we’ll show you how to change default location for Outlook .PST & .OST data file using a registry trick. It works with all versions of Outlook, including Outlook 2016 / 2013 / 2010 / 2007 / 2003.

How to Change Default Location for Outlook PST/OST File?

1.      Press the Win + R keys in a meanwhile to open the Run box. Type regedit and click OK.

2.      When the Registry Editor launches, navigate to one of the following keys, depend on your Outlook version:

·        Outlook 2016:
HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Outlook

·        Outlook 2013:
HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Outlook

·        Outlook 2010:
HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Outlook

·        Outlook 2007:
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Outlook

3.      At the right-side pane, right-click on any blank area and select New -> Expandable String Value.

4.      Name the newly created value as ForcePSTPath, then double-click on it. On the Edit String dialog, enter the new default location where you wish to store the PST file for Outlook new profile, and click OK.

Note: To change the default location folder of .ost files generated by exchange accounts, you can create an expandable string value and name it as ForceOSTPath.

5.      Close the Registry Editor and restart Microsoft Outlook application. From now on, when you set up a new email account, Outlook will automatically create a new PST file in the new default location.

This method won’t affect the location of existing .pst files. If you want to change the location of existing pst file, follow these steps:

1.      Exit the Outlook application. Locate your .pst file in Windows Explorer and move it to a new location.

2.      Restart Outlook. An error dialog box appears that notifies you that an Outlook Data File (.pst) could not be found. Click OK.

3.      It will open the Create/Open Outlook Data File dialog box. Browse to the new location, select the Outlook Data File (.pst) that you moved, and then click Open.

4.      When you see a warning message, just ignore it by clicking OK. Now you’ve successfully moved your existing pst file to a new location.