some columns 30 characters 155 pixels others 310 pixels why

G

Guest

I've got 8 worksheets in a workbook where the first column is 30 characters
(155 pixels). I have 11 worksheets in the same workbook where the first
column is 30 characters (310 pixels). I can see no differences other than
the colums that are 310 pixels are twice as wide. Pasting the format of the
155 pixel sheets over the 310 pixel sheets does not solve the problem. how
did this occur? how do i fix it?
 
G

Guest

hi
if you select the column , then select the format painter, then go to the
shet to change and clck on the column header it should reformat to the
correct one - you can also save energy by selecting al the sheets to change
at oce and then click on the coumn header..

think this works..

david r
 
G

Guest

Thanks but it didn't work. Excel recognizes the 30 characters as being the
same on both sheets but on one 30 characters is 155 pixels and on the other
30 characters is 310 pixels.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top