亞寵展、全球寵物產業風向標——亞洲寵物展覽會深度解析
655
2023-12-27
如何在Excel中使用超鏈接過濾數據？
如何在Excel中使用超鏈接過濾數據？
在Excel中，您可以按特定的文本，數字或字體顏色，背景色來過濾數據，但是您是否曾經嘗試過用列中的超鏈接過濾所有數據，如下圖所示？ 在本文中，我介紹了一個VBA，可以快速過濾Excel中的超鏈接。
使用超鏈接過濾數據
使用超鏈接過濾數據1。 按 Alt + F11鍵 啟用 Microsoft Visual Basic應用程序 窗口。
2。 點擊 插頁 > 模塊，將以下代碼復制并粘貼到 模塊 窗口。
VBA：使用超鏈接過濾數據
Sub HyperPicker()
UpdatebyExtendoffice20180404
Dim xRg As Range
Dim xCell As Range
On Error Resume Next
Set xRg = Application.InputBox("Select a column:", "Kutools for Excel", Selection.Address, , , , , 8)
If xRg Is Nothing Then Exit Sub
For Each xCell In xRg
If xCell.Hyperlinks.Count = 0 Then
xCell.EntireRow.Hidden = True
End If
Next
End Sub
3. Press F5 key to select a column to filter.
4. Click OK, only the hyperlinks are displayed.
Best Office Productivity Tools
Transform Hours into Minutes with Kutools for Excel!
Ready to supercharge your Excel tasks? Harness the power of Kutools for Excel - your ultimate time-saving tool. Streamline intricate tasks and glide through your data like a pro. Experience Excel at lightning speed!
Why You Need Kutools for Excel
??? Over 300 Powerful Features: Kutools is packed with more than 300 advanced features, simplifying your work in over 1500 scenarios.
?? Superior Data Processing: Merge cells, remove duplicates, and perform advanced data conversions – all without breaking a sweat!
?? Efficient Batch Operations: Why put in extra effort when you can work smart? Import, export, combine, and tweak data in bulk with ease.
?? Customizable Charts and Reports: Access a broad variety of additional charts and generate insightful reports that tell a story.
??? Powerful Navigation Pane: Gain an advantage with the robust Column Manager, Worksheet Manager, and Custom Favorites.
?? Seven Types of Drop-down Lists: Make data entry a breeze with drop-down lists of various features and types.
?? User-Friendly: A breeze for beginners and a powerful tool for experts.
Download Now and Soar Through Time with Excel!
Read More... Free Download... Purchase...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
Open and create multiple documents in new tabs of the same window, rather than in new windows.
Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Read More... Free Download... Purchase...
Copy
版權聲明：本文內容由網絡用戶投稿，版權歸原作者所有，本站不擁有其著作權，亦不承擔相應法律責任。如果您發現本站中有涉嫌抄襲或描述失實的內容，請聯系我們jiasou666@gmail.com 處理，核實后本網站將在24小時內刪除侵權內容。
相關文章
