That solves the problem.Īnytime the cells stop autofitting, just manually adjust the cell width/height and redo the autofit on the cells. Now highlight the cells, and click Format, and Autofit Width, and then do Autofit Height. With the cursor changed, click and drag up/down for rows, and left/right for columns to manually adjust the column width for that row until the selection fits correctly. The cursor turns into an up and down arrow with a horizontal line through it for rows, and left and right arrows with a vertical line for columns. Put the cursor in between the column or row that has the cell in question, and the next column or row. Here is what to do for either columns or rows. The row or column with the cell that's not autofitting has more text than the previous cells. You've typed into a couple of cells and everything is going fine, until you type more text into another cell only to find the cell didn't autofit! What happened?! Ok, so you probably have all the rows/columns set to autofit. You can underline the text by using the Underline button that is placed besides the Italic button the keyboard shortcut to achieve this result is Ctrl + U. This can be achieved through a keyboard shortcut Ctrl + I. If you want to resize the row height, you can click Home > Format > AutoFit Row Height. See screenshot: Now you can see the cell is resized to fit the text. Click on the Alignmenttab, and then check the box next to Shrink to Fit. Select the cell and click on the Italic button that converts the text into Italic font. Select the cell and click Home > Format > AutoFit Column Width. So you've scoured the internet and finally here is the answer to your question!! You can also use Ctrl + 1to open the menu.
0 Comments
Leave a Reply. |