Transfer Sheets from One Excel 2013 Workbook to Another
How to Merge Changes from Different Excel 2013 Users
How to Save Excel 2013 Worksheets as HTML Files

How to Change the Recent Files Settings in Excel 2013

Excel 2013 automatically keeps a running list of the last 25 files you opened in the Recent Workbooks list on the Open screen when the Recent Workbooks option is selected under Places. If you want, you can have Excel display more or fewer files in this list.

To change the number of recently opened files that appear, follow these simple steps:

  1. Choose File→Options→Advanced or press Alt+FTA to open the Advanced tab of the Excel Options dialog box.

  2. Type a new entry (between 1 and 50) in the Show This Number of Recent Documents text box located in the Display section or use the spinner buttons to increase or decrease this number.

  3. Click OK or press Enter to close the Excel Options dialog box.

If you don’t want any files displayed in the Recent Workbooks list, either on the Excel or Open screen in the Backstage view, enter 0 in the Show This Number of Recent Documents text box or select it with the spinner buttons.

Select the Quickly Access This Number of Recent Workbooks check box on the Advanced tab of the Excel Options dialog box (right below the Show This Number of Recent Workbooks option) to have Excel display the four most recently opened workbooks as menu items at the bottom of the File menu in the Backstage view.

You can open any of them by clicking its button even when the Open screen is not displayed. If four workbook files is too many or not sufficient, you can change the number of files shown at the bottom of the File menu by replacing 4 in the text box that appears to the right of the Quickly Access This Number of Recent Workbooks check box option.

blog comments powered by Disqus
How to Protect a Document in Excel 2013
How to Embed and Link Data from Excel 2013 into Word 2013
Share Excel 2013 Workbooks Saved on Your SkyDrive
How to Assign Graphic Images as Excel Worksheet Backgrounds
How to Enable Excel Cell Range Editing by Certain Users
Advertisement

Inside Dummies.com