ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Equal column widths (https://www.excelbanter.com/excel-discussion-misc-queries/237373-equal-column-widths.html)

Herb[_2_]

Equal column widths
 
Excel 2007
How to make columns of equal width within a sheet.
--
herb

Rick Rothstein

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



Jacob Skaria

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