Excel Tip of the Day
Quickly size columns and rows to fit your data (Excel 97/2000/2001/2002)
It's incredibly easy to modify a worksheet's column and row sizes. All you have to do is click and drag the separating line between two column or row headings. However, if you're constantly adjusting the sizes to fit changing data, there's an even easier way to ensure that a column or row is big enough to display your data.
Instead of dragging the heading separator line, double-click on it. When you do so on a column separator, Excel automatically resizes the column so it's wide enough to display the widest item in the column. Likewise, double-clicking on a row heading separator changes the row height to acccomodate the tallest row entry.
You can apply this trick to multiple columns and rows at once. To do so, select the multiple row or column headings that you want to resize. Then, double-click on a separator line associated with any one of the selected headings.
(Content provided by Element K Journals)
(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
Print
CloseCopyright © 2001 - 2025 MJ Technologies, LLC. All rights reserved.