Question

2. Describe how you save a file with a new filename in Excel.

Answer 1

After you set up a workbook and save it, you can call it by another name. Saving an existing file with another name retains the original, uncontaminated copy of the file. You could create an expenditure report or budget at the workplace , for example, and then save subsequent changes to different filenames. Or you may be using different versions of a workbook to forecast or model. You can then easily delete the versions of a file which you don't need.

Click the File menu Tab, and select Save As. The Save As dialog shows up with the file name highlighted in the File Name tab.

If you want to allocate a completely new filename, you will start typing the name you want. Your text overwrites the name already in the file.

If you wish to change the current filename, click in the File Name box and edit the name displayed

(Optional) Click the drop-down arrow next to the Save In folder name, and move to a different drive or tab.

Click the Save button. The Save As dialog box closes and the new filename is displayed on the title bar.