How to scroll down till find a unmarked box in excel

tugay.arslan · July 15, 2022, 9:11am

Hi all, can anybody help me to “how to scroll down till find a unmarked box in excel”. My aims to marked the all box in 2022 year.

THIRU_NANI · July 15, 2022, 9:40am

Hey!

Try the 2022.7 preview studio…

We have filter pivot table option is available

You can manage everything from there…

Regards,
NaNi

tugay.arslan · July 15, 2022, 1:31pm

Firstly, thank you for help. I am confused regarding

making date filtering. Would you help me to get only 2022 year in excel file.

Best Regards,

THIRU_NANI · July 15, 2022, 1:32pm

Hey!

You can give the Date which you wants to check

Now.ToString("yyyy")

This will give you the present year

Regards,
NaNi

tugay.arslan · July 15, 2022, 2:03pm

Problem is resolved. Thanks a lot.

Have a good day,

system · July 18, 2022, 2:03pm

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.