Change the column width or row height in Excel - Microsoft …
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.
Change the column width and row height - Microsoft Support
If you're working in Page Layout view (View > Workbook Views > Page Layout), you can specify a column width or row height in inches, centimeters and millimeters. The measurement unit is in inches by default. Go to File > Options > Advanced > Display > …
Set or clear a print area on a worksheet - Microsoft Support
Add cells to an existing print area. You can enlarge the print area by adding adjacent cells. If you add cells that aren’t adjacent to the print area, Excel creates a new print area for those cells. On the worksheet, select the cells that you want to add to the existing print area.
Switch between relative, absolute, and mixed references
When you copy a formula that contains a relative cell reference, that reference in the formula will change. As an example, if you copy the formula =B4*C4 from cell D4 to D5, the formula in D5 adjusts to the right by one column and becomes =B5*C5.
Print a worksheet or workbook - Microsoft Support
Print a worksheet or workbook. You can print entire or partial worksheets and workbooks, one at a time, or several at once. And if the data that you want to print is in a Microsoft Excel table, you can print just the Excel table. You can also print a workbook to a file instead of a printer.
Freeze panes to lock rows and columns - Microsoft Support
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.
Create or change a cell reference - Microsoft Support
Create a cell reference by using the Link Cells command. Change a cell reference to another cell reference. Change a cell reference to a named range. Switch between relative, absolute, and mixed references. Need more help? You can always ask an expert in the Excel Tech Community or get support in Communities. Need more help? Want more options?
Fill a formula down into adjacent cells - Microsoft Support
Select the cell with the formula and the adjacent cells you want to fill. Click Home > Fill, and choose either Down, Right, Up, or Left. Keyboard shortcut: You can also press Ctrl+D to fill the formula down in a column, or Ctrl+R to fill the formula to the right in a row.
Design the layout and format of a PivotTable - Microsoft Support
To change the layout of a PivotTable, you can change the PivotTable form and the way that fields, columns, rows, subtotals, empty cells and lines are displayed. To change the format of the PivotTable, you can apply a predefined style, banded rows, and conditional formatting.
Guidelines and examples of array formulas - Microsoft Support
At times, you may need to expand an array formula. Select the first cell in existing array range, and continue until you've selected the entire range that you want to extend the formula to. Press F2 to edit the formula, then press CTRL+SHIFT+ENTER to confirm the formula once you've adjusted the formula range. The key is to select the entire ...
Change the source data for a PivotTable - Microsoft Support
However, if the source data has been changed substantially—such as having more or fewer columns, consider creating a new PivotTable. You can change the data source of a PivotTable to a different Excel table or a cell range, or change to a different external data source.