![]() Oddly, you cannot type the braces in yourself you must use the Ctrl + Shift + Enter key combination. This tells Excel that the formula’s output will be an array of data rather than just a single cell. The Ctrl + Shift + Enter key combination put a set of braces around the formula. Your Excel worksheet should now look like this: You need to hold down the Ctrl and Shift keys when you hit Enter. Entering this formula into Excel differs from most other formulas. Now type the following formula into the formula bar =transpose(a1:b6)īut don’t hit Enter yet. ![]() Make sure the area you selected is still selected before you start typing the formula. With this area selected, click on the formula bar above. Notice that the cells we chose include A12 to F13, a 6×2 area.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |