close

I am preparing a financial quot;spreadsheet.quot; 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 quot;top-justifiedquot; and some rows of text appear to be quot;bottom justified.quot; I
would much prefer to show all rows consistantly as quot;bottom justifiedquot;

Also, what font and quot;pointquot; size of text looks best in financial
spreadsheets, I know it is a matter of taste but, what looks most quot;rich amp;
professionalquot; ???

Thank you very much!

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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Jim 007quot; gt; wrote in message ...
gt; I am preparing a financial quot;spreadsheet.quot; I have used underlining in some
gt; cells. (I think that is part of my problem) The spreadsheet is very
gt; unappealing to the eye because for some reason, some rows of text appear to
gt; be quot;top-justifiedquot; and some rows of text appear to be quot;bottom justified.quot; I
gt; would much prefer to show all rows consistantly as quot;bottom justifiedquot;
gt;
gt; Also, what font and quot;pointquot; size of text looks best in financial
gt; spreadsheets, I know it is a matter of taste but, what looks most quot;rich amp;
gt; professionalquot; ???
gt;
gt; Thank you very much!
Hi David,

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

--- Jim

quot;David McRitchiequot; wrote:

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()