Formatting

  • Thread starter Thread starter Ansel
  • Start date Start date
A

Ansel

I sometimes need to edit extensive footnotes at the bottom
of a spreadsheet. This may mean moving words from one
line the next for several lines if I add something near
the top.

Suppose I have 10 lines of footnotes in cells A51 thru
A60, and they hang over the column boundaries to about
column H. After I add something to the first line, how do
I rearrange the lines so the edited footnotes don't go
past column H on any row. It's ok to add lines. I don't
want to have to edit each line manually.

Thanks for your help.
 
Hi Ansel,
You can merge cells A60:G60 and turn on cell wrap and copy
the formatted row down with the fill handle.
- Select cells A60:G60
- format, cells, alignment
-- merge cells
-- wrap cells
- if the rows below A60 are not filled in you can use the
fill handle, if the rows below
- if the rows below A60 are filled in you can use the format
painter. Select A60 (actually A60:G60) click on the
format painter toolbar button and then select the rows
below. Any content into cells other than the A column
will be lost.

http://www.mvps.org/dmcritchie/excel/merge.htm#builtin
http://www.mvps.org/dmcritchie/excel/fillhand.htm

You might be better off using a second worksheet for this because
merged cells interfer with sorting. If you use a second sheet
you only need to turn on cell wrap, you would not need to
merge cells, as you can adjust the column width..
 
Back
Top