Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make View Fit Selection work?
First, I Autofit a set of columns. Then I select the columns and do
View Fit Selection. Often, some of the columns are no longer wide enough. And if I subsequently Autofit the columns, the columns often no longer fit within the view. Catch-22! I work around the problem by doing the following. First, I Autofit the columns. Then I select the columns __plus__ one (or two) more column(s), and I do View Fit Selection. Then I Autofit the columns again. Is there a better way to make View Fit Selection work? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make View Fit Selection work?
I use your workaround with just a single column--I make it as skinny as I can.
Then I don't worry if it gets chopped a bit. " wrote: First, I Autofit a set of columns. Then I select the columns and do View Fit Selection. Often, some of the columns are no longer wide enough. And if I subsequently Autofit the columns, the columns often no longer fit within the view. Catch-22! I work around the problem by doing the following. First, I Autofit the columns. Then I select the columns __plus__ one (or two) more column(s), and I do View Fit Selection. Then I Autofit the columns again. Is there a better way to make View Fit Selection work? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make table query will work in datasheet view but will not make tab | Excel Discussion (Misc queries) | |||
cursor moves view instead of selection | Excel Discussion (Misc queries) | |||
How do I keep the selection box in the work area | Excel Discussion (Misc queries) | |||
work sheet view flips horizontally | Excel Discussion (Misc queries) | |||
Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions |