iopcasting.blogg.se

With over 100 Excel keyboard shortcuts Why use keyboard shortcuts in Excel? If you want to learn more keyboard shortcuts I recommend you download my free PDF with over 100 Excel keyboard shortcuts by clicking here. Next type the keyboard shortcut ALT + H + O + I to automatically resize the columns. So we first select the current region of cell B5 by pressing (Control + Shift + 8). 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. Keyboard shortcuts to autofit column widthĪs 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.įirst select the cells you want to autofit. Now we are now going to use keyboard shortcuts. Then we looked at the autofit column width feature, accessed via clicking on the built in menus. In the previous post we looked at the mouse double-click trick, 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. 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 #.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.(1) we can’t read all the text, (2) we can’t see any of the dates The list of contacts in the screenshot above has two problems