answersLogoWhite

0

You need to type Qtr2 for that to happen.

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

When the active cell contains a formula dragging the fill handle causes excel to?

Copy the forumula to the cells where you drag the fill handle.


When the active cell contains the formula dragging the fill handle causes Excel to?

Copy the forumula to the cells where you drag the fill handle.


Is fill handle used to copy contents in Excel?

A fill handle can copy anything and in different ways. It can copy contents and it can copy formulas and it can create fill series.


Can you drag the fill handle to the left or up Excel to decrement the series?

Yes, a series can be decremented by dragging up or left.


In addition to creating a series of values dragging the fill handle instructs Excel to the formate of a cell to range?

When you use the fill handle it will copy what is in the cell including the formatting.


In Microsoft Excel sometimes I type a lot and it replaces my text with a bunch of number signs how do I get rid of that?

If the contents of a cell are too big to display within that cell Excel will use empty cells to the right to display it in full. However, if adjacent cells aren't empty Excel will display ##### to indicate that the column is not wide enough to display the contents. Make the column wider by dragging the right hand border of the column header to the right. If you double click instead of dragging the column will re-size itself to accommodate the longest entry.


A small black square in the lower corner of an active cell called?

The small black square in the lower corner of an active cell in Excel is known as the Fill Handle. You can use it to quickly fill data into adjacent cells by dragging it.


How do you selectcell in excel?

Clicking a cell will select it. You can select more by dragging out over them.


What shows a cells contents in excel?

The formula bar.


How do you delete fill handle in Excel?

The fill handle can be turned off in the Excel options, though it is more useful to have it on.


What will Excel do if you drag the fill handle to the left or up?

It can have various affects, depending on how you to do it. Excel will decrement the series if you also press the Ctrl key. It can also create a normal incrementing series. If there are values already in the cells, it will erase them.


How will the Excel contents appear in Word?

If you copy data from Excel and paste it into Word, then it will appear as a table in Word.