![]() ![]() ![]() CTRL Z (or undo button): Udoes the last action you took in the worksheet.Original rows will become columns and rows will become columns. From the Paste Special menu, click the “Transpose” checkbox in the lower right-hand corner, then click OK. Click on the cell where you want to place the data, then right-click to get the dropdown menu. Entered data as columns and they should be rows or vice versa? – Select the data you want to transpose, and copy it (CTRL-C).Copying a formula across rows or down columns – Enter a formula then click on the cell, then click on the little box that appears in the lower right-hand corner and drag it across the desired range of cells, and you will populate the range using the same formula.If you select columns, it will work the same way. ![]() Add multiple rows and columns at one time – select the number of rows you want to add, starting with the row directly below where you want the new rows to appear then right-click (PC) or Command-click (Mac), and select “Insert” from the dropdown menu.Select all cells including empty cells in a document- click on the square in the upper left-hand corner where the top of the rows and columns meet and all the cells will be highlighted or press the CTRL and “A” buttons (CTRL + A) at the same time.Here are some great tips that are confirmed to work on both Mac and Windows laptops and could apply to mobile versions: Intuit QuickBooks shares some great Excel tips that should help you speed up work that you may find tedious or confusing. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |