Impress your friends with how quickly you enter a series of dates in Excel Mar 27 2006
Q: I am a CPA and I need to create several similar spreadsheets in Excel in the same Workbook. Specifically, I need all the same Column and Row Headings in each spreadsheet. Is there a fast way to set this up without Copy/Paste?
A: Excel includes a very handy feature that will do this very thing. Let’s say you are creating several Spreadsheets that need to have the same series of Months across all the Spreadsheets (Sheet 1, Sheet 2, and Sheet 3). You can create this in one motion by:
1. Type-in the series of Months into a row of cells
2. Highlight the entire row of Months
3. Hold down the SHIFT key
4. Click on the ‘Sheet 2, Sheet 3, Sheet 4…’ tabs at the bottom of the screen to select the Sheets you want to have the Headings repeat
5. Edit > Fill > Across Worksheets…
6. Select ‘All’
7. Click ‘OK’
That’s it!
| 
