Microsoft Excel is software famous for its many functions, but it also hides other possibilities and lesser-known tricks that are worthwhile. Today, we tell you how to make a simple website with Excel, step by step.
Microsoft Excel is popular software within the Microsoft Office group that allows us to apply countless mathematical operations through its functions.
Microsoft Excel allows you to do a great many things; you can even use it to create a simple website. Although it is not a specific program to develop web pages, Excel offers this possibility.
Create a simple web page with Excel, step by step
The first thing is to establish a micro design with the smallest parts of the web page that you want to create, such as the images, marking the cells. Next, the same structure is taken, encompassing several cells for each element: texts, footer, header, etc … After selecting each space, the Combine and the center button is used. When copying the text, you must adjust and justify it (or not) according to your preferences.
Images can be dragged and inserted into their corresponding cells. Both for the images and the text, you can change the size or change them. The last step is to export and save the excel file in a web page format. This will save the document in HTML. Once you have opened it again, you can start implementing changes such as adding blank spaces or enriching the text with bold and italics. You can also get more help related to this topic at 4d.dk.
How to Excel help in web pages
You can publish the data from your Excel files on a website; for this, you must use the Save as an option. The Microsoft Excel spreadsheet program allows you to insert data into a web page from which you have access to its HTML code.
With this, you can upload your reports, graphs, tables, etc. and publish them for everyone to have access to.
The steps
1. Open an Excel file where you have data ready to post on the web, either an entire book or a selection from one of the sheets.
2. Located on the sheet, click and drag with the mouse to select the range you want to publish.
3. In Excel 2010 and 2007, go to the File menu, select Save As and then click Other Formats. In Excel 2003 File, Save as web page.
4. A new window called Save As opens, in which you have to specify where you want to save it (left part of the screen) and the following information.
5. Give a name to the file.
6. In Save as type: drop-down in the black triangle and choose Website.
7. Notice that the bottom of the screen has changed.
8. Now you can specify a new name for the page to be published. To do this, click on the Change title button and type the one that seems most appropriate to you.
9. Press the Publish command; a new window opens where you can change the range or element to publish, the title you wrote earlier, indicate if you want the information on the web to be updated every time you change and save data in the book Excel,… In principle, we leave it as it is.
10. Of course, in the File name you have the Browse button; here you have to indicate the web folder or the FTP location of the page where you are going to insert this Excel information. Otherwise, it will create an alternative route that will be the web address of your data in Excel.
11. Before you click on the button Post, mark the option Open the page in the web browser so you can see how the site has been created.
12. With this, you already have your data published on the Internet, from any computer or device with an Internet connection it can be visited. You simply have to indicate the link path to the one you want to visit, or simply put a hyperlink in your Excel.