Previous comment above about saving the workbook first is also a key, as you'll otherwise receive the #Value! result.
For more than 30 years, this office suite from the software developing giant, Microsoft, has been setting the standard for what a spreadsheet app should be. Highlights all text to the left of the cursor. Microsoft Excel is one of the staple productivity applications that you should have on your computer along with Word, PowerPoint, and Outlook. In a single column, highlights all cells above that are selected.
Selects all of the cells that contain comments. Move between Two or more open Excel files. Move to last cell with text on the worksheet. Adding style makes a spreadsheet easier to read and less prone to mistakes, and I'll show you why in this screencast. I'll show you many of my favorite tricks for bringing meaning to my spreadsheets.
Selects the cells within a column that don’t match the formula or static value in the active cell.įills the selected cells with the current entry. How to Format an Excel Spreadsheet (Watch & Learn) If you want a guided walk through of using Excel formatting, check out the screencast below. Selects cells which contain formulas that directly or indirectly reference the active cell. Selects all cells directly or indirectly referenced by formulas in the highlighted section. Selects cells that contain formulas that reference the active cell. 500 Excel Formula Examples Detailed formula examples for key functions, including VLOOKUP, INDEX, MATCH, RANK, SUMPRODUCT, AVERAGE, SMALL, LARGE, LOOKUP, ROUND, COUNTIFS, SUMIFS, CHOOSE, FIND, SEARCH, DATE, and many more. Selects all cells referenced by formulas in the highlighted section. Selects the cells with a static value or don’t match the formula in the active cell. Selects the array containing the active cell. Selects the current region around the active cell. Switches between showing Excel formulas or their values in cells. Puts a strikethrough all cells in the highlighted section.Ĭhanges between displaying cell values or formulas in the worksheet. Underlines all cells in highlighted section. Puts italics all cells in the highlighted section.
Pastes everything copied onto the clipboard.Ĭuts all cells in the highlighted section.Ĭhanges the format of the selected cells.īolds all cells in the highlighted section.
Underlines all cells in the highlighted section. Then press Ctrl+ R to fill them with the contents of the original cell. To fill more than one cell, select the source cell and press Ctrl+ Shift+ Right arrow to select multiple cells. Fills the cell to the right with the contents of the selected cell. Puts italics on all cells in the highlighted section.įill right. Then press Ctrl+ D to fill them with the contents of the original cell. To fill more than one cell, select the source cell and press Ctrl+ Shift+ Down arrow to select multiple cells. Fills the cell beneath with the contents of the selected cell. Move to the next cell, to the right of the currently selected cell.īold all cells in the highlighted section.Ĭopy all cells in the highlighted section.įill down. Some of the Microsoft Excel shortcut keys below may not work in Excel 365.