Set text box to No Outline Use the Format Shape task pane Copy the text and then delete a text box. Let’s check these options one by one. The steps for these options are the same for Word and Excel.

How to use VBA’s InputBox function to select a range on the fly in Excel Your email has been sent Often, you’ll want Excel users to specify a range that the app then uses in an automated way.

Microsoft Excel offers Visual Basic for Application (VBA) as a scripting tool to let you add additional functionality to your Excel spreadsheets. You can use VBA to prompt the user to enter a filename ...

Text in an Excel cell may span several lines. For example, cells in a sheet listing employees may contain extended comments on each worker's performance. Excel controls the number of lines in such a ...

Pro tip: Populate an Excel UserForm combo box without VBA Your email has been sent Susan Harkins shows you two easy ways to populate an Excel UserForm, and neither requires a single bit of VBA code.

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 ...