bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > Workbooks > Renaming a Workbook

Renaming a Workbook

Summary: Want to rename a workbook without leaving Excel? It may be easy enough to do in Windows, but you can also use Excel’s Open dialog box to make the filename changes you desire. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

There is no intrinsic command within Excel that allows you to rename workbooks or files, as there is in some other programs. It is true that you can simply save a workbook out under a new name, but that results in two files on your drive instead of one. You can use the following steps to rename a workbook quickly and easily, all within Excel:

  1. Make sure the workbook you want to rename is not loaded into Excel. (Close it if it is loaded.)
  2. Click on the Open tool on the toolbar, or choose Open from the File menu. Excel displays the Open dialog box.
  3. In the list of files contained in the dialog box, right-click on the one you want to rename. This displays a Context menu for the workbook.
  4. Choose Rename from the Context menu. The workbook name is highlighted, and you have the opportunity to change the name.
  5. Once the document name is changed, press Enter.
  6. Close the Open dialog box by clicking on Cancel.

Tip #2234 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003


Save Time! You can have this tip (and several hundred just like it) in the ExcelTips annual archives. Imagine having over 400 tips available at your fingertips, in each annual volume.

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home
Vital News Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)