Is there a way to automatically fill the “DATE” when creating a new worksheet tab....Please help..
Thank you
A date for the whole worksheet? A date in a column? Where?
I have a workbook in excel, and when I create a new worksheet, it show as "Sheet 1", but I want it to automatically create or fill the dates. Not the column but the Worksheet tab. I want to automatically fill the date for all the worksheet tab. I hope this make sense.
Thank you.
Fill on the sheet tabs at the bottom of work book.
Example:
Like 1-1-13, 1-2-13, etc. through 1-31-13.
I don't think you can do that, but let me search for something, and I'll let you know what I find.
See if this helps:
http://www.ozgrid.com/forum/showthread.php?t=24095
I need help with advance excel homework anyone online now that can help?
Yes, there is a way to automatically fill the "DATE" when creating a new worksheet tab in applications like Microsoft Excel or Google Sheets.
To achieve this, you can use a formula or a script depending on the specific software you are using.
In Microsoft Excel, you can use the following formula to automatically populate the date in a cell:
1. Select the cell where you want the date to appear.
2. Type the formula "=TODAY()" (without the quotation marks).
3. Press Enter. The cell will display the current date and automatically update it every day.
In Google Sheets, you can follow these steps to automatically fill the "DATE" in a worksheet tab:
1. Open a new sheet or navigate to the sheet where you want to insert the date.
2. Click on the cell where you want the date to appear.
3. In the formula bar at the top, type "=TODAY()" (without the quotation marks).
4. Press Enter. The cell will display the current date and will update it every day.
By using these formulas, the "DATE" will be automatically filled whenever you create a new worksheet tab.