No more excessive cutting and pasting - this does it all in a matter of seconds. From there, a popup will allow you to type in the term you want to find in the spreadsheet as well as the term you want to replace it with. Highlight the cells you want to choose from, then use the Ctrl + F hotkey (find). Instead of scrolling through all of your work to find each individual time the word is used, using “Find and Replace” can do it all at once. Whether you realized you made a mistake, you need to do some adjusting, or you’d like to change some terminology, the “Find and Replate” feature is a dream-come-true when it comes to customization. This works for rows as well, so the text will officially never get cut off, and you’ll never have to tediously drag the dimension for each cell ever again. Once that symbol appears, double click on the line that separates the columns, and the column will automatically be resized to fit the widest bit of text within that column. Place your cursor on the line between two column markers (A and B, for example) until you see a symbol that looks like two opposite-facing arrows. The solution? Let Excel do the work for you. You think you have things set, then you add another cell that has more text and you have to go and drag to resize over and over again. I know it’s a little thing in the grand scheme of life, but having to continuously resize my columns and rows has made me want to quit Excel more than once. It’s a useful hack for categorizing expenses! And now, anytime you select “Bills” from your dropdown list, the cell will automatically be colored red. If a cell contains certain text - say “Bills” - you can create a rule to make that cell red. Point to Highlight Cells Rules > and select More Rules.įrom here, you’ll create some rules. From Home, s elect Conditional Formatting in the Styles or Format menu. Select the cell(s) you want to add to the list. If you’re creating a budget, this might be Groceries, Rent, Bills, Entertainment, Restaurants. Type in the items you want to add to your list. Then, in Excel, s elect Data > Data Validation and then choose “List” in the Allow section. To pull this off, select all the cells you want to color code. If you want to utilize colors for different things, there’s a simple hack that will make digesting your info so much easier. Color code your cells automaticallyĬolor-coded drop-down lists are one of the easiest ways to decipher data at a glance. A few of my faves?Ī note for Mac users: Use the command button instead of control. Odds are, if you’re looking for a way to speed up the process, there’s a hotkey you’re not using that can help. Download this PDF and keep it handy on your desktop for when you work on your budget. While some you might want to memorize (like undo (Ctrl + Z) or redo (Ctrl + Y)), others you might just want to have handy for when you need them. While many of us have those hotkeys down thanks to Computer Science 101, there are plenty of other shortcuts that make working in Excel and beyond that much easier. No, it’s not exactly a customization hack, but the day I learned the shortcuts to cut (Ctrl + X), copy (Ctrl + C), and paste (Ctrl + V), my life was officially changed. Learn the shortcuts (and have them handy) Here’s how to do it your way - and in style.ġ. As someone who went from hating math to now having all of her funds automatically calculated, I can say hands-down just how helpful a budget can be. From utilizing hotkeys, color codings, and sizings (as well as all of the nifty formulas and tools available), I’m able to figure out my spendings, earnings, savings, and expenses each month. My secret? Other than LOTS of coffee, it’s a customized Excel budget. Now, six years later, I’ve managed to build a successful, money-making career. With a CPA father and an engineer brother, the concept of doing math just because seemed absurd.Īfter months of researching, confusion, and some pretty ballsy confidence for a girl who didn’t even have a credit card, I realized that to become successful, I needed to find a way to manage my money. Also as a 20-something writer, however, the thought of learning how to budget, crunch numbers, and perfect my spreadsheets sounded like a special circle of hell. As a 20-something writer, learning how to manage my money was necessary from the moment I walked across the graduation stage and realized I didn’t want to have a “normal” 9-5.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |