MCS

Transposing Data allows you to re-arrange rows into columns or vice versa- basically interchanging the two.

Learn to group columns together to easily contract and expand your worksheet in Microsoft Excel

When you have a document that spans multiple pages, you might want your column titles/headers to be repeated on each page.

Fractions are easy to use in Microsoft Excel. With a couple of clicks you can transform your decimal places to fractions. Learn more with this quick tip.

Learn to use 3D references in Microsoft Excel to link your worksheets together. Have summary worksheets automatically gather information from other Excel files and worksheets.

In Microsoft Excel, there are 2 ways your grid lines can dissapear. Learn how to display your Excel Grid lines with this tip.

I want to show more or fewer decimal places then what Excel shows by default. How do I determine the number of decimal places visible?

Have you ever tried to calculate a column of dollar amounts in Excel but noticed that it’s a few cents off? That is because Excel calculates all of the decimal places, even those that are hidden. The “displayed” total looks incorrect, because the actual calculation is being done by Excel on the underlying numbers, but the result is being rounded.

There is a quick key function that will allow you to toggle between displaying all formulas in a spreadsheet to displaying all values (the default normal view).  This is helpful if you want to print out a sheet so that all formulas rather than values are visible, or it you simply want to note where [...]