How to insert file in excel 2016 online

July 22, 2022
1.5K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

Inserting a file into a worksheet in excel is one of the most common and important tasks that you need to do with this application. Though it is pretty simple and easy to insert a file in excel, most people don’t know how to do so. There are different methods that you can use to insert data into the worksheet, but it all depends on what kind of the file you want to upload and how this file looks on your computer screen. You may have noticed that there are some icons in Excel which help you to properly use this application for different tasks such as forms or workbooks. The same goes for working with files, so I want to share with you some tips on how to insert a new sheet from another sheet into one or more cells in your worksheet. In this article, I will show you how to insert file in excel.

How to insert file in excel

This method works best with versions 2016/2016/mac/online. Follow the procedures below to insert file in excel:

1. In the Insert tab, click the File Object icon. The Insert File Object dialogue box appears.

2. Locate the target file and use the Open button to enter it into the spreadsheet.

3. After you click Open button, the file will be inserted and will start showing in the spreadsheet.

How to insert file in excel using Create New option

This method works best with versions 2016/2016/mac/online

1. Click the Object icon in the Insert tab and the Insert Object dialogue box will popup.

2. There are two methods for inserting objects: Create New and Create from a file. Select Create New.  Create New d irectly inserts the item. In the Object type roll-down list, select the type of object you wish to insert. WPS Spreadsheets supports a wide range of object formats, including WPS Spreadsheets Workbook, WordPad document, and Microsoft Excel.

3. Check the Display as icon box. The added object will thereafter be shown as an icon.

4.To finish the procedure, press the OK button.

How to insert file in excel using Create From File option

This method works best with versions 2016/2016/mac/online

  1. Click the Object icon in the Insert tab and the Insert Object dialogue box will popup.

2. There are two methods for inserting objects: Create New and Create from file. Select Create from file.

3. Then click on the Browse button to select that file you want to insert.

4. After clicking on the Browse button, select the file you want to insert and click Open.

5. Once you click open, you will return to the Insert object dialogue box. In the Insert object dialogue box click OK. And your file will be inserted in the spreadsheet.

 

Did you learn about how to insert file in excel? You can follow WPS Academy to learn more features of Word Document, Excel Spreadsheets and PowerPoint Slides.

You can also download WPS Office to edit the word documents, excel, PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience.