To do List with Columns

Rukmag 

If I understand correctly, you want to create a to-do list with tasks categorized into different columns, and you're looking for a way to easily move tasks between these columns. Here's a suggestion without using VBA:

1. Create a Table: Start by creating a table for your to-do list. Select the range of your to-do list, and go to the "Insert" tab and choose "Table."
2. Add Status Column: Add a column named "Status" to your table. In this column, you can use dropdown lists to indicate the status of each task (e.g., "To Do," "In Progress," "Completed"). You can create a data validation dropdown list for this column.
3. Filter Table: Use the filter options in the header row of your table. Users can filter tasks based on the status column, making it easy to see tasks in different categories.
• Click on the filter icon in the header of the "Status" column.
• Select the status you want to view (e.g., "To Do").

This way, users can easily filter tasks based on their status without having to scroll through the entire list.

1. Sort Table: You can also sort the table based on the "Status" column. This way, tasks with the same status will be grouped together.
• Click on the filter icon in the header of the "Status" column.
• Choose "Sort A to Z" or "Sort Z to A" based on your preference.

This approach doesn't involve moving entire columns but provides a dynamic and user-friendly way to organize and view tasks based on their status. Users can quickly filter and sort tasks without needing to understand or use advanced Excel features. The text was revised with the AI.

Additional Link: Microsoft Templates for todo list

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and like it!

This will help all forum participants.