Back to Blog
Construction estimator excel5/30/2023 Lock specific rows and columns in place so they are always visible. Hot tip – if using the Office 365 or online version, there is a log feature so changes can be easily identified and tracked to the team member that made them. Remember to save versions of your worksheets as project changes occur so you cover yourself from potential risk or litigation. For example, separate quantity and material description into different rows.ĭon’t forget to save versions for an audit trailĮxcel can’t show you the history of document versions. Putting multiple values in one cell makes it nearly impossible to analyze, enter a formula, categorize, or chart. Hot tip – if you share your spreadsheets with multiple users, you can protect the sheet so other users can’t unlock cells (Tools – Protection – Protect Sheet). Protect your work from unwanted changes by locking a cell or cell ranges. With one click, your complex formulas or special formatting can disappear. Your spreadsheets are full of precious data. Undo these common mistakes in your Excel practices:ĭon’t leave cells containing formulas unlocked It’s easy to make mistakes in complex spreadsheets containing multiple formulas, data sets, and multiple sheets.
0 Comments
Read More
Leave a Reply. |