LibreOffice – Formulae Auditing

2013-05-30 70 words 1 min read

If you have a excel sheet with lot of formula’s and you are trying to audit them, then a simple solution is to press “ctrl+`” (i.e. control key with back tick). This will put the excel sheet in Formula auditing mode and hence all the cells will show the formula rather than the values which will make it easier to audit them. Hope that helps.

Enhanced by Zemanta

author

Authored By Amit Agarwal

Amit Agarwal, Linux and Photography are my hobbies.Creative Commons Attribution 4.0 International License.

We notice you're using an adblocker. If you like our webite please keep us running by whitelisting this site in your ad blocker. We’re serving quality, related ads only. Thank you!

I've whitelisted your website.

Not now
This website uses cookies to ensure you get the best experience on our website. Learn more Got it