Help! New to Excel

Occasional Visitor


Hello community!


Please forgive the newb questions I will undoubtedly be asking, starting with this one:


How do I format a single cell to show JUST the current year?


I am creating a document template that will be used and updated daily, possibly several times a day, throughout the year and needs to be saved for tax purposes annually.  


I would like the first row to include the document title which starts with the current year, in large bold text, followed by the rest of the title.  When I go to start 2022, I will save the template as a new doc for the year, and I would like for the year to automatically change from 2021 to 2022 when I do this.  I will only be accessing the template once a year and 'saving as' at the start of each year.  


I'm fairly confident this is not hard, but I cannot seem to figure it out!  Ugh. 

Thank you, in advance, for your help!




2 Replies
With your permission, if I can correct the language


Thank you