Naming a range of cells in Excel can come in very handy, and it´s quite simple. At the most basic level, naming a range in Excel is no harder than selecting the range of cells (this can be a single cell, cell range, or nonadjacent cell selection), clicking the Name Box (on the same row as the Formula bar that contains the current cell address), typing a unique descriptive name for the ra..mais...

If you find that you need to enter a whole slew of numbers that use the same number of decimal places, you can turn on Excel's Fixed Decimal setting and have the program enter the decimals for you. This feature really comes in handy when you have to enter hundreds of financial figures that all use two decimal places...mais...

Algumas vezes os dados que você coloca num gráfico, no Microsoft Excel, podem ter um ou mais em falta. O Excel oferece diversas opções para tratar os dados que porventura estejam faltando para plotar. Basta seguir os passos abaixo: 1...mais...

A chart legend in Excel lists each pattern or symbol used as a data marker in a chart and follows the pattern or symbol with the chart data series name. Generally, it's a good idea to use a legend in a chart where you're not using category labels...mais...

In Excel, perhaps the quickest way to copy the formats from one cell to another cell or range is to use the Format Painter button (the button with the paintbrush image) on the Standard toolbar. Start by selecting the cell or range that has the formatting attributes you want to copy...mais...

One very useful feature in Excel is its multilevel undo. This means that you can reverse your recent actions, one step at a time. For example, if you discover that you accidentally deleted a range of data several minutes ago, you can use the undo feature to "backtrack" through your actions until the deleted range reappears...mais...