My last Excel Saturday post shared some commonly used handy short cuts for everyone to use. Recently I learned about some other short cuts that aren’t so common but I think a lot of people could really benefit from knowing them. They will likely make your work in excel so much more efficient!
- F2 will allow you to edit the active cell you are working in.
- Press F4 after F2 and an absolute reference (which is also known as cell anchoring) notation will be applied to the cell coordinates. Repeat to cycle through the different types of cell anchoring. (ex. =$A$2)
- Ctrl + Shift + % will apply the Percentage format (%) with no decimal places.
- Ctrl + Shift + $ will apply the Currency format ($) with 2 decimal places and will show negative numbers in parentheses.
- Ctrl + ‘ will copy the formula from the cell directly above the active cell you are working in into the Formula Bar.
- Ctrl + ” will copy the value from the cell directly above the active you are working in into the Formula Bar.
- Ctrl + Y will repeat the last command or action that you made.
- Ctrl + Z will undo the last command or action that you made.
- Alt + Enter will allow you to go to the next line in the same cell you are working in.
- Alt + I + M will enter a comment into the cell you are working in.
These are just a few of the recent short cuts that I learned about. I hope these help to improve your efficiency while working in Excel. If you have any favorite short cuts that you would like to share we would love to hear about them! Comment below with any short cuts that you use.
And, as always if you have any questions do not hesitate to ask.
Your brain is a muscle and just like any other muscle in your body if you don’t use it then you lose it. Continuing to seek out new knowledge is important to keep your brain healthy and active. By keeping your brain healthy and active will result in your business running smoother and more efficiently! There are several ways to incorporate continuing education into your business to expand your knowledge. Here are a few of my favorite ideas:
When companies start looking at marketing strategies one thing they often don’t realize is that the best marketing asset they have is right underneath their nose. Their current customers are their best assets in the community to provide referrals, recommendations, and reviews to other potential customers. Most people conduct some research before hiring someone to work with them so incorporating that into your marketing plan is important. Nowadays the world is reliant on the internet so spreading the word has become easier than it ever was before. But the trick is you may have to ask your customers for these referrals, reviews, or recommendations. If your customers are happy then most of the time they would be happy to do so! Here are a few tips about how to get these ideas into action!
business owner first starts out they are often looking for ways to reduce expenses to get going. One of the bigger expenses can be setting up and maintaining your books. Often times business owners will look to a family member to keep their books for them not realizing the pros and cons that go along with this decision.
Using your financial statements to measure your business is one way to make sure that you and your business is moving in the right direction. In order to accomplish this you need a few things.
Seven best business practices for small businesses. Are you following them? Click here to 
Eagle Eye Bookkeeping Services 