ExcelBanter - Moving text around cells without moving boarder lines

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Moving text around cells without moving boarder lines (https://www.excelbanter.com/excel-discussion-misc-queries/251083-moving-text-around-cells-without-moving-boarder-lines.html)

Dale

Moving text around cells without moving boarder lines

I have high lited some cells and put boardes lines around these cells.Can you
move text around these cells without moving boarder lines?

T. Valko

Moving text around cells without moving boarder lines

If you mean dragging the cells to other locations, well, when you drag the
formatting comes along for the ride!

You can do:

If the cell(s) contain constants...

CopyPaste SpecialValues

If the cell(s) contain formulas...

CopyPaste SpecialFormulas

--
Biff
Microsoft Excel MVP

"Dale" wrote in message
...
I have high lited some cells and put boardes lines around these cells.Can
you
move text around these cells without moving boarder lines?

All times are GMT +1. The time now is 10:08 AM.