Closed Thread
Results 1 to 3 of 3

how to center excel sheet horizontally and verticaly on page?

  1. #1
    fitzbest
    Guest

    how to center excel sheet horizontally and verticaly on page?

    How to center excel sheet vertically or horizontally on a page ?

    Also how to change grid colours in excel ?

    Thanks

  2. #2
    Michael M
    Guest

    RE: how to center excel sheet horizontally and verticaly on page?

    File/Page Setup/Margins, and tick the centre vertically and horizontally.

    For grid line colours

    Tools/options/View select colour in gridline colour dropdown box.

    HTH
    Michael M

    "fitzbest" wrote:

    > How to center excel sheet vertically or horizontally on a page ?
    >
    > Also how to change grid colours in excel ?
    >
    > Thanks


  3. #3
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello fitzbest,

    To center the worksheet data horizontally and vertically for printing...

    On the main menu click File > Page Setup > Margins
    Check the boxes at the bottom labeled Horizontally and Vertically

    To change the Gridline Color...

    On the main menu click Tools > Options > View
    At the bottom there is a drop down labeled Colors. Click ot to see the available colors and click on the one you want.

    Sincerely,
    Leith Ross

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1