Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" wrote in message ... 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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rows to repeat at BOTTOM. | Setting up and Configuration of Excel | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Tabs accross of bottom of sheet are not showing | Excel Discussion (Misc queries) | |||
Why can't I show or hide rows in an outline on a protected sheet? | Excel Discussion (Misc queries) |