How to apply a border using ribbon presets in Excel
In this video we show you how to apply borders using presets on the ribbon. The trick is to set the line weight and line color first.
Dave Bruns
TODAY Function
The TODAY function returns the current date, and will continually update each time the worksheet is updated. Use F9 to force the worksheet to recalculate and update the value.
The value returned by the TODAY function is a standard Excel date. To display...Read more
NOW Function
NOW takes no parameters but requires empty parentheses. The value returned by NOW will continually update each time the worksheet is updated, for example, each time a value is entered or changed. Use F9 to force the worksheet to recalculate and update the value.
The value returned by the...Read more
How to format individual characters in Excel
In this video we show you how to apply local formatting to only part of the text inside a cell; to make a single word bold, for example.
How to insert symbols and special characters in Excel
In this video we show you how to insert special characters like symbols and images.
How to apply subscript, superscript, and strikethrough formatting in Excel
In this video we show you how to apply subscript and superscript formatting to specific characters in text you have entered.
How to change the font color in Excel
In this video we show you how to change font color and demonstrate how Excel's live preview can help you select a color...
How to apply bold, italic, underlining styles in Excel
In this video we show you how to apply bold, italic, and underlining styles to text.
How to format font and font size in Excel
In this video we show you how to apply fonts and control font size.
How to align text across cells with merge in Excel
In this video we show you how to use merge to align text across cells. Merge is easy and works well, but be sure to check out Center Across Selection for an option that doesn't interfere with Excel's grid...