Some of the content in this topic may not be applicable to some languages.
Enter the reference for the range of real or complex data you want to transform. Complex data must be in either x+yi or x+yj format. The number of input range values must be an even power of 2. If x is a negative number, precede it with an apostrophe ( ' ). The maximum number of values is 4096.
Select if the first row of your input range contains labels. Clear if your input range has no labels; Microsoft Excel generates appropriate data labels for the output table.
Enter the reference for the upper-left cell of the output table. Excel automatically determines the size of the output area and displays a message if the output table will replace existing data.
Click to insert a new worksheet in the current workbook and paste the results starting at cell A1 of the new worksheet. To name the new worksheet, type a name in the box.
Click to create a new workbook and paste the results on a new worksheet in the new workbook.
If selected, the data in the input range is considered transformed and an inverse transformation is performed, returning the original inputs. If cleared, the data in the input range is transformed in the output table.