ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do a make a column wider than the screen? (https://www.excelbanter.com/excel-discussion-misc-queries/195526-how-do-make-column-wider-than-screen.html)

capxc

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

Dave Peterson

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

joel

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


joel

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



All times are GMT +1. The time now is 05:29 PM.

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