1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Is it possible to use filters or sort on blocks of information?

So here my thought experiment. I want a list/archive for books. All the informations are within the area of the bookcovers as seen in the picture of the Testfile (its in german but it should be clear what i mean)

Is it possible to sort the whole block of information?

For example i want to sort the Booktitles from a-z, the date of the next upcoming book or the shelveplace from A1 to D5. But the block of information needs to stay together (like in the basic Filterlist but more dense for mobile usage).

Or is it essential to use a different program to do this more easily?

Ps iam not that good at excel, i can make Lists, basic calculations and maybe an if/then protocol but there it ends.

Pps I have a working list of all my books and all of the informations are searchable. But iam not quite happy with the layout/optic.

Ppps English is not my first language so i hope it is clear what i have in mind :D

submitted by /u/Illustrious-Stick852
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#financial modeling with spreadsheets
#natural language processing
#books
#archive
#booktitles
#sort
#information
#shelveplace
#layout
#filters
#searchable
#mobile usage
#excel
#filterlist