Hi, Michael,I learnred these keystrokes long ago using Excel 97 so hope they work with your version.
The basic idea isStep 1 - select the columns you want to change. You can select a column by pressing Control plus Space, and you can extend the selection to the right by then pressing Shift plus Right. To select everything, press Control plus A. Step 2 - Format the columns. Alt plus O gets you the format menu, C selects columns, then you can press A for automatic sizing, or W to select an exact with for the chosen columns.
Hope that's of help. Vince.----- Original Message ----- From: "Michael Ray" <mike.ray@xxxxxxxxxxxxxx>
To: "Access-UK" <access-uk@xxxxxxxxxxxxx> Sent: Sunday, October 21, 2012 3:31 PM Subject: [access-uk] Column Widths in MS Excel
Hello list.This is probably a dead simple task but I use Excel so infrequently that I have never found out how to do it.How do you expand and contract the width of a column in Excel using only the keyboard? I am still using Office 2000 under XP.Mike Ray ** 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