Kevin
Thanks for your suggestion but it isn't quite what I am looking for. There
is an option somewhere which when selected will automatically widen the
column width to accommodate a cell which has more content.
Peter
-----Original Message-----
From: access-uk-bounce@xxxxxxxxxxxxx <access-uk-bounce@xxxxxxxxxxxxx> On
Behalf Of kevin.lloyd3 ("kevin.lloyd3")
Sent: Wednesday, January 17, 2024 1:24 PM
To: access-uk@xxxxxxxxxxxxx
Subject: [access-uk] Re: Excel help please
Hi.
Press applications key when focused on the cell.
Arrow up to Format Cells and press enter.
Use control tab to go to the Alignment tab.
Tab to the Shrink to Fit check box and press spacebar to check it.
Tab to OK and use spacebar to make the change.
I think the above is what you probably need.
Regards.
Kevin
-----Original Message-----
From: access-uk-bounce@xxxxxxxxxxxxx <access-uk-bounce@xxxxxxxxxxxxx> On
Behalf Of bentleypd3167 @ virginmedia . com ("bentleypd31")
Sent: Wednesday, January 17, 2024 9:42 AM
To: access-uk@xxxxxxxxxxxxx
Subject: [access-uk] Excel help please
Please could somebody remind me of the sequence to set cell width to
autofit.
Thanks.
Peter
** To leave the list, click on the immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** access-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq
** To leave the list, click on the immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** access-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq
** To leave the list, click on the immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** access-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq
