Top Answer
User Avatar
Wiki User
Answered 2008-09-07 19:30:29

IT GIVES YOU $ BUT WHAT DOES IT DO IN EXCEL? The dollar signs $ can make the cell reference absolute =$A$1 is absolute reference, if you dragged the formula it will always be A1 =A1 is relative reference if you drag the formula the reference will change accordingly

User Avatar

Your Answer

Still Have Questions?

Related Questions

How do you square on excel?

Use "^2". ^ is Shift-6 on my keyboard.

What does shift plus f5 do?

In Excel it will open the Find dialog box.

What is the function of Shift plus key 6 in Excel?

Shift 6 gives you the ^ symbol. Shift + F6 moves to a previous pane if you have several windows open and you are moving through them.

Which direction do the contents shift when you add a new column in Excel?

to the right I had to take a class about excel and all of it shifted to the right when i added a new column

What combination in excel gives you the current time fast?

Ctrl - Shift - and the colon key.

Which tool use to insert a new sheet in a workbook in excel?

press shift and F11

How do you insert a new spreadsheet in the Microsoft Excel by keyboard?

Shift+F11 inserts a new worksheet.

Which key do you hold if you want to select a large range of contiguous cells in excel?

shift key

What are 2 ways to select a row in Excel?

Click on a row header or press Shift - spacebar.

How do you insert a new cell in excel?

Right-click then select ''Insert" and choose shift cells to right or shift cells down, depending on what way you want to do it.

What is the shortcut key used to select files whose names are adjacent in Excel?

To select files whose names are adjacent in Excel, use the Shift key. You can hold the Shift key and click on the first file and the last file, and that will select all the files in between. Using the down arrow while holding Shift can do the same.

Delete column vba excel?

to delete column B Columns("B:B").Delete Shift:=xlToLeft

How do you convert pdf files to excel?

You should select and copy (shift + V) the table you want to edit. Next, right click within the selected table and click save as. Select the correct format - excel spreadsheet and you can edit it in excel.

How do you change small letter to capital letter in Excel and Word?

In Word, you cans use Shift - F3 to change between different cases. See the related question below for what to do in Excel.

What are the part and environment of excel?


What is the sum of 7 and 4 in Excel spreadsheet?

The sum of 7 and 4 is 11, whether in an Excel spreadsheet or anywhere else. In Excel the formula would be =SUM(4,7) or =4+7 or =(B12+B13) if the values 7 and 4 were in cells B12 and B13.

How do you convert a word from uppercase to lowercase in Microsoft Excel?

Shift or caps lock or =lower("WORD") or =lower(cell)

Which keyboard key using for filter removing in Microsoft Excel?

Ctrl - Shift - L can turn filters on and off.

How to Select a cell in Excel without deselecting others?

If its like anything ive used, Either hold down Shift and click the ones you want selected, or Ctrl instead of shift.

How many kms does a 96 excel do?


Can you select nonadjacent ranges using the shift key in excel?

No. Use the Ctrl key to select non-adjacent ranges.

How do you find percentage error in Microsoft excel?

=(A1/B1)*100 then press Ctrl + Shift + % and the cell will be displayed as a percent

How many time does the Excel appear in the Bible?

Excel appears 4 times in the NIV Version of the Bible.

1986 Honda Accord 4 speed auto will not shift?

my Honda accord has auto 4 speed that will not shift

How do you write a formula for 4 plus 9 in excel?


Still have questions?