Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adjusting columns
I have data from a1:g35, When I start typing in A40 is there anyway to adjust
my columns so they only apply to a40 and below? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adjusting columns
?? -- Don Guillett Microsoft MVP Excel SalesAid Software "Té" wrote in message ... I have data from a1:g35, When I start typing in A40 is there anyway to adjust my columns so they only apply to a40 and below? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adjusting columns
Simple answer is NO. All cells in a column will be the same width.
You may be able to get added width by merging cells in other columns, but that can cause other problems. "Té" wrote: I have data from a1:g35, When I start typing in A40 is there anyway to adjust my columns so they only apply to a40 and below? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adjusting columns
So there isnt any to set a column for different ranges of cells? Columns
apply to the entire worksheet? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adjusting columns
You could merge cells in the same row that will give you the appearance of wider
columns. But once you work with merged cells for more than 30 seconds, you'll find that there are so many things that are screwy that you'll never want to use them again! Té wrote: So there isnt any to set a column for different ranges of cells? Columns apply to the entire worksheet? -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adjusting columns
Column width applies to the entire colulmn.
Each entire column can be a different width. Same for row height. You could workaround for visual and printing by cutting the lower source range to another worksheet, adjust columns then take a picture and paste that back into the source sheet. Gord Dibben MS Excel MVP On Fri, 4 Apr 2008 14:33:00 -0700, Té wrote: So there isnt any to set a column for different ranges of cells? Columns apply to the entire worksheet? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adjusting columns
Thank you everyone!!!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adjusting columns at the end of a document | Excel Discussion (Misc queries) | |||
Automatically adjusting columns | Excel Discussion (Misc queries) | |||
Adjusting series | Charts and Charting in Excel | |||
adjusting columns in multiple worksheets of workbook with one step | Excel Discussion (Misc queries) | |||
Macro / VBA adjusting variable columns | Excel Discussion (Misc queries) |