Hello Friends, After almost 2 months I have got time from my normal bid management work to share something new on Excel with you. But before that I would like to say thanks to all my blog reader for visiting my posts regularly. I would also like to thank to all the viewers in my Facebook page.
Let's come back to the point- Many a times it might have happened to all that after sending report to your manager it bounces back - saying this has been copied from some old customer reports. Isn't it? Because we tend to work on an existing file always. We tweak them and make them as per the current requirements but forget to change/update the file properties.
In MS Excel, we have an option called "Inspect Document". This helps user to check the workbook for hidden properties and personal information.
For this you have to go to the FILE Ribbon and click "Check for Issues". This will have the option "Inspect Document". Upon clicking this you will get "Document Inspector" dialog box. Here you have to continue by clicking the "Inspect" button. Thereby you will see all the hidden properties. You may like retain them or Excel will provide an option of Removing them all.
Hope this helps.
For more information on how to do this, please get in touch with me at Samrat.Biswas@ hotmail.com or Samrat.biswaas@gmail.com
Friends, Now Excel in MS Excel is available in Facebook as well. You can quickly raise your MS Excel related queries in its platform. I will try to resolve them.
Visit Other MS Excel Tips and Tricks
How to create drop down menu in MS Excel?
Samrat Biswas, Six Sigma (Green Belt), MOS Excel Expert 2013, ITIL 2011 Foundation
Advanced MS Office (Excel, Word, PowerPoint, One Note, Outlook), and MS Visio
---------------------------------------------------------------------------------------------------------
Be a part of regular Weekend Knowledge Sharing Sessions
Reach me @ +91 8095039316/ +91 8095039315
https://www.facebook.com/Samrat.Biswas
Let's come back to the point- Many a times it might have happened to all that after sending report to your manager it bounces back - saying this has been copied from some old customer reports. Isn't it? Because we tend to work on an existing file always. We tweak them and make them as per the current requirements but forget to change/update the file properties.
In MS Excel, we have an option called "Inspect Document". This helps user to check the workbook for hidden properties and personal information.
For this you have to go to the FILE Ribbon and click "Check for Issues". This will have the option "Inspect Document". Upon clicking this you will get "Document Inspector" dialog box. Here you have to continue by clicking the "Inspect" button. Thereby you will see all the hidden properties. You may like retain them or Excel will provide an option of Removing them all.
Hope this helps.
For more information on how to do this, please get in touch with me at Samrat.Biswas@ hotmail.com or Samrat.biswaas@gmail.com
Friends, Now Excel in MS Excel is available in Facebook as well. You can quickly raise your MS Excel related queries in its platform. I will try to resolve them.
Visit Other MS Excel Tips and Tricks
How to create drop down menu in MS Excel?
Samrat Biswas, Six Sigma (Green Belt), MOS Excel Expert 2013, ITIL 2011 Foundation
Advanced MS Office (Excel, Word, PowerPoint, One Note, Outlook), and MS Visio
---------------------------------------------------------------------------------------------------------
Be a part of regular Weekend Knowledge Sharing Sessions
Reach me @ +91 8095039316/ +91 8095039315
https://www.facebook.com/Samrat.Biswas
