Microsoft Excel Keyboard Keys. Source: goudzwaard.info goudzwaard.info General. Description. Shortcut Key. New file. Ctrl + N. Open file. Columns & Rows Shortcuts. CTRL + 9. Hide Row. SHIFT + CTRL + 9 SHIFT + ALT + Right Arrow Ungroup Rows/Columns. Function Key Shortcuts. F2. Get immediate free access to PDF Cheat Sheet with more than Excel keyboard shortcuts and hotkeys. Lists the most common and popular keyboard.
|Language:||English, Spanish, French|
|Distribution:||Free* [*Registration Required]|
Below is a huge list of Excel keyboard shortcuts you can use to work faster. Scroll Where shortcut keys must be pressed together they will be shown like this. Shortcut keys help to provide an easier and usually quicker method of directing and finishing commands in Microsoft Excel. Mostly we prefer to use the shortcuts . Mac computers have a special preference for function keys in System preferences. This guide assumes your. Mac is set at the default, with Use all F1, F2, etc.
This often wastes a lot of time as you have to scroll back to see what a data point means. Freezing rows and columns is the way to go in such cases. If you want freeze both rows and column, select a cell above which you want to freeze rows you can freeze more than one row , and to the left of which you want to freeze columns could be one or more than one.
For example, if you want to freeze top two rows and one column to the left, select cell B3. It opens a dialog box where you have different tabs for different types of formatting.
For example, you may want to enter the address in a cell, but want the house numbers, street, city, state in different lines in the same cell. Instead, activate a workbook and then use the following shortcut to switch between open workbooks only. Choose the location where you want to save the file. Enter a name for the file. Select Browse to open the Save As dialog box.
Select Save as type to open a drop-down list and choose PDF. Select Options to open the Options dialog box. When your files are saved to OneDrive, documents are automatically saved every few seconds, eliminating the need for you to continuously select Save or use shortcut keys.
For the AutoSave function to work, save documents to a location in your OneDrive folder.
If you have Office and save your files to OneDrive, enable AutoSave by selecting the toggle switch in the top-left corner of the Excel screen. When enabled, the switch will say On. When Allow editing directly in cells is turned off, moves the insertion point to the Formula Bar. Within cell of Formula Bar, complete cell entry and by default go to the cell above. Tab is also under the Navigation and Selection and Formulas and Functions categories.
Toggle between 1 displaying cell values and 2 displaying formulas in worksheet. The Paste all merging conditional formats option is only enabled when copying a range that contains conditional formatting.
Display the Format Cells dialog box with the Number tab and the Accounting category selected. Display the Merge Styles dialog box to merge copy cell styles from another workbook.
Expand the menu to set a conditional formatting rule using data bars with gradient or solid fill. Display the New Conditional Formatting Rule dialog box, with the Format all cells based on their values rule type selected. Display the A Data Occurring dialog box to conditionally format cells whose date occurs within the time period set in the rule.
Display the Between dialog box to conditionally format cells whose value is between the values set in the rule. Display the Duplicate Values dialog box to conditionally format cells with duplicate or unique values in the selected cell range. Display the Equal To dialog box to conditionally format cells whose value is equal to the value set in the rule. Display the Greater Than dialog box to conditionally format cells whose value is greater than the value set in the rule.
Display the Less Than dialog box to conditionally format cells whose value is less than the value set in the rule. Display the New Conditional Formatting Rule dialog box, with the Format only cells that contain rule type selected. Display the Text That Contains dialog box to conditionally format cells whose text contains the text set in the rule.
Display the Above Average dialog box to conditionally format cells that are above the average in the selected cell range. Display the Bottom 10 Items dialog box to conditionally format cells that rank within the bottom values in the selected cell range.
Display the New Conditional Formatting Rule dialog box, with the Format only top or bottom ranked values rule type selected. Display the Top 10 Items dialog box to conditionally format cells that rank within the top values in the selected cell range. Display the Below Average dialog box to conditionally format cells that are below the average in the selected cell range. Default settings are: Function name must have already been typed and insertion point must be to the right of the function name.
May not work in certain particularly newer versions of Excel by default. In those cases, you can usually enable the shortcut by modifying the language bar hotkey settings and changing the setting e.
Go to last cell cell in lowest used row and right-most used column of worksheet.