that you have cut or copied data and assumes that when you press “Enter,” you want to paste the data. There is a difference between pressing “Enter” and the first three ways to paste data. If you copied (not cut) data, Excel assumes you may want to paste the data more than once. If you paste copied data using one of the first three methods (“Ctrl+V,” the “Paste” icon, or from the right-click menu), you can use any of those three methods to paste the data again. Notice that when you cut or copy data, Excel will highlight the copied cells, as shown in Figure 4. If you have copied the data, Excel will leave those cells highlighted after pasting the data with one of the first three methods to show you that the data is available to paste again. When you press “Enter” to paste, Excel empties the clipboard and removes the highlight showing that the data SOFTWARE is no longer available to paste. If you pasted data using “Ctrl+V,” the “Paste” icon, or the right-click menu and are finished pasting, press the “Esc” key to remove the highlight and empty the clipboard. You can also tell that the clipboard is empty because the “Paste” icon on the ribbon will be grayed out. If I have a lot of pasting to do, I will copy the data, paste (I usually use “Ctrl+V”) until I know I am done pasting, and then press “Enter” for the final paste to empty the clipboard. The next time you work in a spreadsheet, try some of these shortcuts. Time saved entering and organizing data in Excel can always be better spent analyzing that data instead. ■ Nate Moore writes custom SQL server code to mine practice management data for analysis in Excel, web pages, and via email. Nate’s first book, Better Data, Better Decisions: Using Business Intelligence in the Medical Practice, was written with Mona Reimers. His free Excel videos are available at mooresolutionsinc.com. DID YOU KNOW? Renew right now TODAY to receive unlimited online education for SIX MONTHS starting now! + THE JOURNAL OF THE HEALTHCARE BILLING AND MANAGEMENT ASSOCIATION 35 FIGURE 4 If you became a member of HBMA today, you could have a new client by next month. Don’t miss being part of HBMA’s new Professional Billing Service Locator Program. We will submit a list of HBMA medical billing organizations for providers to contact – one could be you! Fill out the Request for Information (RFI) form NOW. But you have to be a member! www.hbma.org/renew Or toll free 877.640.4262 or info@hbma.org
Billing_JulAug14
To see the actual publication please follow the link above