SHORTCUT FOR FIND AND REPLACE IN EXCEL PLUS

Working with a big number? Use this shortcut to quickly convert to scientific notation. CTRLВ + Shift + ^В : Scientific notation style 2 in the cell before formatting.ДЄlternatively, insert a formula to calculate percentages and then format as needed. For example, if you want 20 percent, you will need to have. Make sure your original number has the right number of decimals. This command styles your cell to a percentage style number. CTRLВ + Shift + % : Percentage style a number Source: Dirk Stoop/Flickr This command styles your cell to a general style number. This shortcut removes the outline border to a selected cell or range. Use this to quickly underline or un-underline a cell or text.

Use this to quickly italicize or un-italicize a cell or text. Use this to quickly bold or unbold a cell or text.

SHORTCUT FOR FIND AND REPLACE IN EXCEL PLUS

Plus it makes you feel nice and fuzzy on the inside. This really does pay dividends in the long run. Borders are generally a good idea to use if you want to organize your worksheet and make it appear more professional. Instead of navigating through endless menus, use this Excel shortcut to quickly add borders to the cells you have selected. CTRLВ + Shift + &: Applies border to cells This shortcut expands or collapses the formula bar, a useful tool when you're moving about a variety of workspaces and inspecting cells. Ctrl + Shift + U: Expand or collapse the formula bar Source: Isriya Paeireepairit/Flickr It will apply to multiple cells as well, if you have them selected. If you quickly want to change a cell to the currency format, you can select it and hit this shortcut. CTRL + Shift + $:В Applies the currency format to the selected cells Then press these keystrokes and the insert hyperlink box appears, making the process that much easier. CTRL + K: Insert a hyperlinkДЇirst, you need to select where you want a hyperlink to appear. This shortcut quickly gives you access to the default date format. CTRL + Shift + #: Change date format with the day, month, and year

Shortcut for find and replace in excel