Unpivot Table to transform your cross-tab table and get columns as row values instead.Unmerge to divide combined cells into multiple separate cells.Calculate to quickly insert formulas with the most popular functions for multiple data ranges.Freeze to lock top rows and left columns in your tables.Remove to get rid of all blank and/or unused rows and columns on the sheet.Flip to exchange records between columns, rows, or cells.Change Case to switch between different capitalizations of the text.Sort by Color to sort the selected range or the entire sheet by their font or fill colors.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |