If your Excel spreadsheet is difficult to print, then consider adjusting the scale.
Step 6: Repeat steps 2 – 4, then press Alt + a to use the AutoFit Row Height function. Step 5: Press Alt + i to use the AutoFit Column Width function. Step 4: Press Alt + o to open the Format menu. Step 3: Press Alt + h to select the Home tab. Step 2: Press Ctrl + A on your keyboard to select the entire worksheet. Step 1: Open your worksheet in Excel 2013. These steps are also shown below with pictures – Repeat steps 2, 3, and 4 to get back to the Format menu, then press Alt + a to use the AutoFit Row Height command.Press Alt + i to use the AutoFit Column Width command.Press Ctrl + a to select the entire worksheet.
#Shorcut to make column width fit to size on excel for mac how to#
Here is how to use keyboard shortcuts to AutoFit rows and columns in Excel 2013 – The result of following these steps will be a worksheet where all of the row heights and column widths have been adjusted to fit the largest piece of data in that row or column.
The steps in this article are going to show you a series of keyboard shortcuts that will allow you to use the AutoFit commands to automatically resize all of the columns and rows in your worksheet. Our guide below will show you how to get to them without needing to use your mouse.Īutofitting Rows and Columns in Excel 2013 Without Using Your Mouse Copying and pasting, for example, is one action that can be made much quicker by using a keyboard instead of a mouse.īut there are keyboard shortcuts for many more Excel functions, including the AutoFit Column Width and AutoFit Column Height commands. Excel can be a lot easier to use once you get comfortable using keyboard shortcuts to perform common actions.
0 kommentar(er)
