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.

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.

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.

Seek for Edit Links and Break Links commands in Ribbon if you do not have Classic Menu for Office Click the Data tab; Go to the Connections group; Then you will view the Edit Links button.

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).