WHY DOES THE FONT SIZE OF SOME CELLS IN EXCEL SUDDENLY BECOME LARGER?

The reason is because of a problem with the cell settings.

The specific steps to solve the problem are as follows:

The materials that need to be prepared are: computer, excel**.

1. First open the required excel** and select the cells that need to be set.

2. Then click to open the "Options" in the file in the upper left corner.

3. Then click to open the inverted triangle behind the "font size" in the pop-up window.

4. Then click on the font size you want to set in the pop-up window, and press Enter to confirm.

Maybe the cells are formatted in a special way.

Here's an example of how to do this:

The tools we need are: computer, excel

1. Open excel and select the whole **, right-click and select the "Format Cells" option.

2. Set the required glyph and font size in the "Font" menu of the dialog box.

3. After the setting is confirmed, the font in ** will be uniformly fixed.

The reasons why the font size of some cells in excel suddenly becomes larger and the solutions are as follows:

There are two reasons for this:

1. The cells are set with a special format.

2. The font is automatically adjusted in the cell formatting settings.

Here's how to solve it:

Use the format painter to brush it and adjust the format to match the need.

Select all the cells that need to be formatted as a whole. Or use the formatting brush to select the correctly formatted cells, and then brush the cells that need to be reformed.

You can use a brush, and the brush is the same before it is formatted.

Formatting – style (turn it to what you want and everything will become what you want).

Press"ctrl"Hold on to the button, then slide the key in the middle of the mouse, and slide forward to zoom in; Press "Ctrl.""If you don't put the key and slide it back, it is to shrink out. The steps are as follows:

1. Now, take the text in cells A1 and B1 in the following figure as an example. Now make the A1 and B1 cells smaller.

2. When the cell is reduced, the text in the cell will not automatically shrink as the cell shrinks to fit the cell.

3. So, we need to make some settings. Now, return the cell to its original state. Then, select the two cells.

4. Place the mouse on the selection, right-click the mouse, and click "Format Cells" in the pop-up menu.

5. You can also operate in this way, the mouse will pop up the operation box under the downward oblique arrow point in the lower right corner of the "Font" group of the "Start" tab.

6. In the pop-up operation box; Then, click on the "Alignment" tab, and the relevant options will pop up below; Put a checkmark on "Shrink font fill". Then click OK at the bottom right of the action box.

7. The operation frame is automatically closed; Back in **, at this point, we can shrink the cell. The font shrinks as the cell shrinks, and the cell size is automatically applied.

This whole worksheet enlargement and reduction is not only used in excel, but also can be used in word and other software, now this method is shared with you, I hope you can be flexibly applied to various software interfaces.

Open the excel file, sometimes you may feel that the font is small or very large, and you need to enlarge or shrink.

An easy and practical way to do this is to use shortcuts.

Press"ctrl"Hold on to the button, then slide the key in the middle of the mouse, and slide forward to zoom in; Press "Ctrl.""If you don't put the key and slide it back, it is to shrink out.

Now you can see the words on your sheet zoom in or out.

The second way is to be in the status bar, and the status bar is at the bottom of the ** is the status bar.

Right-click there in the status bar and select Show Scale; Choose the display ratio groove well.

There is a percentage data at the bottom right.,This is the proportion displayed.。

point percentage number, a box will appear, a box with a proportional selection.

At this point, you can adjust the scale numerically according to the size you want.

After the adjustment, press OK to see you**font enlarged or reduced.

You can use the plus sign, minus sign and slider in the bottom right corner to adjust the size of the zoom and make the text larger. Alternatively, you can zoom in and out of the chart with mouse + scroll wheel.

You can also select the cells and resize the text to make it larger.

1. Click the cell you want to set, right-click and select Format Cell. 2. Click on the font, set the font to the required size in the font size, and click OK.

The example operation steps are as follows: the tools we need are: computer, word1, first open the word document, and then select the text content that needs to be modified.

2. Then click the right mouse button and select the "**Properties" option in the shortcut menu list. 3. In the pop-up property dialog box, click to enter the "Row" option, and set the "Row Height" to "Minimum" to confirm.

Shrink the font fill", the solution to the problem is as follows:

1. As shown in the figure below, the font size of cells A1 and B1 can be clearly seen with the naked eye, and then click on the A1 cell, you can see that the font in the cell is "Song Ti No. 11 Liquid He Pei".

Second, then click on the B1 cell, you can find that the font is also "Song Ti No. 11", in this case, you can determine that it is caused by the option of "reduce font fill".

3. Click "Cell A1" with a small font, and then click the "Arrow" in the lower right corner of "Alignment" under the "Start" menu.

4. Uncheck "Shrink Font Fill" in the alignment panel and click "OK".

5. The final effect is as shown below, at this time, the font of the two cells is restored to the same size (in fact, there are some other ways to solve this problem, such as: drag to increase and reduce the column width of the font; Or use auto-resize column widths in formatting. As long as the column width is large enough, the body will not automatically shrink).

Font auto-minification in Excel may be due to some specific settings. Here are a few possible reasons for this:

1.Cell Formatting: You may have set the "Automatically scale font size to fit cells" option in the Format Cells row.

This causes Excel to automatically reduce the font size when you enter more than the width of the cell so that the text is fully displayed in the cell.

2.*Print Settings**: In"Page layout"or"Print preview", there is a setting called"Zoom to page size", which will resize your worksheet to the size of the printed page.

If this option is checked, the text may appear smaller when printing or previewing the print.

3.*Conditional Formatting**: If you use conditional formatting and set up automatic font size adjustment under certain conditions, it may also cause the font size to change.

If you don't want the font size to change automatically, you can check the above settings and adjust them appropriately. If your problem is not resolved, it may be caused by other more complex factors, such as macros, VBA**, etc., and you may need to seek professional Excel help.

Excel modifies the font size in ** and then changes back because ** content is frozen and locked, and the font size can be modified after unfreezing and unlocking.

Tools Material: Microsoft Office Excel 2016 Edition, Excel**.

1. First, select Excel** and double-click to open.

2. Then in the interface, select the cells you want to modify.

3. Then in the interface, click on the "View" option at the top.

4. Then in the interface, check the "Unfreeze Pane" option in the "Freeze Pane".

5. Then in the interface, click on the "Start" option at the top.

6. Then, in the interface, modify the font size of the cells to be modified in **.

7. Finally, in this interface, the font size of the text in the cell is successfully modified.

The words in excel** have become very small, what's going on.

The characters in Excel** have become smaller, one is that the zoom function is used, and the other reason is that the font is too small. Here's how to adjust the font:1

Open the excel file, and you can see that the text is very small. 2.We can click on the "View" function in the first click.

3.Find the "Display Scale" feature. 4.

Adjust the display ratio to "100%", and click "OK".