PC Review


Reply
Thread Tools Rate Thread

Copying Excel page formatting to other pages

 
 
=?Utf-8?B?Y3JhenljYW51Y2s=?=
Guest
Posts: n/a
 
      5th May 2006
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).
 
Reply With Quote
 
 
 
 
Pete_UK
Guest
Posts: n/a
 
      5th May 2006
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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying web pages onto Excel Spreadsheets using VBA kenrock Microsoft Excel Programming 5 17th Sep 2009 05:24 AM
row headings on pages - proper formatting in page set up =?Utf-8?B?Y29ubmll?= Microsoft Excel Misc 1 18th May 2006 07:13 PM
Copying from excel to txt + formatting. Shekhar Thakurdesai Microsoft Excel Programming 1 1st Oct 2004 01:03 AM
copying page formatting ben rankin Microsoft Excel Worksheet Functions 1 19th May 2004 08:51 PM
adjusting scroll bar size and keeping page setup when copying pages Jeremy Oldham Microsoft Excel Misc 1 1st Mar 2004 02:00 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:21 AM.