Select cells you want to convert to uppercase and press the. Click inside it and press Shift + A.This will assign Ctrl + Shift + A button to the macro. Inside a new window, under the Shortcut key, there is a little text area. Click the AllCaps subroutine and then click Options. A new window called Macro will appear. Open your PERSONAL.XLSB workbook and click View > Macros > View Macros.Just go to the Tools menu and choose Customize Keyboard. You can now assign your own key combinations to many commands within Excel. Search for any keyboard shortcut Choose the category of shortcuts to display in the listYour shortcuts should continue to work. And when you know Keyboard shortcuts, you become a magician for others.You can control these shortcuts so they work the same in both versions of Excel by changing the Keyboard Shortcuts settings - just click Help > Keyboard Shortcuts.Shortcut to Apply Filter and Remove It (CTRL+SHIFT+L)When your curser is in the data, just press CTRL+SHIFT+L to apply filter.This command will apply filter to the data set. When presss CTRL+AAA, entire sheet will be selected. CTRL+AA will select whole table, including headers. For example, if the curser in an empty cell which is that is not surrounded by any data, it will select whole sheet.But when it is in a cell that is part of contiguous cells, then it will select whole set of cells.In formatted table, CTRL+A, it will select table excluding headers. When you press CTRL+AA, it selects whole sheet.Actually this command works different in different conditions. When you press it once, it only selects the table in which curser is right now.
To quickly move from one end to another use CTRL+arrow key shortcut. Quickly Move in Rows and Columns (CTRL+arrow key)While working with big data that contains multiple columns ans thousand rows, moving from one point to another takes too much time. It gets hard, to see where you were.To go back to the curser press CTRL+Backspace and excel will take you back to active cell.For Mac, it’s Command+Delete. Or you may use mouse to navigate on sheet (which I don’t prefer). To remove filter, press CTRL+SHIFT+L again.When you apply remove filter using shortcut, excel moves view to top of the table. If table has empty columns, select all data or heading and hit this shortcut. Stops when encounters a empty cell in way.CTRL+Up Arrow: Moves the curser to last non empty cell Upwards. Stops when encounters a empty cell in way.CTRL+Down Arrow: Moves the curser to last non empty cell downwards. Stops when encounters a empty cell in way.CTRL+Left Arrow: Moves the curser to last non empty cell to the Left. Just hold CTRL button and press required arrow key.CTRL+Right Arrow: Moves the curser to last non empty cell to the right. 3d cad sofware for macStops when encounters a empty cell in way.CTRL+SHIFT+Down Arrow: Selects the range to last non empty cell downwards. Stops when encounters a empty cell in way.CTRL+SHIFT+Left Arrow: Selects the range to last non empty cell to the Left. Hold down CTRL+SHIFT key and press desired arrow key to select range.CTRL+SHIFT+Right Arrow: Selects the range to last non empty cell to the right. If you want to select range between those points, than just add SHIFT key to the shortcut. Quickly Select Ranges (CTRL+SHIFT+Arrow key)The above Excel Shortcuts move cursor from one point to another point. This shortcut will take you to the last cell of data matrics.For example, if the last column that contains a data is G, and last row that contains d data is 100, then the last cell is G100 of your data matrics. Go to Last Cell of Table (CTRL+End key)When you want to see, where you enormous or puny data ends, hold down CTRL button and press End key on the keyboard. Stops when encounters a empty cell in way. It’s better to use the shortcut excel provides for navigating on sheets. So, navigating on these multiple sheets using mouse will take a lot of time. Even by default excel used to have three sheets (now its one in excel 2016). Switch Sheets Excel Hotkey (CTRL+PageDown/PageUp)Having multiple sheets in excel is common. It will select entire range from active cell to last cell of data matrics in fraction of second. If you want to select from that cell to the last cell of data matrics then use this excel hotkey. This makes it easy to work on multiple files. While working on a excel workbook, use CTRL+SHIFT+Tab move through all open workbooks. Excel provides a solution to this problem. In such situation, switching only to excel files is kind of headache using ALT+TAB shortcut. Switch Workbooks Excel Hotkey (CTRL+Shift+Tab)While working, you often have multiple apps open. And to move backwards, use CTRL+PageDown shortcut.For Mac, it’s Fn+Control+Down/Up Arrow. This will open the paste special Dialog box. To do so, on windows we can use keyboard shortcut (CTRL+ALT+V). For example, only value, only formate, only formula etc. Download ds emulator macWhen you use this command excel will show this info.If you want to select entire row in which curser is right now, hold shift key and hit space bar. And best thing about excel is that it doesn’t discard old shortcut in new versions of excel, so that an existing user can work normally. Actually this was shortcut for old version of Excel. This shortcut also opens same Dialog box for paste special. Transpose data, or do arithmetic operations on it.There is sequential shortcut too, that is ALT>E>S. Insert Rows or Columns Shortcut (CTRL+Shift++)When You have a whole row selected, just use this shortcut to insert number of rows you have selected. If you have selected a range in excel, then this command will select all columns of that range. It will select entire column of the active cell. Select Entire Column Shortcut (CTRL+Space)To Select Entire Column use CTRL+Space hotkey. Well you need to select whole column including headers. Then the question arises, how do you insert whole column using shortcut. It will insert rows above selected cells even if you have whole column selected. You don’t need to whole row. This will insert the number of columns you’ve select before selected columns.Special Case: In tables when press the CTRL+SHIFT++ shortcut, it insert rows. Hold down the CTRL button and hit F button on keyboard. Instead of going to home tab and then clicking on find option use this shortcut key. Open Find Dialog (CTRL+F)When want find any text or formula on excel sheet, using Find box is convenient and fast. Copy-Paste Cell, Down the Rows (CTRL+D)To copy first cell’s value/formula down the cell in a selected range use this shortcut. The data in find box is replaced by data in replace input box.Well, when you have find box open, you can use CTRL+Tab button to toggle between both of these options. This shortcut will directly open find and replace option, with replace input box active. Open Find and Replace Box (CTRL+H)To open find and replace Dialog box in use this shortcut. We will discuss all of that in a separate article. There are several thing you can do using find Dialog box. To sum a range, just select the range, hold down the ALT key and press + key (+=). Auto Sum (ALT++)I use this frequently while working on my stats. CTRL+L creates table, and CTRL+U underlines text. When you have generic formulas written and you want them to apply to multiple cell, these commands help a lot.Now, you’re logical mind would say that CTRL+L must fill value to left and CTRL+U should fill up. If you have multiple rows selected then value/formula from right most cell will be filled to the edge of selection.The above to shortcuts are among the most used shortcuts in excel. Fill Right (CTRL+R)To fill value/formula in selected range, from rightmost cell of a selection use this hotkey in excel. Other wise in any next blank cell to the right of selection.
0 Comments
Leave a Reply. |
AuthorMichelle ArchivesCategories |