Input range should be in Contiguous Reference Error in EXCEL - DOUBT clarified

In Data - Data analysis tool, the input data if not accepted by Excel, the following error shows. "Input range should be contiguous reference". This can be overcome by selecting File - Option - Customize ribbon - Formulas - Working with Formulas - Check the check box R1C1 reference style. The data analysis will work now. This has been visually explained in this video. However the column headings in Excel have changed from A,B... to numerical order 1 2 3 .. This may be noted for further working with Excel.