When you are filtering a worksheet, when hitting the drop down value we get a (Select all) and a check box for each data value. Rather than having to unselect all and scroll to the items you want to check to display allow a checkbox to the right of the values to simulate the unselect all and check current item. Then continue checking items as usual if needed. Very helpful on larger data filtering.1 vote
Unselecting all items in the filter dialog/drop down can be done with the “(Select All)” item that is checked by default — if you uncheck that, then it will unselect all of the items in the list and you can continue to select just the items you want to filter on.
Hope that helps,
Scroll horizontally by pressing Ctrl+Shift+Wheel scroll, or with mice that support side scroll, like Adobe Reader, Chrome, IE...
Scroll horizontally by pressing Shift+Wheel scroll, or with mice that support side scroll, like in other aplications, like Adobe Reader, Chrome, IE...181 votes
Good news! On Windows, you can now scroll right and left using a mouse with a scroll wheel by holding down CTRL+SHIFT. If you move the scroll wheel up, it will scroll your sheet to the left, and scroll down to go right. On Mac, you can just hold the SHIFT key to do the same thing.
To see all the suggestions we’ve completed, please see https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/filters/top?status_id=1406092
Unintuitive tricks are required to unhide column A once it's been hidden. Why not provide a hover click-target that offers to reveal column A if the mouse pointer lingers up in the left edge of the header of column B? In fact, why not use such a widget to allow any hidden columns to be revealed? If I leave my mouse pointer in the column header row adjacent to a hidden column, that is what I want to do.1 vote
We now make this much easier with Excel 2016 – there’s a special hit target if column A is hidden.
- Don't see your idea?