Spending more time than necessary in an Excel spreadsheet is the bane of an accountant’s existence. Often times when working on a spreadsheet we spend more time playing around with formatting and attempting to get the cells to do what we want than we actually spend manually inputting data. If you’re in the accounts receivable department, there are probably a thousand different tasks that would be more productive, such as making phone calls, than playing around in a spreadsheet. Below we have highlighted 5 Excel shortcuts to make formatting and navigation easier.
SELECT ENTIRE TABLE
If you want to select certain rows and columns including data, but not the surrounding empty cells, use this handy trick.
NAVIGATE THROUGH WORKSHEETS AND WORKBOOKS
There is nothing more frustrating than trying to move data from one worksheet or workbook to another and having to manually click back and forth. This wastes tons of extra time and, if you have multiple sheets or books open, runs the risk of inputting data in the wrong one. If you can easily toggle back and forth, you have an easier time editing.
Note: A workbook is the entire Excel spreadsheet and worksheets are the sub-pages that exist within them.
To move to the next worksheet:
To move back to a previous worksheet:
To toggle between workbooks:
COPY AND EDIT FORMULAS
Even trying to copy a formula from one cell and edit it in another can prove to be a difficult task in Excel. Sometimes editing a copied formula take multiple attempts and the cells can just be stubborn, then you are left wondering if the correct formula is even being used, compromising your data. In order to do this easily, use these keystrokes.
Pressing the control key and the apostrophe key will paste the formula in the above cell, below and immediately enter edit mode.
Sometimes you want to enter a number into an excel worksheet as a specific format, such as with a certain number of decimal places, as a date or a time. Excel usually does not automatically recognize this formatting and you have to manually highlight the cells and change the formatting using tools. These shortcuts will save time from formatting numbers.
Formatting with two decimal places
Format as Time
Format as Date
Format as Currency Value
Format as Percentage
Format in Exponential Form
DETECT ALL CELLS LINKED TO A FORMULA
If someone sends you a report in the form of a spreadsheet, it’s important to make sure you know how the data was discovered and calculated. Especially if the formulas are complicated and rely on data from other cells, you need to quickly find out where the end results came from. The following shortcut will allow you to see all the cells that are linked to a formula and then you can drill down to see exactly what that formula is.
First, highlight all the cells that have a value and then use:
17 TIPS FOR REDUCING OUTSTANDING ACCOUNTS RECEIVABLE
Learn how to quickly and efficiently collect on past due accounts to reduce accounts receivable. Read the guide here.
JOIN OUR FREE PRODUCT PORTAL
Gain complimentary access to the Anytime Collect product portal which contains: Recorded Demos, Feature Videos, Spec Sheets, ROI Calculator, And Much More.
Anytime Collect is a leading CLOUD-BASED accounts receivable software. Made specifically for businesses selling on credit terms, Anytime Collect AUTOMATES invoice dispute management, cash forecasting, customer communications, invoice presentment, online bill pay and credit management. The entire collections process becomes QUICKER AND EASIER.
If a large customer comes to you and shares their financial problems, it is time to open up your ears and hear them out. You should be happy they are discussing these issues with you. The fact they’re coming to you with this problem is huge considering many companies either do not realize their trouble, […]
As technology continues to grow, we expect a lot out of the products we buy. We expect them to complete all of our tasks and make majority of what we do automated. Consider your smartphone. Not only can you make phone calls and send text messages, but you can send email, import your calendar, manage […]