Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 2nd 09, 05:27 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2009
Posts: 3
Default data sort box too big-can it be formatted



  #2   Report Post  
Old June 2nd 09, 05:52 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default data sort box too big-can it be formatted

Excel 2007?

Sort Dialog box can be reduced to about 3 inch by 6 inch at smallest.

Use sizing arrows to bring down to that size.


Gord Dibben MS Excel MVP

On Tue, 2 Jun 2009 09:27:01 -0700, Clee
wrote:


  #3   Report Post  
Old June 2nd 09, 06:01 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2009
Posts: 3
Default data sort box too big-can it be formatted

can it be formatted to stay the smaller size? I keep having to reduce it and
it is annoying


"Gord Dibben" wrote:

Excel 2007?

Sort Dialog box can be reduced to about 3 inch by 6 inch at smallest.

Use sizing arrows to bring down to that size.


Gord Dibben MS Excel MVP

On Tue, 2 Jun 2009 09:27:01 -0700, Clee
wrote:



  #4   Report Post  
Old June 2nd 09, 06:39 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default data sort box too big-can it be formatted

Once re-sized it should remain at that size.

If not, I have no ideas for you.

It is a global setting and not saved with each workbook.


Gord

On Tue, 2 Jun 2009 10:01:01 -0700, Clee
wrote:

can it be formatted to stay the smaller size? I keep having to reduce it and
it is annoying


"Gord Dibben" wrote:

Excel 2007?

Sort Dialog box can be reduced to about 3 inch by 6 inch at smallest.

Use sizing arrows to bring down to that size.


Gord Dibben MS Excel MVP

On Tue, 2 Jun 2009 09:27:01 -0700, Clee
wrote:




  #5   Report Post  
Old June 2nd 09, 09:27 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 3,346
Default data sort box too big-can it be formatted

Hi,

In case this didn't get through before

1. Please enter a quesion in the body of your emai; if you don't the web
won't let us reply, instead it displays the following error message.

"An error occurred while sending your post

We're sorry, but there was a problem with the system and your post was not
received. The error has been reported to Operations and will be investigated
as soon as possible. Please try again later."

This means, that to respond we need to start a separate thread - which is a
bad practice and wastes time.

===============
The sort dialog box starts out at its minimum each Excel session and is
remembered during the session. To make the window appear smaller you can
increase your screen resolution or get a bigger monitor.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Clee" wrote:

can it be formatted to stay the smaller size? I keep having to reduce it and
it is annoying


"Gord Dibben" wrote:

Excel 2007?

Sort Dialog box can be reduced to about 3 inch by 6 inch at smallest.

Use sizing arrows to bring down to that size.


Gord Dibben MS Excel MVP

On Tue, 2 Jun 2009 09:27:01 -0700, Clee
wrote:





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
Parsing formatted data Tufts Excel Discussion (Misc queries) 6 April 24th 08 09:57 PM
How do I sort dates that are not formatted correctly? curious1 Excel Discussion (Misc queries) 7 November 1st 06 10:14 PM
the format data - not formatted nnv1 New Users to Excel 0 April 19th 06 08:29 AM
Importing Formatted Data Jaybird Excel Discussion (Misc queries) 2 March 27th 06 07:36 PM
Converting 'General' formatted cells to Text formatted cell using. Zahid Khan Excel Worksheet Functions 1 March 12th 05 07:13 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017