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...
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.
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.