Showing posts with label shortcut to replace enter key. Show all posts
Showing posts with label shortcut to replace enter key. Show all posts

Sunday, March 18, 2012

Find and replace enter keys in excel

Most of the time while working excel we accidently end up typing Enter keys. We can easily find and replace the enter or Alt+Enter keys in excel cells.

Press Crtl+H
Now in Find text - Press Alt Key on your keyboard and type 0010 on numpad. Remember when you are typing on numpad keep the Alt key pressed. i.e, "Alt0010". You wont see any character in Find text.

Now keep replace with as blank

Press Find All to find the Alt+Enter Keys or Replace all to replace or remove them.