Learn how to select visible cells only in Excel using keyboard shortcuts, Go To Special dialog box, and Quick Access Toolbar. Copy and paste only the visible cells to exclude hidden ones.| Spreadsheet Planet
Learn how to select multiple rows in Excel, whether they are contiguous or non-contiguous, using simple and quick methods.| Spreadsheet Planet
Learn five super easy methods to swap columns in Excel, including drag and drop, cut and paste, sorting, SORTBY function, and copy, paste, and delete.| Spreadsheet Planet
Learn how to quickly rearrange rows in Excel using different methods like shift key and mouse, cut copy method, insert row and cut/copy method, and sorting.| Spreadsheet Planet
Learn multiple ways to convert columns into rows in Excel, including using the transpose feature, paste special, keyboard shortcuts, and the TRANSPOSE function.| Spreadsheet Planet
Learn how to combine two columns in Excel with space or comma using six simple methods. From using the ampersand operator to the Flash Fill feature, this tutorial covers it all.| Spreadsheet Planet
Learn how to flip data in Excel - columns, rows, and tables using different methods such as helper columns, formulas, and VBA.| Spreadsheet Planet