Results 1 to 5 of 5
  1. #1
    4 Star Lounger pauliez's Avatar
    Join Date
    Dec 2003
    Location
    Connecticut, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel (Set up work sheets)

    I have many work sheets in a work book and would like to know if there is a way to set up all the margins, row height, column width etc. for each work sheets, which are all the same in every work sheet with out going to each work sheet to do the set up task?
    Catz

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel (Set up work sheets)

    Right-click any sheet tab and select "Select all sheets" from the popup menu.
    Click in the upper left corner (to the left of the column headers A, B, ... and above the row headers 1, 2, ...) to select all cells.
    You can specify page margins, headers and footers etc. for all sheets at once in File | Page Setup...
    You can set row height, column width etc. for all sheets at once.
    Be careful: if you enter any data in a cell now, you'll enter it in all sheets!
    When you're done, click another sheet tab, or right-click a sheet tab and select "Ungroup sheets" from the popup menu.

  3. #3
    4 Star Lounger pauliez's Avatar
    Join Date
    Dec 2003
    Location
    Connecticut, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel (Set up work sheets)

    Thanks Hans. Your info worked just fine for me. It is going into my Excel tool box.

    Also, there is something odd happening when I try to log into this site. It opens up to the page with only the title "Words on high" and just sits there with that title only for well over 60 seconds before the drop down list appears. It never did that in the past. When ever I log into this site in the past it would open to the page with "Words on High" and the drop down list. This is the only site I have that problem with.
    Catz

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel (Set up work sheets)

    There appears to be a problem with either the server that hosts Woody's Lounge, or with the connection from that server to the outer world, causing the download speed of pages to vary wildly - sometimes it's fast, at other times extremely slow. See the thread slow down in Lounge Matters.

  5. #5
    4 Star Lounger pauliez's Avatar
    Join Date
    Dec 2003
    Location
    Connecticut, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel (Set up work sheets)

    Thanks Hans. I posted my reply at the page you posted for me to read. I hope that helps.
    Catz

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •