By . Expenses Spreadsheet. At Tuesday, May 25th 2021, 21:14:48 PM.
Change the Comment Font or Background Colour This is easy to do but needs to be done through your operating system not in Excel. For Windows 7: 1. Right-click the desktop and choose Personalize 2. Click Window Color at the bottom of the box that opens 3. Click Advanced Appearance Settings 4. Under Item, click the drop-down arrow and choose ToolTip 5. Make changes to the look of the ToolTip 6. Click OK 7. Click Save changes Any comments that already exist will remain unchanged, but new ones will take on the modified properties. Change the Shape of the Comment The command that allows you to do this is not on a ribbon, so you need to add it to your Quick Access Toolbar. 1. Choose More Commands from the QAT drop-down 2. Change Choose commands from to All Commands 3. Highlight Change Shape and click Add to include it in your QAT 4. OK the dialog box 5. Select the cell with the comment you want to change the shape of 6. Click Edit Comment in the ribbon 7. Hover your mouse along the edge of the comment until the cursor changes to the four way arrow and then click If the Change Shape command you added to the QAT continues to be greyed-out repeat step 7. The comment box must be active for the command to be useable. 8. Click the Change Shape button and choose the shape you want
Validate Your Input Values You can use Excels Data Validation function to reduce the likelihood of bad data. This feature allows you to specify the conditions a value needs to meet and reject any values that dont meet your conditions. If you know, for example, the minimum and maximum values of your data, simply instruct Excel to highlight values that fall outside of that range. To take it a step further, create a drop-down list of values in an adjacent workbook, then use those to populate your active one. Youll limit your potential for error by choosing from an already known list of values. No fat finger errors here. Automate the Whole Thing Were biased, but the easiest and best way to prevent errors in Excel is to automate your work. Todays automation software packages (and there are many) work within and between your spreadsheets and other sources of data, like websites, to import, manipulate, copy, paste, and format data however you wish. Some log critical process information, sorts, and transforms data just like you would - through the presentation layer of the application. Unlike you (no offense), good automation software works without errors. If youre a CPA or work for any other firm that uses spreadsheets on a regular basis, consider automation software as an alternative to those every day manual processes.
Hidden Rows and Columns. Unless you really need to hide any rows or columns, just dont. Why, well because they are hidden!. They can confuse users who are trying to follow the logic of a spreadsheet, users cant see them but Excel will still use those cells in calculations which can then appear to users to cause erroneous data. They can also cause issues with importing new data into your work book and issues with and VBA code. 3. Avoid Blank Cells, Rows and Columns. You may not always have a value for every single cell in your work book, but leaving cells completely blank has a massive impact on some functions in Excel. For example -AUTOSUM or using filtering with blank cells will affect Excels calculations. If you have blanks, always consider using zeros or an appropriate descriptive value such as NA.