Wrap text in Excel if you want to display long text on multiple lines in a single cell. To wrap text automatically, do as follow: 1. For example, take a look at the long text string in cell A1 below. Cell B1 is empty. 2. On the Home tab, in the Alignment group, click Wrap
This article describes how to automate the generation of invoices in Excel. This is what the spreadsheet looks like. If you select a Client nr from the drop-down list in cell E6, Excel automatically fills in the client information. If you select a Product nr from one of the drop-down lists in cells A13 through
This article introduces how to specify the length of transitions in PPT. Steps: 1.open the document and find transition 2.you can set the first slide time 3.you set the second slide time 4.you can set the third slide and use the same way 5.then you can preview the slide 6.you can apply to all to
Learn how to show fewer decimal places in Excel without changing the number itself. You can also round a number. Steps: 1. Enter the value 2.175 into cell A1. 2. On the Home tab, in the Number group, click the Decrease Decimal button twice. 3. Result Note: if you look at the formula bar, you
An external reference in Excel is a reference to a cell or range of cells in another workbook. To create an external reference, execute the following steps. 1. Open all workbooks. 2. In the Company workbook, select cell B2 and type the equal sign = 3. On the View tab, in the Window group, click
It’s easy to create all sorts of sequences in Excel. For example, the Fibonacci sequence. Step: 1. The first two numbers in the Fibonacci sequence are 0 and 1. 2. Each subsequent number can be found by adding up the two previous numbers. 3. Click on the lower right corner of cell A3 and drag
To sort on multiple columns, execute the following steps. 1. On the Data tab, in the Sort & Filter group, click Sort. The Sort dialog box appears. 2. Select Last Name from the ‘Sort by’ drop-down list. 3. Click on Add Level. 4. Select Sales from the ‘Then by’ drop-down list. 5. Click OK. Result.
To concatenate (join) strings in Excel, use the & operator, the CONCATENATE function, the CONCAT function or the TEXTJOIN function. Today we will talk about Concatenate function in Excel. Steps: 1. The CONCATENATE function below concatenates the string in cell A2 and the string in cell B2. 2. The CONCATENATE function below concatenates the string
This article introduces how to set vertical text box in PPT. Steps: 1.create a document 2.open the document 3.find home 4.fin text box 5.choose vertical text box 6.then you can see the vertical text box
This article introduces how to replace background picture in PPT. Steps: 1.open the document and choose format background 2.then we can see the information 3.we can choose pattern fill 4.we can choose the picture from computer 5.then choose the picture 6.you can apply all