ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Partioning Excel Worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/25224-partioning-excel-worksheets.html)

edncory

Partioning Excel Worksheets
 
How do I partition an Excel worksheet into different areas so that I can
change column/row widths/heights per section?

Gord Dibben

You don't.

Column width and row height are the property of the entire columns and rows.

For presentation purposes only I could suggest using the "Merge Cells" format.

The merged cells will cause problems down the road if you need to copy, paste,
sort, filter and other functions I can't think of at the moment.


Gord Dibben Excel MVP

\On Sat, 7 May 2005 08:10:04 -0700, "edncory"
wrote:

How do I partition an Excel worksheet into different areas so that I can
change column/row widths/heights per section?



Earl Kiosterud

If you want to set several columns to the same width, select them by
clicking or dragging in the column header using Ctrl and/or Shift as
necessary. Now change any one column width, and the others will take on the
same width.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"edncory" wrote in message
...
How do I partition an Excel worksheet into different areas so that I can
change column/row widths/heights per section?





All times are GMT +1. The time now is 07:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com