Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

How do I make sheets in a spreadsheet look the same?

  • 10-07-2007 05:23PM
    #1
    frobisher
    Registered Users, Registered Users 2 Posts: 2,413 ✭✭✭


    I started within one sheet, a template I got from someone, with all my data inputed it looked and printed fine. I then added 2 more sheets which I cut and pasted the info from sheet one and amended it as required. Unfortunately when I print or print preview sheets 1 & 2 they look totally different and are completely spread over several pages. How can I get the format of to be like that of the original sheet?


Comments

  • #2
    chump
    Closed Accounts Posts: 3,807 ✭✭✭chump


    frobisher wrote:
    I started within one sheet, a template I got from someone, with all my data inputed it looked and printed fine. I then added 2 more sheets which I cut and pasted the info from sheet one and amended it as required. Unfortunately when I print or print preview sheets 1 & 2 they look totally different and are completely spread over several pages. How can I get the format of to be like that of the original sheet?


    instead of copyandpaste right click original sheet and go create copy, and tic move to end... exact replica - or should be


  • #3
    Newaglish
    Registered Users, Registered Users 2 Posts: 2,734 ✭✭✭Newaglish


    If the data is in the same colums/cells, you can highlight all of sheet 1, hit "format painter", then go to sheet 2 and click the A1 cell. Voila!

    If you're talking about printing, go to File\Page Setup then select "Fit to" and then x pages tall and x pages wide. I think that's the problem you're having? Also change to landscape from portrait if necessary.


Advertisement