To do so, click on the Conditional Formatting option on the Excel toolbar: You may want values to stand out if they are over budget, or within a certain time frame. ![]() This nifty feature allows you to set rules to make cells change their appearance depending on their contents. So C2 would become $C2 (or $C$2 if you want to keep both). If you are dragging horizontally instead of vertically, just add the $ in front of the column letter. When we then drag to autofill, it will change the data without a $, so the B5 will become B6 but C2 will remain unchanged. So, we simply add a dollar sign ‘$’ in front of the data we want to keep locked in - it will always apply to the number/letter directly to the right of the $. Keeping with the above example, when we look at the ‘Days remaining’ formula, we want to keep the ‘Today’ data absolute. ![]() By adding a dollar sign ‘$’ to a formula, it makes the data absolute (always the same). Sometimes when you want to autofill, you might want to keep some of the data consistent.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |