Forum Discussion
How to replace without destroying formatting and in-cell-linebreak?
Yes, want to memorize vocabulary using excel, for its function suits this purpose better than other softwares.
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.I remembered wrongly the key. I mean go to the fourth column, which cannot be seen initially in 3x1 window. Edited it.
