USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
<Ctrl+insert>
|
|
|
<Shift+insert>
|
|
|
<Ctrl+Enter>
|
|
|
<Alt+Enter>
|
Detailed explanation-1: -Use the CTRL + ENTER shortcut – this shortcut applies the same contents or formula in all the cells you initially select. Here’s a simple example: Let’s suppose you have a simple table with revenue and cost forecasts as shown in the picture below, and you want to quickly fill in the formulas for Gross Profit in row 6.
Detailed explanation-2: -Ctrl+Enter in Microsoft Excel In Microsoft Excel, pressing Ctrl + Enter fills the selected cells with the current entry.
Detailed explanation-3: -Click the Select All button. Press CTRL+A. Note If the worksheet contains data, and the active cell is above or to the right of the data, pressing CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet.
Detailed explanation-4: -Ctrl+Alt+Enter This shortcut will enter the data into the cell, and then move down one cell.
Detailed explanation-5: -Smart filling Ctrl+E can help us merge data scattered in different columns into the same column. Take this worksheet as an example. We will merge the characters from column A to D into column E. After inputting, press the shortcut key Ctrl+E to merge the scattered data of each columnquickly.