Move or copy cells, rows, and columns - Microsoft Support
You can use the Cut command or Copy command to move or copy selected cells, rows, and columns, but you can also move or copy them by using the mouse. By default, Excel displays the Paste Options button.
Transpose (rotate) data from rows to columns or vice versa
Learn how to use the Transpose feature in Excel to switch data from columns to rows, or vice versa, with a simple right-click command. See examples, tips, and alternatives for rotating data in tables or PivotTables.
Copy visible cells only - Microsoft Support
Learn how to copy only the visible cells on a worksheet without hidden or filtered rows or columns. Follow the steps to select, copy, and paste the visible cells using Excel for Microsoft 365, Excel for the web, or Excel 2021.
Copy and paste using the Office Clipboard - Microsoft Support
Learn how to use the Office Clipboard to copy up to 24 items from different sources and paste them into another Office document. Find out how to open, control, and delete the Clipboard task pane and its contents.
Cut out part of a picture - Microsoft Support
Learn how to remove parts of an image in a Office file that you don't want to include. Follow the steps to use the Remove Background tool and mark areas to keep or remove with a drawing pencil.
Clear the clipboard - Microsoft Support
Learn how to empty the clipboard in Excel when you get an error that says your clipboard is full. Follow the steps to open the Clipboard task pane and delete all or individual clips.
Paste options - Microsoft Support
Learn how to paste copied data, formulas, formatting, and more in Excel with different options and keyboard shortcuts. Find out how to fix cell references and transpose data when you paste.
What to do if a data set is too large for the Excel grid
Learn how to open, save, and analyze data sets that exceed the number of rows or columns in Excel. Use Get Data, PivotTables, and Power Query to load and work with complete data sets without losing data.
Keyboard shortcuts in Excel - Microsoft Support
Learn how to use keyboard shortcuts to work more efficiently in Excel for Windows, Mac, web, and mobile. Find the most frequently used shortcuts, ribbon shortcuts, access keys, function keys, and more.
Repeat specific rows or columns on every printed page
Learn how to repeat specific rows or columns on every printed page in Excel. Follow the steps to use the Print Titles command in the Page Layout tab and enter the references of the labels you want to print.
Split panes to lock rows or columns in separate worksheet areas
Then, click View > Window > Split. You can remove the split simply by clicking the Split button again. You can also split a worksheet on the columns. Select the column to the right of the column where you want to place the split, and use the Split command.