Discover overlooked but impactful Excel features like worksheet duplication, filtering resets, and the Microsoft 365 Clipboard that can streamline your daily workflow with minimal effort.
It is easy to overlook Excel’s most practical features when attention is fixed on heavier tools such as Power Query, the Data Model or Python. Yet the habits that save the most time are often the simplest ones. In a recent How-To Geek guide, the focus was on a set of small but useful tricks that can be learned in moments and used every day.
One of the most immediately helpful is worksheet duplication. Microsoft Support says the standard method is to hold down Ctrl while dragging a sheet tab, which creates a copy without opening the usual Move or Copy dialog. The same approach is echoed by Excel-focused guides from Exceljet and Unleashed Excel. It is a small shortcut, but it matters in workbooks with many tabs, where menu-driven duplication becomes slow and awkward.
Filtering can cause just as much confusion if it is left in place unintentionally. Microsoft explains that a worksheet-wide reset is available from the Data tab’s Clear button, which removes filter criteria while leaving the filter controls visible. That is often faster than hunting through columns to find the one that is still restricting the view. The company also notes that individual column filters can be cleared directly from the filter menu, which is useful when only one field needs to be reset.
Another time-saver is Excel’s Add to Selection mode. Instead of holding Ctrl throughout a series of mouse clicks, users can press Shift+F8 and build a non-adjacent selection one range at a time. Excel shows this mode in the status bar, which helps avoid accidental misclicks. The feature is particularly useful when building formulas that need several separate ranges, because each selection can be added without keeping a modifier key pressed.
For wide sheets, horizontal navigation is often the nuisance, not the data itself. The How-To Geek guide points out that Ctrl+Shift plus the mouse wheel scrolls sideways, which is far quicker than dragging the horizontal scrollbar. Keyboard users can do the same job with Alt+Page Up and Alt+Page Down. These shortcuts are minor on paper, but they remove friction from large workbooks.
Naming important cells is another habit that improves readability. Rather than relying on cryptic references such as $G$2, Excel’s Name Box lets users assign a meaningful label to a key value and then use that name in formulas. Microsoft also provides a Create from Selection tool for generating names from adjacent labels. The result is less cluttered formulas and workbooks that are easier to review later.
The final trick is not unique to Excel, but it is especially helpful inside spreadsheets: the Microsoft 365 Clipboard can store several copied items at once. That means users can gather values from different places before pasting them in sequence, or even paste the full set into consecutive cells. As the How-To Geek article argues, these smaller discoveries often have the biggest effect on everyday work, precisely because they make routine tasks faster without demanding much to learn.
Disclaimer: This content is intended for informational purposes only. Readers are advised to exercise their own judgement, conduct due diligence, or consult a qualified expert before acting on any information provided.
