Excel 2007 Autofit row/column height

  • Thread starter Thread starter CentralBased
  • Start date Start date
C

CentralBased

Autofit's been part of Excel since the beginning. Anyone know where the path
is for Excel 2007?
 
Home tab, then dropdown named Format on the right hand side

--


Regards,


Peo Sjoblom
 
It's on the Home tab, Cells section, Format dropdown

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Autofit's been part of Excel since the beginning. Anyone know where the path
| is for Excel 2007?
 
You can use the shortcut of double clicking the right-hand (or bottom) guide
line in the column's (or row's) header.
 
To make my explanation clearer, pretend you are going to manually resize a
column with your mouse. Place your mouse in the header over the right or
bottom guide line... when the cursor changes to a vertical line (for
columns) or a horizontal line (for rows) with two arrows pointing in
opposite directions, then double click the left mouse button.
 
You must log in or register to reply here.

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

Similar Threads

Autofit Row Height 4
Currency autofit 5
How do I autofit row height to adjust to new text on Excel form? 1
Excel 2007 - Rows - Height - AutoSize question 1
How do I turn off Autofit 2
Autofit row height 7
Selecting AutoFit 4
Are there limits autofit row height when the cell is set to wrap t 3

Back
Top