In the previous post we discussed how Excel provides a neat way to autofit the width of a column using either the mouse double-click trick or using the built-in Excel menus. In this post I will show you how to use a keyboard shortcut to accomplish the same task. If you want to learn more keyboard shortcuts you can download my free PDF with over 100 popular Excel keyboard shortcuts. What happens when your Excel Cell Content is too Wide to Fit in the Column? Here is the scenario. You have a table of contacts that lists names, e-mails and birthdays. Feb 28, 2017 - How to change the default column width in Excel. Select the worksheet(s) of interest: To select a single sheet, click its sheet tab. On the Home tab, in the Cells group, click Format > Default Width. In the Standard column width box, input the value you want, and click OK. You have either imported this list from your e-mail program or perhaps just typed the list into Excel. But as it stands there are two problems. Naruto shippuden episode 369 dub. The list of contacts in the screenshot above has two problems (1) we can’t read all the text, (2) we can’t see any of the dates • Problem 1: You can’t read the values in columns “Company” and “Email” as they are cut off by the values in the cells on their right. • Problem 2: You can’t see any of the date values in the birthday column because that column is not wide enough – instead all you see is a row of ######### In the we looked at the, where you select the columns you want to resize then double click on a column border to automatically resize the columns to fit the widest contents of that column. Then we looked at the autofit column width feature, accessed via clicking on the. Now we are now going to use keyboard shortcuts. Keyboard shortcuts to autofit column width (Excel 2007 & 2010) As in the previous post we will use the built in menus and use the autofit column width feature, this time using keyboard shortcuts to access Excel’s cool autofit feature. ![]() ![]() How to use the command prompt. First select the cells you want to autofit. Here we don’t want Excel to resize column B to fit the text in row 2 and row 3, because we only want the column to be just wide enough for the first names in our contact list. So we first select the current region of cell B5 by pressing (Control + Shift + 8). Next type the keyboard shortcut ALT + H + O + I to automatically resize the columns. If you want to learn more keyboard shortcuts I recommend you download my free PDF with over 100 Excel keyboard shortcuts. Autofit columns using keyboard shortcuts in Excel 2007 & 2010 Step by step instructions: • Select cell B5 • Expand the selection to the current region (using Ctrl + Shift + 8) • Type Alt + H to select the Home tab on the Excel ribbon • Type O to select the Format menu in the Cells sub-area • Type I to select “autofit column width” The keyboard shortcut ALT + H + O + I is my favorite method for automatically resizing column widths.
0 Comments
Leave a Reply. |