Here are some problems that our users have asked and received explanations on
Autofit columns A:M. Set the orientation to Landscape, set the Width to 1 page, center the worksheet Horizontally. Insert a footer with the file name in the left section and page number in the right section
Solved by S. W. in 18 mins
I have an excel workbook that all the columns somehow were set to .06 or .25 as a default. I can go in and change them but is there a way to reset the workbooks to autofit or a 10.0 column width without changing every tab individually? it sometimes reverts to this even after I have changed the individual tab and saved the file.
Solved by V. D. in 19 mins
Create a formula with structured references to calculate the percentage of the Sticker Price in column E.
Format the range E2:E30 with Percent Style Number Format.
Add a total row to display the Average of % of sticker and Sum of Sticker Price and Sale Price.
AutoFit the width of columns B:E to show the total values.
Apply Solid Fill Blue Data Bars conditional formatting to the % of sticker data.
Solved by F. J. in 14 mins
how do you increase the width of a column
Solved by G. D. in 26 mins
Excel changes the width of columns and rows upon saving and reopening files that worked great for years until a few days ago when it started having this issue at random. Office 365 Home on windows 10 with latest updates running on ASUS laptop with more than enough capabilities for all common applications. Tried disabling autofit columns, tried turning off all protected view settings... at a loss