Impress your coworkers with these nifty tricks.

If Excel is not highlighting cells in the formula, read this post to know how to fix the issue. The default behavior of Excel is to highlight the cells that are part of a formula when a user ...

Select the cell(s) where you want the text to appear vertically. Go to the Home tab in the top ribbon. In the Alignment group, click the Orientation drop-down arrow. Choose Vertical Text from the list ...

Looking for a way to tidy up your spreadsheet and reduce its size without having to use dynamic range formulas like OFFSET, INDEX, or TOCOL? TRIMRANGE detects the cells your data occupies and ...