ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Cell Underline problem underlines across width of cell (https://www.excelbanter.com/excel-worksheet-functions/196064-cell-underline-problem-underlines-across-width-cell.html)

tshoop7

Cell Underline problem underlines across width of cell
 
Hi,
Need solution for cell underline problem. When I warp text in a cell and
then try to underline only the first word in that cell, it puts an underline
the width of that cell when I only wanted just the characters of the word
underline; it continues after the word to underline thereby underlining the
space after it. How can I correct this?

Pete_UK

Cell Underline problem underlines across width of cell
 
Suppose you have the text "This is a test" in a narrow cell set to
word wrap so that you see :

This
is a
test

and you just want to underline the word This. Select that cell and in
the formula bar highlight just the word This by positioning the cursor
before the T, holding down the left mouse button and then dragging to
the end of the word. Then you can click the underline symbol and press
<enter, and you will see just that word underlined. You can only do
this manually (or with VBA).

Hope this helps.

Pete

On Jul 23, 11:35*pm, tshoop7
wrote:
Hi,
Need *solution for cell underline problem. *When I warp text in a cell and
then try to underline only the first word in that cell, it puts an underline
the width of that cell when I only wanted just the characters of the word
underline; it continues after the word to underline thereby underlining the
space after it. *How can I correct this?




All times are GMT +1. The time now is 09:44 PM.

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