ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can parital cells be underlined w/o inserting blank columns? (https://www.excelbanter.com/excel-discussion-misc-queries/90930-can-parital-cells-underlined-w-o-inserting-blank-columns.html)

FinancialStmtProb2006

Can parital cells be underlined w/o inserting blank columns?
 
Is it possible to have uniform underlining in a column , regardless of cell
content?

For example, an accounting statement adds 5 numbers in columsn A, B and C ,
A has a 5th number of 50,000, B has a 5th number of 5,
If I underline the entire cell, when it prints the line is continuous form
row to row. If you underline only cell content - the underline will be vary
greatly from column to column.

Any thoughts ?

Bernard Liengme

Can parital cells be underlined w/o inserting blank columns?
 
It appears you are not underlining but adding a cell border.
Try selecting the cells and then underline with either the tool (looks like
U) or the shortcut CTRL+U
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"FinancialStmtProb2006"
wrote in message ...
Is it possible to have uniform underlining in a column , regardless of
cell
content?

For example, an accounting statement adds 5 numbers in columsn A, B and C
,
A has a 5th number of 50,000, B has a 5th number of 5,
If I underline the entire cell, when it prints the line is continuous form
row to row. If you underline only cell content - the underline will be
vary
greatly from column to column.

Any thoughts ?




FinancialStmtProb2006

Can parital cells be underlined w/o inserting blank columns?
 
I'm looking at the accounting ofrmat, that will do what I need, BUT I also
beed ot diplay zero values. Can that be done ?????

"Bernard Liengme" wrote:

It appears you are not underlining but adding a cell border.
Try selecting the cells and then underline with either the tool (looks like
U) or the shortcut CTRL+U
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"FinancialStmtProb2006"
wrote in message ...
Is it possible to have uniform underlining in a column , regardless of
cell
content?

For example, an accounting statement adds 5 numbers in columsn A, B and C
,
A has a 5th number of 50,000, B has a 5th number of 5,
If I underline the entire cell, when it prints the line is continuous form
row to row. If you underline only cell content - the underline will be
vary
greatly from column to column.

Any thoughts ?






All times are GMT +1. The time now is 04:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com