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

How do I keep a placeholder date row sorted on the top of a sheet sorted by descending date?

Our take

Managing a lead tracking spreadsheet can be challenging, especially when dealing with placeholder dates. In your case, the goal is to keep a specific row with a placeholder date of 1/1/1900 at the top of a descending date-sorted sheet. This ensures that your most recent entries remain visible while still reserving space for future data. If this functionality has changed, it’s important to revisit the sorting settings and any filters that may have been applied. Let’s explore how to restore this feature effectively.

First off, apologies for the poor description in the title. I inherited a lead tracking spreadsheet from someone who was (relative to me) very experienced with Excel. Essentially we have a sheet that sorts by descending dates, so the most recent entry is at the top of the sheet. The way the sheet is configured is that a bunch of cells in the Date Entered column has a placeholder date of 1/1/1900. Nearly all of these sort to the bottom of the sheet, but there was always one of those rows that we had in the top spot to fill out. Once the true date is entered and the sorting is updated that row will go to the correct spot in the list and a new placeholder row with the 1/1/1900 date appears at the top. At some point one of my co-workers did something to the sheet that stopped this from happening, and I do not know what my previous co-worker did to get that function to work because I cannot find anything in the column sort options. Thanks for the help!

submitted by /u/Landsharkeisha
[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#row zero#rows.com#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#financial modeling with spreadsheets#Excel alternatives#modern spreadsheet innovations#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#automation in spreadsheet workflows#no-code spreadsheet solutions#AI-powered spreadsheet#spreadsheet API integration#Excel