CTRL+SHIFT – EXCEL SHORTCUT KEYS TO STAY AHEAD

-
Ctrl+ShiftCtrl+Shift, then scroll your mouse wheel up to go left, down to go right
Ctrl+Shift+AInsert argument names and parentheses when the insertion point is to the right of a function name in a formula
Ctrl+Shift+F (or P)Format fonts in the Format Cells dialog
Ctrl+Shift+GOpen the Workbook Statistics dialog
Ctrl+Shift+LApply / Remove Auto-filter
Ctrl+Shift+OSelect all cells containing Notes (earlier called comments)
Ctrl+Shift+UExpand/Collapse Formula bar
Ctrl+Shift++Open the Insert dialog to insert blank cells
Ctrl+Shift+:Enter the current time
Ctrl+Shift+&Apply an outline border to the selected cells
Ctrl+Shift+_Remove the outline border from the selected cells
Ctrl+Shift+~Apply the General number format
Ctrl+Shift+$Apply the Currency format with two decimal places (negative numbers in parentheses)
Ctrl+Shift+%Apply the Percentage format with no decimal places
Ctrl+Shift+^Apply the Scientific number format with two decimal places
Ctrl+Shift+#Apply the Date format with the day, month, and year
Ctrl+Shift+@Apply the Time format with the hour and minute, and AM or PM
Ctrl+Shift+!Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values
Ctrl+Shift+*Select the current region around the active cell
Ctrl+Shift+(Unhide Rows
Ctrl+Shift+=Insert Rows / Columns when row/column is selected or display insert menu when cell is selected
Ctrl+Shift+SpacebarSelect the entire worksheet (equivalent to CTRL+A)

Select all objects on a worksheet when an object is selected

Ctrl+Shift+Page DownSelect the current and next sheet in a workbook
Ctrl+Shift+Page UpSelect the current and previous sheet in a workbook
Ctrl+Shift+HomeExtend the selection of cells to the beginning of the worksheet
Ctrl+Shift+EndExtend the selection of cells to the last used cell on the worksheet
Ctrl+Shift+ArrowExtends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell
Ctrl+Shift+TabSwitches to the previous tab in a dialog, or (if no dialog is open) switches between all Excel windows
Ctrl+Shift+EnterConfirm a formula as Array formula
Ctrl+Shift+"Copy the value from the cell above the active cell into the cell or the formula bar
Ctrl+Shift+F2Insert a threaded comment / Open and reply to a threaded comment
Ctrl+Shift+F3Open create name from selection dialog box
Ctrl+Shift+F6Switches between all Excel windows
Ctrl+Shift+F10Open the context menu
Ctrl+Shift+F12Opens print worksheet dialog box

 


Comments

Post a Comment

Best Blogs

IB Interview Questions: M&A : Level 1 M&A Questions

-
Image
1. Why do companies merge? While are many reasons that companies merge the underlying driver of most M&A deals to expedite growth and/or generate cost savings to create value for the owners of the business. When people say that M&A is an ‘art’ and a ‘science’, what does that mean? The science refers to the mechanical valuation methods (Comps, DCF, etc.), but the art is in making a judgment call on valuation based on the outputs of the various valuation methodologies. 2. Who can pay more when buying a company: a Financial buyer or Strategic buyer? Why? Strategic (i.e. corporate) buyers can typically pay more than Financial (i.e. Private Equity) buyers because strategic buyers typically have overlapping operations that can be removed post-merger to generate cost savings (i.e. Synergies). 3. When are sponsors and corporate buyers on equal footing? When a Financial buyer already owns a competing asset, they can generate synergies (which justifies a higher price) and thus are on mor...
Read more

Getting into Investment Banking: A Comprehensive Guide

-
Image
Introduction Breaking into investment banking (IB) is no small feat, whether you're pre-MBA or post-MBA, from a target or non-target school. While high GPAs and test scores are standard, they are often not enough to stand out. Here’s a strategic approach to help you embark on a successful investment banking career. 1. Network Extensively When your application lands at an investment bank, it’s usually reviewed by a small team of bankers responsible for recruiting from specific schools. Given the competitive nature of this field, networking is crucial. Why Networking Matters: Decision-making bankers are more likely to advocate for you if they know you. Especially vital for non-target school students. Engage with alumni and other connections at your target firms. How to Network: Start reaching out to analysts and associates a few months before core recruiting starts. Look for non-target alumni if you're from a non-target school; they often help each other out. Demonstrate Interest...
Read more