Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

2
  • Thanks. Is it only at MS Excel 365, but not at MS Excel 2013 or earlier?
    – Imyaf
    Commented Sep 1, 2023 at 8:17
  • @Imyaf That is why I wrote "...If you have Microsoft 365...". Your tags did not indicate any version restrictions. To do this in an earlier version, I suggest Power Query (Excel 2010 or later) or VBA. And it would also depend on whether you are using Windows or MAC. Commented Sep 2, 2023 at 20:11