Posted on 2011-03-03
Medium Priority
Last Modified: 2012-05-11
I have set this at 250 point because it is not too important to me, and because I don't have much time to devote to the problem.  But, if somebody has an easy solution that does a good job I will bump points to 500.

When pasting HTML into a spreadsheet, Excel does a pretty good job of honoring HTML formatting.

The big exception is column widths which Excel simply ignores.

In a certain way, this makes sense because internet browsers also tend to "ignore" column width.  When HTML is rendered on a high resolution display, it will look totally different than when it is squeezed into a low resolution display.  Luckily, I hardly ever care what the pasted data looks like, but sometimes I spend a fair amout of time adjusting column widths manually to make things look better.

Does anybody have any nifty tricks that will do this more or less automatically?  
Question by:rberke
  • 2
LVL 30

Accepted Solution

SiddharthRout earned 1000 total points
ID: 35032199
Unfortunately there is no inbuilt method to do that or maybe I am not aware of it. I will share what I usually do. After pasting, I select all the cell in the worksheet and then I expand any one of the columns. This expands the columns for the rest as well. I repeat the same with rows. Once done I simply double click between the column headers or Row headers and Excel automatically auto fits them for me. If anything is still left, then I manually do it.


Author Comment

ID: 35032791
And I will share what I usually do:  After pasting html to Excel, I select the entire sheet and turn text wrapping off and autosize all rows.  

I then go back to the source website, and use Snagit (or similar screenshot software) to cut a picture of the webpage the way it really looks.  

I return to excel and paste that picture onto the spreadsheet and resize picture to be about the "right" size.

I then start on the leftmost column and drag it to match the picture's first column. I then drag the second column to match etc.

I then "eyeball" the spread sheet and turn wrapping back on to whichever columns seem to need it.

Quite a pain the you-know-what.


Author Closing Comment

ID: 35116781
The portion of the solution that is "complete" is the portion that says there is no builit in tricks, other than the tricks we all have already been using.

So I am closing the question to keep it from laying around.

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
As a person who answers a lot of questions, I often see code that could be simplified, made easier to read, and perhaps most importantly made easier to maintain if the code was modified to use the Select Case statement. This article explains how to…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question