How do a make a column wider than the screen?

C

capxc

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?
 
D

Dave Peterson

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)
 
J

Joel

I know this isn't a great solution, but you can change the magification of
the screen from 100% to 75% or 50%.
 
J

Joel

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I print rows that go outside of the page without shrinking the text? 0
Column widths wider than Windows version? 4
Make the Name Box wider? 4
Can combo box be wider than its owner control? 1
Make combo list wider than visible box? 1
Changing the width of the style drop-down menu in Word 2011 0
Changing Column Width Temporarily 0
How do I make the drop-down portion of a list wider than the cell? 2

Top