They usually have a different background color from the body rows, and theyre typically used to identify what the row or column contains.ĭata in header cells isnt used in calculations, but the text in a header cell can be used in formulas to refer to the entire row or column.Ī table can have up to five header rows and five header columns. Header rows and columns (if any) appear at the top and left side of the table.

There are three types of rows and columns: Body rows and columns contain the table data. Move the pointer over a row number or column letter, then click the down arrow that appears and choose Hide Selected Rows or Hide Selected Columns. He has been writing computer books for more than 20 years, and his long list of bestsellers includes all editions of Excel For Dummies, Excel All-in-One For Dummies, and Excel Workbook For Dummies.

When you begin typing a function name after typing an equal sign (), Excels AutoComplete feature kicks in by displaying a drop-down menu with the names of all the functions that begin with the character(s) you type.Įxcel then enters the function name along with the open parenthesis as in DATE( so that you can then begin selecting the cell range(s) for the first argument. If the function requires arguments (and almost all require at least one), these arguments must appear within the parentheses following the function name. These command buttons include Financial, Logical, Text, Date Time, Lookup Reference, and Math Trig.Īt the same time, the program closes the Insert Function dialog box and then opens the Function Arguments dialog box.

Insert button for excel on mac