Keyboard shortcuts in Excel - Microsoft Support
If you don't hold the Shift key while you drag and drop, the selected cells will be cut from the original location and pasted to the new location (not inserted). Move from top to bottom within the selection (down).
Remove or turn off hyperlinks - Microsoft Support
In Word and Outlook: Press Ctrl+A to select all text. Press Ctrl+Shift+F9. In Excel: Select all cells that contain hyperlinks, or press Ctrl+A to select all cells. Right-click, and then click Remove Hyperlinks.
Move or copy cells, rows, and columns - Microsoft Support
Hold down SHIFT and drag your row or column between existing rows or columns. Excel makes space for the new row or column.
Transpose (rotate) data from rows to columns or vice versa
If you have a worksheet with data in columns that you need to rotate to rearrange it in rows, use the Transpose feature. With it, you can quickly switch data from columns to rows, or vice versa.
TRANSPOSE function - Microsoft Support
Use TRANSPOSE to shift the vertical and horizontal orientation of an array or range on a worksheet. Syntax. TRANSPOSE(array) The TRANSPOSE function syntax has the following argument: array Required. An array or range of cells on a worksheet that you want to transpose.
Start a new line of text inside a cell in Excel - Microsoft Support
To start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell, press Alt+Enter to insert a line break. Double-click the cell in which you want to insert a line break. Click the location inside the selected cell where you want to break the line.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
It's actually quite easy to do with a lookup function. The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH, are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE)
Keyboard shortcuts in Microsoft 365 - Microsoft Support
Many users find that using Microsoft 365 apps with keyboard shortcuts on an external keyboard helps them work more efficiently. For users with mobility or vision disabilities, keyboard shortcuts can be easier than using the touchscreen, and are an essential alternative to using a mouse.
OFFSET function - Microsoft Support
This article describes the formula syntax and usage of the OFFSET function in Microsoft Excel. Description. Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells. The reference that is returned can be a single cell or a range of cells.
Move or scroll through a worksheet - Microsoft Support
You can use the arrow keys, the scroll bars, or the mouse to move between cells and to move quickly to different areas of the worksheet. In Excel, you can take advantage of increased scroll speeds, easy scrolling to the end of ranges, and ScreenTips …
Dynamic array formulas and spilled array behavior - Microsoft …
Excel formulas that return a set of values, also known as an array, return these values to neighboring cells. This behavior is called spilling. Formulas that can return arrays of variable size are called dynamic array formulas.