Posts Tagged ‘help desk’

Export to Excel

One of the nice things of wor­king IT Sup­port is that I get to learn of new fea­tu­res I would not nor­mally use. This actually occu­rred the other day with a func­tion the Mic­ro­soft Excel adds.

We have all loo­ked at web­si­tes that has rows and rows of data that you would like to be able to use a dif­fe­rent sort (Fan­tasy Foot­ball Stats come to mind) or even your Cor­po­rate Intra­net sites that use a lot of tables for data.

Since I never knew it was there I never loo­ked for it, but if you are on a web page and would like to export, you can right click on the web page and when you get the drop down menu, look for the Export to Excel item (usually toward the bottom).

If you do not have the option, there is a registry fix that I have found on the Winhel­pon­line
web­site that is extremly help­ful and keeps you from having to manually edit the registry.

REG Files

To auto­mate the above set­ting, down­load the fileand save to Desk­top. Unzip and run the appro­priate REG file (exporttoexcel07.reg or exporttoexcel03.reg) for the ver­sion of Mic­ro­soft Excel ins­ta­lled. To remove the option, run the file undo.reg.

  Export to Excel Fix (971 bytes, 159 hits)

The full article can be found here.