Easy Tips Computer Help Made Simple

Home	Mobile Computing	John & Renie	Computer Terms	DLLs & Drivers	Links
Computer Threats	Computer Basics	Hardware	Software	Easy Tips	Tech Talk

Using Autofit in Excel by John Anthony Sometimes the text you enter in a cell is wider than the column width setting and it spills over into the column(s) next to it. Autofit adjusts the column width to match the width of the cell with the longest text. For Excel 2010 Select the column you want to adjust by placing your cursor over the column heading and clicking your mouse. The entire column is selected. Select 'Format' from the ribbon (menu bar) and a drop-down list appears. In the drop down list select 'Autofit Column Width' and the column width changes to match the width of the cell with the longest string of text. For Excel 2000 Select the column you want to adjust by placing your cursor over the column heading and clicking your mouse. The entire column is selected. Select Format from the menu bar and a drop-down list appears. Select Column from this list and a menu opens. Select ‘Autofit Selection' and the column width changes to match the width of the cell with the longest string of text. Contact Information Computer Help A to Z 88 Windmere Drive Angier, NC 27501 CompHelpAtoZ@charter.net Copyright 2000-2018

Home	Mobile Computing	John & Renie	Computer Terms	DLLs & Drivers	Links
Computer Threats	Computer Basics	Hardware	Software	Easy Tips	Tech Talk