We hope these 20 Excel shortcuts will help brokers work smarter and win more deals. On the other hand, a strong CRM brings your data together in one place across multiple devices.
#Kmac excel keyboard shortcut strikethrough update
You can organize prospects on Excel, but can you set up reminders for follow-up, tasks and events? You can with the right CRE tech.Īnd while you can certainly store data in Excel, that data doesn’t automatically update to the cloud in a way that’s easily accessible across your team. The above shortcuts will help you save time, but let’s be honest - there’s only so much you can do with outdated technology. Insert hyperlink: Ctrl + K (PC) Command + K (Mac) Insert current time: Ctrl + Shift + : (PC) Command + (Mac) Paste special: Ctrl + Alt + V (PC) Command + Ctrl + V (Mac) Show values in general number format: Ctrl + Shift + ~ (PC & Mac)Īpply bold formatting: Ctrl + B (PC) Command + B (Mac)Īpply italic formatting: Ctrl + I (PC) Command + I (Mac)
![kmac excel keyboard shortcut strikethrough kmac excel keyboard shortcut strikethrough](https://cdn2.hubspot.net/hubfs/53/excel-shortcuts.jpg)
Show values as currency: Ctrl + Shift + $ (PC & Mac) Show values as percentages: Ctrl + Shift + % (PC & Mac) Whether it’s formatting numbers while building a new model or seamlessly adding the date and time, use these tricks to present your data as effectively as possible. If you don’t have a CRM to do that for you, knowing the right shortcuts can be a lifesaver. Show formula builder after typing a function: Ctrl + A (PC & Mac)Įffective formatting turns unintelligible data into actionable information.
![kmac excel keyboard shortcut strikethrough kmac excel keyboard shortcut strikethrough](https://fs.hubspotusercontent00.net/hubfs/53/hub_generated/resized/ef8ec6f0-a50f-4f11-9601-341edfb26ac9.png)
They won’t segment contacts into call lists for targeted outreach, but they may save you enough time to make an extra prospecting call or two.Īdd AutoSum formula: Alt + (PC) Shift + Command + T (Mac)Įdit active cell: F2 (PC) Ctrl + U (Mac) Use these shortcuts to simplify the process. They help you make sense of your data, but only if you can make sense of the formulas first. Shift between all open programs: Alt + Tab (PC) Command + Tab (Mac)įormulas are one of Excel’s most powerful tools. Open previous workbook: Ctrl + Shift + F6 (PC) Command + Shift + F6 (Mac)
![kmac excel keyboard shortcut strikethrough kmac excel keyboard shortcut strikethrough](https://cdn.ablebits.com/_img-blog/strikethrough-excel/delete-strikethrough-conditional-format.png)
Jump to the bottom of a column: Ctrl + ↓ (PC) Command + ↓ (Mac)Ĭlose active workbook window: Ctrl + W (PC) Command + W (Mac) Jump to the top of a column: Ctrl + ↑ (PC) Command + ↑ (Mac) Jump to the last cell: Ctrl + End (PC) Ctrl + fn + → (Mac)
![kmac excel keyboard shortcut strikethrough kmac excel keyboard shortcut strikethrough](https://cdn.allthings.how/wp-content/uploads/2021/03/allthings.how-how-to-strikethrough-in-excel-image-2.png)
Jump to the first cell: Ctrl + Home (PC) Ctrl + fn + ← (Mac) Check out these simple shortcuts and you’ll be flipping through spreadsheets faster than ever before - you can even pretend they’re updating in real time! That doesn’t make navigating them easy, and while there’s always the mouse and scrollbar, you aren’t going to win any races using those. Navigation shortcutsĮxcel spreadsheets can be big and clunky. So from navigating efficiently to effectively formatting your cells, use these shortcuts to squeeze the most out of Excel. While these shortcuts won’t transform the technology, they will help you level the playing field. That’s why we put together a list of 20 shortcuts for brokers still using Microsoft Excel. We wish every broker could compete on a level playing field, but until that happens we’re here to help brokers of all technology levels. This year promises to be a year of opportunity, and to ensure you win every deal that comes your way, you’re using…the same old spreadsheets.ĭespite soaring industry technology adoption and the growing understanding that technology, and especially a strong CRM, are essential ingredients to success in today’s market, too many brokers are still relying on outdated spreadsheets.