How to Use an Excel Spreadsheet in FrontPage
FrontPage and Excel are Microsoft applications. FrontPage allows you to create Web pages without HTML while Excel lets you create spreadsheets. Although you can't use Excel's calculations in FrontPage, you can display the contents of the spreadsheet in FrontPage. This keeps you from having to recreate an existing spreadsheet in FrontPage. When you insert an Excel spreadsheet into FrontPage as a file, FrontPage may prompt you to install a converter. FrontPage will install the components that you need for the application. You can modify the spreadsheet as you would a FrontPage table once it's added.
Other People Are Reading
Instructions
-
Use by Copying and Pasting
-
1
Start Excel and open the spreadsheet that you want to use. Highlight the cells that you want to copy. To select the entire spreadsheet, click the "Select All" button (on the left of the column A header).
-
2
Right-click and select "Copy" from the pop-up window.
-
-
3
Minimize Excel. Go to FrontPage and open the HTML file that you want to modify.
-
4
Place your cursor where the spreadsheet will go. Right-click and select "Paste" from the pop-up list.
Use by Inserting as File
-
5
Open the HTML file that you want to modify in FrontPage.
-
6
Place your cursor where you want the Excel spreadsheet to appear.
-
7
Select "Insert" and "File" from the FrontPage menu. The "Select File" dialog box will appear.
-
8
Change "Files of type" to "All Files (*.*)" in the drop-down list and double-click the Excel spreadsheet file. The Excel spreadsheet is placed in FrontPage.
Modify Spreadsheet in FrontPage
-
9
Go to the Excel spreadsheet that you want to format or edit in FrontPage.
-
10
Highlight any content that you want to remove and press the "Delete" key. To edit existing data, type in the data that you want to add.
-
11
Right-click on the spreadsheet and select "Table Properties." The "Table Properties" dialog box displays.
-
12
Modify the layout (alignment, cell padding, spacing, width and height), border (size and color) and background color of the spreadsheet. Click "OK."
-
13
Click on a cell to add a row or column to the spreadsheet. Right-click and select "Insert Rows" or "Insert Columns."
-
1
