Equal column widths
Excel 2007
How to make columns of equal width within a sheet. -- herb |
Equal column widths
There are two ways. Both start the same way... select all the cells (either
click the "empty" rectangle at the top left of the grid where the column letters meet the row numbers or simply select any cell and then press Ctrl+A). Now you can either click and drag the border between any two adjacent column letters to size the column to the left of the border to the size you want (the rest of the columns will adopt that width) or you can click Home/Cells/Format on the Ribbon and select "Column Width" from the drop down box that appears, then type in the width you want. -- Rick (MVP - Excel) "Herb" wrote in message ... Excel 2007 How to make columns of equal width within a sheet. -- herb |
Equal column widths
"Herb", you have posted the same in WSFunctions.
http://www.microsoft.com/office/comm...0-3abdf146e6ba If this post helps click Yes --------------- Jacob Skaria "Herb" wrote: Excel 2007 How to make columns of equal width within a sheet. -- herb |
All times are GMT +1. The time now is 10:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com