Excel sort/filter help

[info865]

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.

[#2]

@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:

• https://exceljet.net/shortcuts/toggle-autofilter 
• https://exceljet.net/shortcuts/move-to-first-cell-in-worksheet 
• https://exceljet.net/shortcuts/extend-selection-to-last-cell-in-worksheet 
• https://exceljet.net/shortcuts