When you add a list or library web part through the SharePoint UI, the web part title is automatically hyperlinked to the SharePoint list or library. For example, in the screenshot below, I have a standard Team Site homepage with a Shared Documents web part. The title of the web part is linked to the Shared Documents Library.
If you edit the web part, under the “Advanced” group, you will see Title URL where you can change the hyperlink of the web part title heading to another URL location.
However, if you decide to remove this Title URL value and click OK. SharePoint won’t allow the update. It would instead automatically re-enter the original URL value. To quickly get around that, Edit the Web Part and replace the URL with #
Once you click OK, you should be all set.
You may ask, “When do I ever need to do this?”
From my personal experience, this small tip might be helpful in a couple of ways. First, if you want to provide a specific view to a SharePoint audience. Hiding the link would allow you to highlight just the specified list view on the SharePoint page.
Another reason to remove Web Part Title URL is if you were to have a custom user permission level that restrict user to “View Application Pages”. The user would otherwise encounter an Access Denied page when clicking on that web part title heading.