+ Reply to Thread
Results 1 to 3 of 3

rows top-justified & bottom-justified in same sheet looks bad

  1. #1
    Jim 007
    Guest

    rows top-justified & bottom-justified in same sheet looks bad

    I am preparing a financial "spreadsheet." I have used underlining in some
    cells. (I think that is part of my problem) The spreadsheet is very
    unappealing to the eye because for some reason, some rows of text appear to
    be "top-justified" and some rows of text appear to be "bottom justified." I
    would much prefer to show all rows consistantly as "bottom justified"

    Also, what font and "point" size of text looks best in financial
    spreadsheets, I know it is a matter of taste but, what looks most "rich &
    professional" ???

    Thank you very much!

  2. #2
    David McRitchie
    Guest

    Re: rows top-justified & bottom-justified in same sheet looks bad

    Hi Jim,
    To format all cells as bottom justified,
    select all cells (Ctrl+A, or Ctrl+Shift+SpaceBar)
    Format, Cells, Alignment (tab), Vertical Alignment: Bottom

    I prefer bottom alignment for the top row of column headers, and
    top alignment for the all of the rest.
    Bottom alignment is the default.

    10 point Arial is the default font
    seems to work well.
    ---
    HTH,
    David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
    My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
    Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

    "Jim 007" <Jim007@discussions.microsoft.com> wrote in message news:1F9639ED-4C84-4CBD-A686-DC2B428BBD46@microsoft.com...
    > I am preparing a financial "spreadsheet." I have used underlining in some
    > cells. (I think that is part of my problem) The spreadsheet is very
    > unappealing to the eye because for some reason, some rows of text appear to
    > be "top-justified" and some rows of text appear to be "bottom justified." I
    > would much prefer to show all rows consistantly as "bottom justified"
    >
    > Also, what font and "point" size of text looks best in financial
    > spreadsheets, I know it is a matter of taste but, what looks most "rich &
    > professional" ???
    >
    > Thank you very much!




  3. #3
    Jim 007
    Guest

    Re: rows top-justified & bottom-justified in same sheet looks bad

    Hi David,

    Your advice worked perfectly !!! Thank you!!!

    --- Jim

    "David McRitchie" wrote:

    > Hi Jim,
    > To format all cells as bottom justified,
    > select all cells (Ctrl+A, or Ctrl+Shift+SpaceBar)
    > Format, Cells, Alignment (tab), Vertical Alignment: Bottom
    >
    > I prefer bottom alignment for the top row of column headers, and
    > top alignment for the all of the rest.
    > Bottom alignment is the default.
    >
    > 10 point Arial is the default font
    > seems to work well.
    > ---
    > HTH,
    > David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
    > My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
    > Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
    >
    > "Jim 007" <Jim007@discussions.microsoft.com> wrote in message news:1F9639ED-4C84-4CBD-A686-DC2B428BBD46@microsoft.com...
    > > I am preparing a financial "spreadsheet." I have used underlining in some
    > > cells. (I think that is part of my problem) The spreadsheet is very
    > > unappealing to the eye because for some reason, some rows of text appear to
    > > be "top-justified" and some rows of text appear to be "bottom justified." I
    > > would much prefer to show all rows consistantly as "bottom justified"
    > >
    > > Also, what font and "point" size of text looks best in financial
    > > spreadsheets, I know it is a matter of taste but, what looks most "rich &
    > > professional" ???
    > >
    > > Thank you very much!

    >
    >
    >


+ Reply to 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