According to your description, some data cannot be displayed because the number of frozen columns is larger than the screen display width.The solution is to unfreeze and reset the appropriate width to freeze. First, open the Excel file and locate the column to be frozen.Right click the column and select Unfreeze in the pop-up menu. Then, adjust the width of the column to be frozen according to the screen display width.You can set a freeze of appropriate width by dragging the column title bar or using the Format Cells function. After completing the above steps, freeze again to solve the problem that data cannot be displayed.I hope it is helpful to you!
According to your supplement, the formula is simple Assume that two columns refer to columns a and b C1 cell input formula =if(a1="",b1,a1) Drop down Copy Formula
The question is whether to use the contents of cell a1 when cell a1 and cell b1 are different