In Excel most most the most useful function is data fluoroscopy watch, but it always can have too much little problem, let a novice be at a loss what to do. Excel data fluoroscopy is expressed, fasten so embarrassed novice?
One, cannot found data fluoroscopy to express
If there is amalgamative and unit case in data source watch, cause caption behavior sky, can hint field name disables. . . .
2, the format after updating was done not have
After line of setting of data fluoroscopy watch is broad or after other form, the format be no longer in force that sets after refresh.
3, computation vexed
Ask: Make finished data fluoroscopy express indication computation, why be sue for peace?
4, date cannot in group
Ask: Why date cannot use assorted function, by month form?
Answer: Date row contains the cost that is not date format, include text, number or empty cost
5, " sue for peace: "Cannot delete
If want to delete " sue for peace: " a few words, meeting clew is wrong. The means of settlement is replace for blank space
