ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Alt Enter (https://www.excelbanter.com/excel-discussion-misc-queries/216331-alt-enter.html)

LIZZIE

Alt Enter
 
I have a lot of ' ALT Enter's' In my worksheet. Therefore the writing of the
rest of my work sheet is not lining up properly
How can I undo them without having to retype all?

Thanks

Dave Peterson

Alt Enter
 
Do you want to change them to a space character?

Select the range to fix (all the cells???)
Edit|replace
what: ctrl-j (hold the control key while hitting the j key)
with: (spacebar)
replace all



Lizzie wrote:

I have a lot of ' ALT Enter's' In my worksheet. Therefore the writing of the
rest of my work sheet is not lining up properly
How can I undo them without having to retype all?

Thanks


--

Dave Peterson


All times are GMT +1. The time now is 03:49 PM.

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