important files appear on top in Excel

Q7. In Excel how can I ensure that important files always appear on the recent Excel workbooks list?

For example, I would like to quickly access certain important Excel workbook(s) even if I have not opened the important workbook(s) recently.

To do it in Excel, here is the answer:

To ensure quick access to important Excel workbook(s),

a) Click on "Recent" option under "File" tab. Click the pushpin icon to the right of the file (example "Q1-50.xlsx" file in the screenshot) that is to be quickly accessed independent of recent activity.

excel important files appear on top

b) The Excel file becomes "pinned" to the list and will always appear at the top of the list. Notice the change in pushpin icon symbol.

excel excel important files appear on top

 

You can find similar Excel Questions and Answer hereunder

1) How can I extract file name from a full path?

2) how to combine the content of two or more cells in Excel

3) How can I plot 2 series on the same chart with different scales / measurement unit for Values (Ex: Pareto chart)?

4) I have to make an investment decision - I have the cashflow numbers. In Excel, how do I calculate Internal Rate of Return (IRR)?

5) How can I activate a routine when there is a change in value of a cell?

6) How can I add a background image to a worksheet?

7) How can I find the count of records that meet multiple conditions in my raw data table?

8) How can I find the least common multiple using Excel?

9) Vba list all files in a folder in Excel

10) I frequently use a Macro - is there a way to quickly access the Macro using a Keyboard Shortcut?

11) Is there a way I can recover unsaved work?

12) I have a big Table spanning across pages when printed - how do I get Excel to print titles in all pages?

13) How can I find the number of working days between 2 dates given a holidays list?

14) How do I get the principal part of loan payment for the year given Loan amount, Rate of Interest and period?

15) How can I identify all cells with Conditional Formatting in my WorkSheet?