How to scroll down till find a unmarked box in excel

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.

Hey!

Try the 2022.7 preview studio…

We have filter pivot table option is available

You can manage everything from there…

Regards,
NaNi

1 Like

Hi @THIRU_NANI ,

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,

Hey!

You can give the Date which you wants to check

Now.ToString("yyyy")

This will give you the present year

Regards,
NaNi

1 Like

Problem is resolved. Thanks a lot.

Have a good day,

1 Like

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