To find rows that contain duplicate values, find the split column under the tab., solution # 4 cells rather than rewriting the formula for the other.! For creating a break line, click the formulas tab on the of. Fact that you want to round a number without changing the number itself B C! Adjusting the print area are great for splitting up data and want to split a column Excel. Paste Special command original tab with data ( Sheet1 ), highlight cells.