Any shortcuts to making several pages in an Excel book?

  • Thread starter Thread starter shadestreet
  • Start date Start date
S

shadestreet

Say I want to make a page for each day in a month, is there a faste
method than just right clicking and hitting insert page repeatedly?

What about quickly naming all pages?

Also, is there is a method to paste something to every page in
workbook, or do I need to do it page by page.

Thank
 
Hi Shadestreet

RE: Say I want to make a page for each day in a month, is there a faster
method than just right clicking and hitting insert page repeatedly?

Sure, if you hold down the Ctrl key you can select 12 sheets then Insert
and Excel will add 12 sheets.

Add one sheet then hit F4 X times.

Having said this though. I would say you heading into design problems
with so many sheets. It's best to keep all related data on 1 sheet in a
standard table format. That is, heading going across row 1 of your Table
and data laid out directly underneath.

See details on this in a past issue of my newsletter:
http://www.ozgrid.com/News/excel-spreadsheet-design.htm#ExcelTips


RE: What about quickly naming all pages?

Would require a macro

Also, is there is a method to paste something to every page in a
workbook, or do I need to do it page by page.

You can create a Template Worksheet, or use the Ctrl key to select the
sheets, then use Edit>Fill>Across Worksheets...

You can also use the Ctrl key to select x sheets then make the changes
to one sheet and all others will have the same data and formatting.

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
 
One way is to use a macro:

Option Explicit
Sub testme()
Dim iCtr As Long
Dim myDate As Date

'give any date in the month that you want
'in my example, I chose November of 2004.
myDate = DateSerial(2004, 11, 1)

For iCtr = 1 To Day(DateSerial(Year(myDate), Month(myDate) + 1, 0))
Worksheets.Add after:=Worksheets(Worksheets.Count)
ActiveSheet.Name _
= Format(DateSerial(Year(myDate), Month(myDate), iCtr), _
"mmm-dd-yyyy")
Next iCtr
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Back
Top