R
rupert
I have 569kB excel 2007 spreadsheet where a lot of text has been entered into
cells. A thousand cells in column C each have several paragraphs or more of
text.
I have filtering on one column so I can select relevant text in adjacent
cells.
I find that the spreadsheet screen does not finish refreshing after a
filter. so that the cells in column A apprea reluctantly if at all unless I
start clicking on the cells.
Excel isnt designed to act as a text storage retrieval tool - but lots of
people use it this way.
Please help with solution on how to get the screen to refresh correctly.
cells. A thousand cells in column C each have several paragraphs or more of
text.
I have filtering on one column so I can select relevant text in adjacent
cells.
I find that the spreadsheet screen does not finish refreshing after a
filter. so that the cells in column A apprea reluctantly if at all unless I
start clicking on the cells.
Excel isnt designed to act as a text storage retrieval tool - but lots of
people use it this way.
Please help with solution on how to get the screen to refresh correctly.