Note that some Excel applications automatically apply formatting to the contents of the sheet you select. Selecting data from a spreadsheet in Excel 2024 — Microsoft community Jan 10, 2024 — In the File or Office menu, select Save as. The Select a file type, then click Save. If you want to save the workbook to a network drive or a folder, select the folder or network drive to save the workbook to, then click Browse For Word or Excel 2024 (10.0) and older, open a Word workbook and use the Copy command to copy the selected text to an Excel worksheet. Click the cell you want to copy the text into and press CTRL+C when holding the SHIFT key. If you do not have a keyboard, you need to hold CTRL+C while holding SHIFT. A word about Excel macros: When Excel comes up with the data entry field (or any other cell), you can save the macro code to the cell, which is then automatically inserted in the data. That means there is no need to delete the code. The only problem is that the macro must be added to the top of the workbook in Excel, otherwise the data entry field has to be selected, and the contents of that field could overwrite the macro code. To add an Excel function, select Excel in the File menu, then choose Insert > Function To define new worksheets in Excel 2007/2010, on the toolbar, click Create New Table. Tip: Excel provides a shortcut for Insert > Function. To import a pre-existing worksheet, click File>New (or New Excel Workbook)>Add... (or New Excel Workbook)>Enter Click OK and Excel adds the worksheet and then loads the data from the worksheet. To import a new worksheet, click Excel. On the ribbon menu, click Add Worksheet. On the new worksheet, click Insert > Function (or Open Excel Worksheet to open the worksheet). On the function window, select the Excel worksheet you want to import, then click OK. To create a new worksheet, double-click on the worksheet you want to copy the text in. The ribbon menu pops up.