Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday. Miss a tip?Ĭheck out the Microsoft Excel archive, and catch up on our most recent Excel tips. Now when you resize the chart, the font size will not change. In the Font tab, clear the Auto Scale check box, and.In thatĬase, you don’t have to resize the text back to the original simply turn You may want to make the chart larger without changing the font size. When you make the chart smaller, the font size becomes smaller. When you make the chart larger, the font size becomes larger Title, legend, and the X/Y axis labels have changed?īy default, when you resize a chart, Excel adjusts the text Then, under Scaling, click Adjust to, and then enter the percentage of the normal size that you want. Have you ever tried to make your Excel chart larger byĭragging the corner sizing handle, only to find that the font size of the To do that, in Page Setup, click the Dialog Box Launcher. Note: Excel ignores manual page breaks when you use the Fit to option. In the Pages wide by and Tall boxes, enter the number of pages on which you want to print the sheet. On the Page tab, select the Fit To check box. Mary Ann Richardson explains how to turn off this default option by disabling auto font scaling. Print a sheet on a specified number of pages On the Page Layout tab, select Page Setup. When you resize an Excel chart, the text may be scaled accordingly, which in turn may make the words harder to read. Turn off Excel’s auto font scaling option
0 Comments
Leave a Reply. |