When.com Web Search

Search results

1. Results From The WOW.Com Content Network

2. Transpose (rotate) data from rows to columns or vice versa

   support.microsoft.com/en-us/office/transpose-rotate-data-from-rows-to-columns...

   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.

3. Insert or delete rows and columns - Microsoft Support

   support.microsoft.com/en-us/office/insert-or-delete-rows-and-columns-6f40e6e4...

   You can add columns, rows, or cells to an Excel worksheet or delete them. Columns insert to the left, rows above, and cells above or to the left.

4. Move or copy cells, rows, and columns - Microsoft Support

   support.microsoft.com/en-us/office/move-or-copy-cells-rows-and-columns-3...

   When you move or copy cells, rows, and columns, Excel moves or copies all data that they contain, including formulas and their resulting values, comments, cell formats, and hidden cells.

5. Freeze panes to lock rows and columns - Microsoft Support

   support.microsoft.com/en-us/office/freeze-panes-to-lock-rows-and-columns-dab2...

   How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.

6. Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support

   support.microsoft.com/en-us/office/look-up-values-with-vlookup-index-or-match...

   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) In this example, B2 is the first argument —an element of data that the function needs to work.

7. Change the column width or row height in Excel - Microsoft...

   support.microsoft.com/en-us/office/change-the-column-width-or-row-height-in...

   You can manually adjust the column width or row height or automatically resize columns and rows to fit the data. Note: The boundary is the line between cells, columns, and rows. If a column is too narrow to display the data, you will see ### in the cell.

8. Hide or show rows or columns - Microsoft Support

   support.microsoft.com/en-us/office/hide-or-show-rows-or-columns-659c2cad-802e...

   How to hide and unhide columns and rows in an Excel worksheet. Restrict access to only the data you want to be seen or printed.

9. Excel specifications and limits - Microsoft Support

   support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d...

   In Excel 2010, the maximum worksheet size is 1,048,576 rows by 16,384 columns. In this article, find all workbook, worksheet, and feature specifications and limits.

10. Sort data in a range or table - Microsoft Support

    support.microsoft.com/en-us/office/sort-data-in-a-range-or-table-62d0b95d-2a90...

    Sort data in a range or table. Sorting data is an integral part of data analysis. You might want to arrange a list of names in alphabetical order, compile a list of product inventory levels from highest to lowest, or order rows by colors or icons.

11. Select cell contents in Excel - Microsoft Support

    support.microsoft.com/en-us/office/select-cell-contents-in-excel-23f64223-2b6b...

    Freeze panes to lock rows and columns. Lock or unlock specific areas of a protected worksheet. Learn how to select cells, ranges, entire columns or rows, or the contents of cells, and discover how you can quickly select all data in a worksheet or Excel table.