application development excel - excel

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Excel Training and help » application development excel - Excel

application development excel - Excel

resolvedResolved · Low Priority · Version Standard

Gary has attended:
Excel Introduction course
Excel Intermediate course

Excel

How do I remove the auto fill smart tag from the workbook

RE: Excel

Hi Gary

Thanks for your question.

To stop smart tags appearing, go to Tools - Options - Edit then remove the tick from the Show Paste Options checkbox and click OK.

Amanda


 

Excel tip:

Add Text to Displayed Numbers in Excel 2010

To add text to a number in a cell, you need to go to the Home tab on the Ribbon, and click on the Cells group. Select Format Cells from the drop down menu then Custom from the Category list. In the Type box select General. After the word General, enter a space, then opening quotation marks, then the word you want to type and then closing quotation marks. Click on OK and you have your text!

View all Excel hints and tips


Server loaded in 0.12 secs.