Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

On a test I have to resize columns in Excel simultaneously to 100 pixels. Any idea on how to do this? Give multiple answers if possible.?

3 Answers

Relevance
  • 6 years ago

    by default, 1 column width is 8.43 pixels. Do you mean you need to change 100 columns to 1 pixel each? or 1 column to 100 pixels? Either way, highlight however many columns you want to simultaneously change, right click on the column, the part where the letters are (not the actual cell) and click "column width...". A popup box should appear, and you could type in the amount of pixels. Hit enter.

  • IXL@XL
    Lv 7
    6 years ago

    Selct the columns to change width, left click on edge of columns (double headed arrow appears and drag edge to the right if you want wider, left if slimmer (read off the width that appears next to cursor (pixels and cm's)

  • 6 years ago

    @SailorDumb

    While the default column width in Excel is 8.43, that is based on the default font Excel assigns of Arial 10. If you change your font, the column widths will change.

    The 8.43 value means that the column will display 8.43 characters of Arial 10, based on the character width of '0'.

Still have questions? Get your answers by asking now.