ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Auto Fit (https://www.excelbanter.com/excel-worksheet-functions/26904-auto-fit.html)

Lady Rhyanon

Auto Fit
 
Hi. I am using Excel 2002. How do I get the Auto Fit feature to work? I
want the cells to automatically enlarge width and height to fit the text
that I place there.
Thanks
Lady R


Alan

Format on the Toolbar, Columns, Autofit Selection,
Regards,
"Lady Rhyanon" wrote in message
...
Hi. I am using Excel 2002. How do I get the Auto Fit feature to work? I
want the cells to automatically enlarge width and height to fit the text
that I place there.
Thanks
Lady R



Jef Gorbach

select the column(s).....(or the blank square between col.A/Row.1 for everything)
double-click the line between columns to autofit the selection's column widths
repeat for the row(s) heights
"Lady Rhyanon" wrote in message ...
Hi. I am using Excel 2002. How do I get the Auto Fit feature to work? I
want the cells to automatically enlarge width and height to fit the text
that I place there.
Thanks
Lady R




Lady Rhyanon

Thanks!
Hugs,
Lady R
"Alan" wrote in message
...
Format on the Toolbar, Columns, Autofit Selection,
Regards,
"Lady Rhyanon" wrote in message
...
Hi. I am using Excel 2002. How do I get the Auto Fit feature to work? I
want the cells to automatically enlarge width and height to fit the text
that I place there.
Thanks
Lady R




Lady Rhyanon

Yes, but I wanted a way to do it without having to go thru all that. I knew there was an autofit feature, just didn't know where it was...

Hugs,
Lady R
"Jef Gorbach" wrote in message ...
select the column(s).....(or the blank square between col.A/Row.1 for everything)
double-click the line between columns to autofit the selection's column widths
repeat for the row(s) heights
"Lady Rhyanon" wrote in message ...
Hi. I am using Excel 2002. How do I get the Auto Fit feature to work? I
want the cells to automatically enlarge width and height to fit the text
that I place there.
Thanks
Lady R




All times are GMT +1. The time now is 05:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com