Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I'm a new user of Microsoft Office 2003 and am having trouble finding help
information on how to copy Excel formatted sheets (pages) to other sheets to ensure the formatting is the same on additional sheets (pages). |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
One way is to just CTRL-drag the sheet - this will create a copy of the
original sheet (together with all formats and column widths), but, of course, will also include any data or formulae. Another way is to highlight all the cells in the first worksheet (click the intersection of the row and column identifiers) and click <copy, then click the second worksheet tab, ensure that the cursor is in A1 and Edit | Paste Special | Formats (check) and OK, followed by <Esc. The Format Painter can also be used. Hope this helps. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Launch new browser window from an excel web page | Excel Discussion (Misc queries) | |||
Excel 2003 - Copying formatting through 12 worksheets | Excel Discussion (Misc queries) | |||
Excel changing number formatting and source data in graphs on it's own!!! | Excel Discussion (Misc queries) | |||
lose formatting (border) in excel cell after pasting from word | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |