Once you’ve selected the rows or columns you want to insert/delete, just hit ‘Ctrl’ plus the ‘Plus’ or ‘Minus’ sign.Īnother added tip. To insert or delete multiple rows or columns, after selecting the row or column you want to insert/delete using either the ‘Shift’ or ‘Ctrl’ plus ‘Spacebar’ keystroke, hold down shift and use the arrow keys to select additional rows or columns. Test these tips out by downloading one of our real estate financial models A Few Bonus Tips for the RoadĪdded tip. Voila! A new row or column appears, and it took you just a second or two. Click ‘Shift’ plus the ‘Spacebar’ to select the row, or ‘Ctrl’ plus the ‘Spacebar’ to select the column, then click ‘Ctrl’ plus the ‘Plus’ sign found in your number pad. To insert a row or column using keyboard shortcuts, move your cursor to the row or column you want to delete. Voila! The row or column is gone, and it took you just a second or two.
Click ‘Shift’ plus the ‘Spacebar’ to select the row, or ‘Ctrl’ plus the ‘Spacebar’ to select the column, then click ‘Ctrl’ plus the ‘Minus’ sign found in your number pad. To delete a row or column using keyboard shortcuts, move your cursor to the row or column you want to delete. In contrast, once you’ve mastered the technique I’m about to share, inserting or deleting a row or column with keyboard shortcuts is much faster. You have to move your cursor to the row or column heading, select the row(s) or column(s) you want to insert/delete, right-click inside the selected/highlighted row(s) or column(s), scroll halfway down the context menu, and select insert or delete. Inserting or deleting a row or column with the mouse is incredibly slow. Keyboard Shortcut – Insert or Delete a Row or Column in Excel In this post, I’ll share a keyboard shortcut I use to save a ton of time: inserting and deleting rows and columns. This post is no different – except I’m going to keep this one simple.
With that thought in mind, we’ve written various posts showing you the keyboard shortcuts we use most in Excel. We’ve also shared numerous tips to improve your Microsoft Excel proficiency. One thing you’ll learn early in your CRE career, the more proficient you become in using your keyboard without a mouse to navigate around Excel, the more valuable you’ll be as a real estate financial analyst. PowerPoint - Slide Show Shortcuts, Media Shortcuts, Rehearsing Shortcuts, Outline View Shortcuts, and Other Shortcuts.Ĭommon Shortcuts for Word, Excel and PowerPoint.Īlso includes instructions for customizing the Quick Access Toolbar and the Status Bar.Using keyboard shortcuts is essential to improving the speed and efficiency at which you model real estate in Excel. Word - Text Selection Shortcuts, Movement Shortcuts, Special Characters, Switching Views, Formatting Shortcuts, Deleting Words, and Other Shortcuts.Įxcel - Selection Shortcuts, Movement Shortcuts, Formatting Shortcuts, Date & Time Shortcuts, Copying Shortcuts, Formula Shortcuts, Print Preview Shortcuts, Special Characters, and Other Shortcuts. This guide is suitable as a training handout, or simply an easy to use reference guide for any type of user. Shortcuts for the following topics: Word - Text Selection Shortcuts, Movement Shortcuts, Special Characters, Switching Views, Fo Laminated quick reference guide specializing in keyboard shortcuts for Microsoft Office 20 products Word, Excel, and PowerPoint. Laminated quick reference guide specializing in keyboard shortcuts for Microsoft Office 20 products Word, Excel, and PowerPoint.
0 kommentar(er)
