Friday, 10 April 2020

How print the all Names in Excel you created



How print the all Names in Excel you created

You can get all the Names you created in your Workbook along with their References and Save them and also Print Them.
Steps are given below
1.   Click an empty cell where you want to Copy the Names in your workbook.

2.   Click “Formulas” and then “Use in Formula”


3.   Click “Paste Name” from drop-down list.


4.   A Paste Name dialog box open on your screen.
5.   Click “Paste List”

6.   The List of Names and their corresponding references are copied at the location where you select an empty Cell (F7).

7.   Now you can Save the worksheet and Print it for future purpose.

No comments: