=ISTEXT(D1) Checks if a cell is a text.=ISNUMBER(A1) Checks if a cell is a number.This example returns 2 ^ 6 = 64 Numeric comparison operators =C5% Convert a value to a percentage with %. =A4 - B4 Subtract a value from another with -.This example returns 10 - 7 = 3 Throughout most of this cheat sheet, we’ll be using this dummy dataset of 5 columns and 6 rows. Here is an example of start:end format when using the SUM() formula: The start:end format is a convenient way to specify a range of cells in a formula. =B$2 Column reference is relative, row reference is absolute Specifying ranges with the start:end format =$B2 Column reference is absolute, row reference is relative =$B$2 Column and row references are both absolute The following examples all specify column B, row 2. The $ symbol before the column letter and/or row number tells Excel that the reference is absolute and should not change when the formula is copied or moved to another cell. Specifying absolute cell references with $ prefixes =B2 Here we refer to the cell in column B, row 2.

Once you have entered your comment, click the green arrow button to save it.Ĭells and ranges Specifying cell locations with column letter, row number format.This will open a small text box next to the cell, where you can type your comment.You can also click on the Insert menu then 'New Comment'. Right-click or CTRL+click on the cell and select the 'New Comment' option from the context menu.Click on the cell where you want to add a comment.You can also click on the 'Help' button to open the Help pane, where you can browse through various topics and find answers to common questions.In the Help menu, you will see various options for getting help, including a search bar where you can enter keywords to search for specific topics.Click on the 'Help' menu at the top of the screen.Getting help You can get help by accessing the help menu

You can use cell ranges to perform calculations on multiple cells at once or to apply formatting to a group of cells. A cell range is typically referred to by its upper-left and lower-right cells, such as A1:C3, referring to the cells in columns A, B, and C and rows 1 through 3. For example, the cell in the 4th column, 7th row would be denoted D7.Ĭell range: A group of adjacent cells in a worksheet. The column is described with letters and the row is described with numbers. Formulas start with an equals sign (=), and contain functions, mathematical operators, values, and cell references.Ĭell reference: The location of a cell.

It is a grid of cells arranged in rows and columns.Ĭell: A rectangular box in a worksheet that can store a data value, a formula, or other content.įormula: A piece of code to perform a calculation. Workbook: A file containing a collection of one or more worksheets. Spreadsheet: An application, like Microsoft Excel, where you can store data, perform calculations, and organize information. This cheat sheet describes the behavior of the Microsoft 365 version of Excel, and slight differences exist between Excel versions.

Excel cheat sheet mac