Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 58
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Make table query will work in datasheet view but will not make tab WildlyHarry Excel Discussion (Misc queries) 0 August 28th 07 03:06 PM
cursor moves view instead of selection Nigel Excel Discussion (Misc queries) 2 August 13th 06 09:42 PM
How do I keep the selection box in the work area Ken Dean Excel Discussion (Misc queries) 2 June 27th 06 09:45 PM
work sheet view flips horizontally Ross Excel Discussion (Misc queries) 3 November 2nd 05 04:06 AM
Spin button in a work sheet - how do I make it work? [email protected] Excel Worksheet Functions 1 April 7th 05 08:43 PM


All times are GMT +1. The time now is 07:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"