1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
san4es73 [151]
3 years ago
12

How can you best integrate a website into a excel spreadsheet and allow it to link back to the website

Computers and Technology
1 answer:
Ivahew [28]3 years ago
8 0
To import and connect a website in an Excel sheet, you can do as these:

1. Click Data > From Web.
doc import connect website 1

2. Then in the New Web Query dialog, type the website address you want to import into Address textbox, and click Go to display the website.
doc import connect website 2

3. Click Import, and the Import Data dialog pops out for selecting a cell or a new sheet to place the webpage content. See screenshot:
doc import connect website 3

4. Click OK. Now all webpage content excluding images have been imported in the sheet.
doc import connect website 4

5. Then select the whole worksheet, and then click Data > Properties in the Connections group. See screenshot:
doc import connect website 5

6. In the External Data Range Properties dialog, check the options as you need in Refresh control section and click OK.
doc import connect website 6

7. Also you can refresh the sheet contents by manually clicking on Refresh All > Refresh All/Refresh.
You might be interested in
Write a c++ function, largestnum, that takes as parameters a double array and its size and returns the index of the last occurre
miv72 [106K]
Not a Question so how am i supposed to help with this problem
6 0
3 years ago
When reading words with a scanner object, a word is defined as ____?
nata0808 [166]
In Java, it would be String object.
6 0
4 years ago
User-system interaction is?
Mandarinka [93]
A multidisciplinary, post-Master<span> educational program which provides practical training in the field of </span>human-computer interaction and user interface design<span>.</span>
8 0
3 years ago
When your hands are on home row, your left hand rests lightly on _____. J K L ; A S D F Z X C V Q W E R'
Viktor [21]

your hands sould rest on A S D F, H J K L.

7 0
3 years ago
My Mac is stuck on this screen? How to fix?
mixer [17]

Answer:

Press and hold the power button for up to 10 seconds, until your Mac turns off. If that doesn't work, try using a cellular device to contact Apple Support.

Explanation:

If that also doesn't work try click the following keys altogether:

(press Command-Control-Eject on your keyboard)

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

This makes the laptop (macOS) instruct to restart immediately.

Hopefully this helps! If you need any additional help, feel free and don't hesitate to comment here or private message me!. Have a nice day/night! :))))

<em>Another Tip:</em>

<em>(Press the shift, control, and option keys at the same time. While you are pressing those keys, also hold the power button along with that.)</em>

<em></em>

<em>(For at least 10 seconds)</em>

6 0
4 years ago
Other questions:
  • What does a contain after the following code runs?int[] a = {1, 3, 7, 0, 0, 0};int size = 3, capacity = 6, value = 5;int pos = 0
    10·1 answer
  • If your accelerator is stuck while driving, first ___.
    14·1 answer
  • Harry needs to make a presentation on endangered species of animals. Which presentation software elements can he use to display
    5·1 answer
  • We discussed making incremental dumps in some detail in the text. In Windows it is easy to tell when to dump a file because ever
    5·1 answer
  • Is it important for a writer to include voice and point of view in writing because... Plz help
    15·1 answer
  • What are the values of a[k] and a[k+1] after code corresponding to the following pseudocode runs?
    9·2 answers
  • Which popular file format loses some of the information from the image? JPEG TIFF RAW NEF
    12·1 answer
  • This is more a question for Brainly,
    5·2 answers
  • B. Directions: Fill in the blanks with the correct answer.
    13·1 answer
  • A processor's speed is measured in megahertz (MHz), or millions of instructions per second; and gigahertz (GHz), or billions of
    9·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!