The quickest way to do this is by selecting cell B2, and then double-clicking the small black square that appears in the lower-right corner of the cell. Now, fill down the formula in the new column. Use =UPPER(A2) in cases where you need to convert text to uppercase, replacing A2 with the appropriate cell reference. To convert the text to lowercase, type =LOWER(A2) instead. This formula converts the name in cell A2 from uppercase to proper case. In cell B2, type =PROPER(A2), then press Enter. In this case, we’ve added a new column (B) to the right of the Customer Name column. In the example below, the PROPER function is used to convert the uppercase names in column A to proper case, which capitalizes only the first letter in each name.įirst, insert a temporary column next to the column that contains the text you want to convert. Functions are just built-in formulas that are designed to accomplish specific tasks-in this case, converting text case. However, you can use the UPPER, LOWER, or PROPER functions to automatically change the case of existing text to uppercase, lowercase, or proper case. Some laptops have Fn Lock Mode so that you don't have to press Fn with the the function keys.Ĭheckout our post on the Best Keyboards for Excel Keyboard Shortcuts to learn more.Unlike Microsoft Word, Microsoft Excel doesn't have a Change Case button for changing capitalization. You might also need to press the Fn (function) key in combination with the function keys F1 to F12.

Laptop keyboards tend to have smaller keyboards and don't always contain keys like Page Up, Page Down, Menu, etc. If you are using a laptop keyboard then you might be limited on the some of the shortcuts you can press. Press & release Alt, then press & release E, then press & release S. For example, to press the shortcut Alt,E,S to open Paste Special, you will:

Easily create spreadsheets from templates or on your own and use modern formulas to perform calculations. Let Excel learn your patterns, organize your data, and save you time.

The, (comma) between keys means press & release each key in order. Save time with intelligence-enhanced tools for experts and beginners. Press & hold Ctrl, then press & hold Shift, then press L. For example, to press the shortcut Ctrl+Shift+L to Toggle Filters, you will: The + (plus) between keys means press & hold the keys together in order. There are two ways to press the shortcut keys depending on the separator character used in the sequence. These shortcuts are convenient, and you should get used to using them not only in Excel, but also in Microsoft Word, internet browsers, or any other app you frequently use for business or leisure.

Microsoft excel shortcut keys download