Skip to main content

TIP - 51 : Pin the excel work books from Home


Pin the excel work books from Home

There is no need for us every time to go the folders and open all the excel files which were used frequently or daily basis.

We have trick which helps to save a lot of time -

Step 1: Please click on File menu, then click on Home

Step 2: Then click on “Recent”, select the excel file, then at the end of the file there appears a symbol of pin (), click on that symbol.

That’s all… the file appears in the category of Pinned under Home (shown in image below)

Comments

Post a Comment

Popular posts from this blog

Report Publishing via Pivot Table in different sheets

Report Publishing via Pivot Table in different sheets This feature is mostly helpful to publish the data in sheet wise Step 1: Create pivot table with Report filter , go to analysis tab or Options tab from "PivotTable options" Step 2: Click on options drop down Step 3: Then click on  “Show report filter pages” Now we can see the new excel sheet tabs names along with data, published based on the report filtered data.
Post a Comment
Read more