Not sure if you got an answer yet, but here's what I do in excel 2010. Press 
control and the #1 on the number row. You can then arrow down and perform 
various column formatting functions. Oh, and be sure to select the cells before 
pressing control 1.

I hope this helps.


Sent from Kimber's iPhone

> On Jun 17, 2016, at 3:32 AM, Hicks Steven (ROYAL CORNWALL HOSPITALS NHS 
> TRUST) <[email protected]> wrote:
> 
> Hi friends,
> 
> When using Microsoft Excel, one of the columns is not wide enough and I get a 
> message to tell me this when I navigate to it.
> Is there a way to auto-size the column as I used to be able to do this with 
> ctrl+space to highlight the whole column and then use the format menu in 
> older versions to select cell and width and auto select.
> 
> Steve.
> 
> 
> 
> Steven Hicks
> Servicedesk 2 team Leader
> Cornwall I.T. Services (CITS)
> Office:  01209 318620
> Email:  [email protected]<mailto:[email protected]>
> 
> 
> ********************************************************************************************************************
> 
> This message may contain confidential information. If you are not the 
> intended recipient please inform the
> sender that you have received the message in error before deleting it.
> Please do not disclose, copy or distribute information in this e-mail or take 
> any action in reliance on its contents:
> to do so is strictly prohibited and may be unlawful.
> 
> Thank you for your co-operation.
> 
> NHSmail is the secure email and directory service available for all NHS staff 
> in England and Scotland
> NHSmail is approved for exchanging patient data and other sensitive 
> information with NHSmail and GSi recipients
> NHSmail provides an email address for your career in the NHS and can be 
> accessed anywhere
> 
> ********************************************************************************************************************
> For answers to frequently asked questions about this list visit:
> http://www.jaws-users.com/help/

For answers to frequently asked questions about this list visit:
http://www.jaws-users.com/help/

Reply via email to