| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do a make a column wider than the screen?
I have a column with a cell content longer the myscreen. After I dragged the
line to make it wide, I arrived at the right end of the srcreen and i can't drag it anymore.How do i make that column wider?The data in that column is right know spread over 2 columns and I need to make it fit in 1 single column . Any suggestion? -- capxc |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do a make a column wider than the screen?
Change the zoom factor to something smaller (like 25%) and you'll see more
screen realestate. Or use format|column|Width and type what you want. (xl2003 menus) capxc wrote: I have a column with a cell content longer the myscreen. After I dragged the line to make it wide, I arrived at the right end of the srcreen and i can't drag it anymore.How do i make that column wider?The data in that column is right know spread over 2 columns and I need to make it fit in 1 single column . Any suggestion? -- capxc -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do a make a column wider than the screen?
I know this isn't a great solution, but you can change the magification of
the screen from 100% to 75% or 50%. "capxc" wrote: I have a column with a cell content longer the myscreen. After I dragged the line to make it wide, I arrived at the right end of the srcreen and i can't drag it anymore.How do i make that column wider?The data in that column is right know spread over 2 columns and I need to make it fit in 1 single column . Any suggestion? -- capxc |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do a make a column wider than the screen?
Use formula is instead of cell value is where A1 is the cell wikth the
conditional formating condition 1 =IF(A1=TODAY(),TRUE,FALSE) Add second condition condition 2 (within 7 days) =IF(A1+7=TODAY(),TRUE,FALSE) A day is one so adding 7 is equivalent to within 7 days "Joel" wrote: I know this isn't a great solution, but you can change the magification of the screen from 100% to 75% or 50%. "capxc" wrote: I have a column with a cell content longer the myscreen. After I dragged the line to make it wide, I arrived at the right end of the srcreen and i can't drag it anymore.How do i make that column wider?The data in that column is right know spread over 2 columns and I need to make it fit in 1 single column . Any suggestion? -- capxc |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make Validation List Wider - Excel 2003 | Excel Discussion (Misc queries) | |||
| How do I make the drop-down portion of a list wider than the cell? | Excel Discussion (Misc queries) | |||
| Make Dropdown List Temporarily Wider & Same Width for Multiple Col | Excel Discussion (Misc queries) | |||
| Help with Macro - Make Dropdown List Temporarily Wider | Excel Discussion (Misc queries) | |||
| How to make fx field wider? | Excel Discussion (Misc queries) | |||
Linear Mode
