Posts
MSExcel : Broaden an arrangement with AUTOFILL
AutoFill gives you an approach to guarantee exact information passage when a specific information arrangement has an inherent request: days of the week, months of the year, numeric augmentations of two, etc. To utilize AutoFill, start by composing at least one values from which you will produce different values. Select the cell or cells you need to broaden. Choosing two or more cells decides the progression size, or augmentation, by which you need to bounce in every cell. With the cells chosen, click the Fill handle in the lower-right corner what's more, drag. When you discharge the mouse button, Excel fills the cells with values. In the wake of filling the cells, Excel gives a menu button. Snap the button to open a menu that empowers you to change the fill. You can duplicate the initial value; fill the arrangement without rushing too much; or expand it by weekdays, months, or years, contingent upon the kind of fill you make.
1 Click in the cell in which you
need to insert a symbol.
2 Click the Insert tab.
3 Click Symbol in the Content group
l The Symbol dialog box shows up.
4 Click here and after that select a font.
5 Click the Symbol you need.
6 Click Insert.
l The character shows up in the cell.
7 Click Close.
The Symbol dialog box closes
Include A SPECIAL CHARACTER
1 Click in the cell in which
you need to insert a
special character.
2 Click the Insert tab.
3 Click Symbol in the Content
group.
l The Symbol dialog box shows up.
4 Click the Special Characters tab.
5 Find the character you need and click it.
6 Click Insert.
l The character shows up in the cell.
7 Click Close.
The Symbol dialog box closes
Did You Know?
In Excel, entries are numbers, dates, times, letters,
or special characters. You can only use numbers,
dates, and times in numeric calculations. Excel
treats letters and special characters as blanks or
zeroes in calculations. To have a currency symbol
appear with a value, as in $400, and use the cell
value in a calculation, you must apply a currency,
accounting, or custom format.
Did You Know?
Excel fonts are based on Unicode, a set of 40,000
characters enabling the display of characters from
approximately 80 languages, including right-to-left
alphabets such as Hebrew. To use a language other
than English, attach an appropriate keyboard and
use the Control Panel to set the Regional and
Language options.
