
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 …
Use conditional formatting to highlight information in Excel
You can apply conditional formatting to a range of cells (either a selection or a named range), an Excel table, and in Excel for Windows, even a PivotTable report.
Combine text from two or more cells into one cell in Microsoft Excel
You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function.
Download and install or reinstall Office 2021, Office 2019, or Office ...
For example depending on your version of Windows, select Start and then scroll to find the app you want to open such as Excel or Word, or type the name of the app in the search box.
Move or copy a formula in Excel - Microsoft Support
Copy a formula Select the cell containing the formula that you want to copy. In the Clipboard group of the Home tab, select Copy. Do one of the following: To paste the formula and any formatting, in the …
Copy visible cells only - Microsoft Support
If some cells, rows, or columns on a worksheet do not appear, you have the option of copying all cells—or only the visible cells.
Lock or unlock specific areas of a protected worksheet
By default, protecting a worksheet locks all cells so none of them are editable. To enable some cell editing, while leaving other cells locked, it's possible to unlock all the cells.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support
Copy all the cells in this table and paste it into cell A1 on a blank worksheet in Excel. Tip: Before you paste the data into Excel, set the column widths for columns A through D to 250 pixels, and click …
Transpose (rotate) data from rows to columns or vice versa
Right-click over the top-left cell of where you want to paste the transposed table, and then choose Transpose . After rotating the data successfully, you can delete the original table and the data in the …
INDEX function - Microsoft Support
Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.