Mac users who have purchased Excel for Mac will find the program located in their Dock or among by opening “Finder” and then selecting “Applications. "
You may always open a new spreadsheet while working on another workbook in Excel. Simply click on “File” from the menu bar and select the “New Workbook” option.
When finished with a given cell, press ↵ Enter or Tab ↹ to automatically move to the next cell horizontally. You may also create a new line within a cell on which to add more text. Simply enter a “Line Break” by pressing Alt+↵ Enter.
Excel can recognize many common patterns such as days of the week, evenly-spaced dates, consecutive numbers and many others.
Pressing Ctrl and the spacebar extends a selection throughout the column where the original cell is located. Pressing ⇧ Shift and the spacebar extends a selection throughout the row where the original cell is located. Pressing Ctrl+⇧ Shift and the spacebar or Ctrl+A will select the entire worksheet.
This function is also available from the “Home” tab by selecting “Insert” from the “Cells” then “Insert Sheet Rows. " Inserting multiple rows requires you to select multiple rows above the location in which you wish to place new rows. Simply select the same number of rows that you want inserted below.
This function is also available from the “Home” tab by selecting “Insert” from the “Cells” then “Insert Sheet Rows. " Inserting multiple columns requires you to select multiple columns to the right of the location in which you wish to place new columns. Simply select the same number of columns that you want inserted to the left.
If your cell contains a formula, “Paste” will paste the formula not calculated value of the formula. In order to “Paste” cell values, use “Paste Special”
Depending on your version of Excel, other options in the “Paste Special” may include “Comments” (text comments which can be added to individual cells), “Formats” (all text formatting selections), or “All” to paste everything at once. [5] X Research source
You can also learn more about How to Type Formulas in Microsoft Excel
You can also reference values from other worksheets. Begin by selecting the cell in which you wish to reference a value, type an “=’ in the formula bar and then type your desired formula immediately after the “=. " After typing the formula, simply click on the tab for the worksheet you wish to reference and then select the desired data range that you want entered into the formula.
If this option is unavailable, you are in a Read-Only format. Under “Track Changes,” check the option next to “Track changes while editing. This also shares your workbook. " Once this option is selected, then you can make changes and view those changes by selecting this option again and checking the box next to “Highlight Changes. "
A right-click on a cell or group of cells also brings up formatting options. After right-clicking the cell(s), select “Format Cells. " This will provide you a number of options with respect to Number (style), Alignment, Font, Border, Patterns and Protection.
You can also adjust your text to fit cells so that columns and rows automatically adjust their width or height (respectively) in order to accommodate the content within a cell. Under the “Home” tab, look at the “Cells” group of buttons and click “Format. " From the “Format” menu, select “Cell Size” and click either “AutoFit Column Width” or “AutoFit Row Height. "
