ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Different column widths within one worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/129505-different-column-widths-within-one-worksheet.html)

saramac24

Different column widths within one worksheet
 
I'm wondering if there is a way to have two different column widths in one
worksheet. We have two groups of data that need to be seperated differently
for formatting reasons, but that need to be displayed on the same page. Is
there a way to accomplish this?

Ron de Bruin

Different column widths within one worksheet
 
Hi saramac24

If you want to do this for viewing or printing see
http://www.rondebruin.nl/print.htm#non-contiguous

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"saramac24" wrote in message ...
I'm wondering if there is a way to have two different column widths in one
worksheet. We have two groups of data that need to be seperated differently
for formatting reasons, but that need to be displayed on the same page. Is
there a way to accomplish this?


Dave F

Different column widths within one worksheet
 
Adjust the width of the relevant column. Move the cursor to the vertical
line between, say, A & B, click and drag to adjust the width of column A.
Repeat as necessary.
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"saramac24" wrote:

I'm wondering if there is a way to have two different column widths in one
worksheet. We have two groups of data that need to be seperated differently
for formatting reasons, but that need to be displayed on the same page. Is
there a way to accomplish this?


Lauren Giles

Different column widths within one worksheet
 
Well, it is possible to have different column widths, but not in the same
column. Is that what you're asking?

"saramac24" wrote:

I'm wondering if there is a way to have two different column widths in one
worksheet. We have two groups of data that need to be seperated differently
for formatting reasons, but that need to be displayed on the same page. Is
there a way to accomplish this?


saramac24

Different column widths within one worksheet
 
Sorry. Yes that is what i meant. My boss wanted me to have the same column
two different widths in 2 differnet sets of rows. I didn't think it was
possible, but told her that I'd post to be sure.

Thank you all for your responses.

"Lauren Giles" wrote:

Well, it is possible to have different column widths, but not in the same
column. Is that what you're asking?

"saramac24" wrote:

I'm wondering if there is a way to have two different column widths in one
worksheet. We have two groups of data that need to be seperated differently
for formatting reasons, but that need to be displayed on the same page. Is
there a way to accomplish this?



All times are GMT +1. The time now is 05:50 AM.

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