Select the sheet with the formatting you want to replicate.

CTRL + Click on other sheet.

FilePage SetupOK


Gord Dibben MS Excel MVP

On Thu, 17 Jul 2008 08:40:03 -0700, M Kan <tipsoftheweek at gmail dot com
wrote:

In Excel 2003, I thought there was a shortcut key for applying sheet level
formatting (e.g., margins, headers, footers, etc) from one sheet to another,
but can't seem to find it anywhere.