Forum Discussion
Excel sort/filter help
Hello im using excel on my MacBook, and im a novice!
need some help with sort/filter (not sure) column H & J have some auto sort attached to them, so the row data stays attached no matter if sort H & J , I need to do the same with column M and will need add same to other columns. Any help gratefully received.
info865 It seems that column M is not included in the current filter range. To reset the filter range, turn filters off (Ctrl+Shift+L), then select the entire range that you want to be included (tip: press Ctrl+Home then Ctrl+Shift+End to select the entire used range on the worksheet) and turn filters back on (Ctrl+Shift+L). You can also toggle filters on an off by going to Data > Filter on the Ribbon.
Mac equivalent keyboard shortcuts can be found here:
