Create a cell reference to another worksheet Click the cell in which you want to enter the formula. In the formula bar , type = (equal sign) and the formula you want to use. Click the tab for the worksheet to be referenced. Select the cell or range of cells to be referenced.

Method 2 Inserting a Link to a Webpage Copy the address to the site you want to link to. ... Select the cell in your Excel spreadsheet that you want to insert the link into. ... Click the " Insert" tab and click the " Hyperlink" button. ... Select " Existing File or Web Page" on the left side of the window.

Use numerical keypad shortcut to add rows in Excel Select the range in Excel to insert a new row. To do this left-click on the row number button next to the fist cell of the selection and extend the range keeping the left mouse button pressed. Now press Ctrl + Plus on the numerical pad.

Insert a static date or time into an Excel cell On a worksheet, select the cell into which you want to insert the current date or time. Do one of the following: To insert the current date, press Ctrl+; (semi-colon). ( Windows) To insert the current time, press Ctrl+ Shift+; (semi-colon).

Insert one or more rows, columns, or cells in Excel 2016 for Mac Select the heading of the row above where you want to insert additional rows. Tip: Select the same number of rows as you want to insert. ... Hold down CONTROL, click the selected rows, and then on the pop-up menu, click Insert. Tip: To insert rows that contain data, see Copy and paste specific cell contents.

Insert a page break Click the worksheet that you want to print. On the View tab, in the Workbook Views group, click Page Break Preview. You can also click Page Break Preview on the status bar. Do one of the following: ... On the Page Layout tab, in the Page Setup group, click Breaks. Click Insert Page Break.


In the Page Setup dialog box, on the Header/ Footer tab, click Custom Header or Custom Footer. To specify where in the header or footer you want the page number to appear, click inside the Left section, Center section, or Right section box. To insert numbers, click the Insert Page Number button .


Insert a horizontal or vertical manual page break Do one of the following: To insert a. Do this. Horizontal page break. Select the row underneath the row where you want the page to break. Vertical page break. ... On the Page Layout tab, click Breaks, and then click Insert Page Break.


To add spacing between lines or paragraphs of text in a cell, use a keyboard shortcut to add a new line. Double-click the cell in which you want to insert a line break. Click the location where you want to break the line. Press ALT+ ENTER to insert the line break.


Use the SUM function to add up a column or row of cells in Excel Click on the cell where you want the result of the calculation to appear. Type = (press the equals key to start writing your formula) Click on the first cell to be added ( B2 in this example) Type + (that's the plus sign) Click on the second cell to be added ( A3 in this example)