There’s a better way.

  1. Open Excel and choose a document to load. I’m going to load a Blank workbook, for the sake of this guide. 
  2. Place the mouse pointer inside a cell and click to select it. 
  3. Click the Format icon in the ribbon (on the right side) and select Column Width (or Row height if you want to change the height of a Row instead). 
  4. Enter the desired width, and press OK.  To do this for all columns, instead of a single one, keep reading. 
  5. Select an area by clicking in one cell, and dragging the highlighted portion to span the entire width and height of the section you’d like to resize.
  6. Repeat steps 3 and 4.  As an aside, there are also two cool tools within the Format menu (from step 3) – AutoFit Row Height and AutoFit Column Width. These two will automatically resize the column or row to encompass the size of the characters within it. For dates, it’ll remains small, while names and URLs will grow in size to accommodate.   

Microsoft Excel Tips

Previous TipNext Tip

Use VLOOKUP in ExcelBack Up Files Automatically in ExcelRemove Duplicate Data in ExcelCreate a Waterfall Chart in ExcelLock Cells in ExcelFreeze Rows and Columns in ExcelBuild a Forecast Chart in ExcelCreate a Funnel Chart in ExcelMake a Treemap in ExcelConvert Excel Sheets to Google SheetsOpen Google Sheets in ExcelCombine Data from Different CellsMerge Cells to Span Multiple ColumnsUse AutoFill for Repetitive DataCopy and Paste Repetitive Data the Easy WayUse Text to ColumnsDraw Diagonal Line in a CellCreate a New Shortcut MenuTranspose Columns Using Paste Special