Forum Discussion
How to replace without destroying formatting and in-cell-linebreak?
I want what in the red circle. Using replace in excel destroys formating. Using replace in word doesn't destroy formating, but pasting back to excel destroys linebreaks in one cell (alt+enter...
This doesn't look like an appropriate use of Excel in the first place; why aren't you just doing the task (whatever it is) in Word? Is there something off screen that mandates Excel?
Yes, want to memorize vocabulary using excel, for its function suits this purpose better than other softwares.
- Which "Excel function" suits the purpose of helping memorize vocabulary?
You've already said that Word works better in the Find and Replace function. Word also has its own Tables--i.e., rows and columns--for organizing data systematically. So what else is unique to Excel that you're referring to?The excel’s suitable function is making the window 3x1, leaving one row and three columns shown. If recognizing the word, then press enter to go to the next row; if not, go to the fourth column to see the explanation, and type “1” in the third column, then go back to the left end, then go down to the next row. After finishing one turn, sort the third column to make rows with “1” be at the top, so they can be reviewed with priority. If still not recognized, change “1” to “2”, so sorting again makes rows with “2” be at the top, then rows with “1”, then words recognized.
- press ctrl+shift+→ to see the explanation
why need press ctrl+shift+→ to see the explanation？
As far as I know press ctrl+shift+→ is to select current row.
Why do you need select the second column?
if not recognize the word,
it looks more reasonable is to press ctrl+→ move to select the third column cell and enter 1.
Word table do not good at filter by the priority.
maybe record a macro to handle it.
