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?

Our take

Sorting and filtering blocks of information in a spreadsheet is indeed possible, and it can enhance your organization of book data. You can keep related information together while sorting titles, upcoming release dates, or shelf locations. However, achieving a more user-friendly layout, especially for mobile use, may require some adjustments to your approach. If you're looking for a more streamlined solution, consider exploring specialized tools designed for managing collections. Your current setup is a great start, and refining the layout can significantly improve your experience.

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]

Read on the original site

Open the publisher's page for the full experience

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