IBM ThinkPad T42 Notebook Logo
Posted on Jul 20, 2009
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

Not able to scroll on my excel sheet

My scroll key is locked on my IBM T43. How do i unlock it?i am not able to copy or apply formulaes on my Excel sheet. Pl Help

Answer This Question

2 Answers

Anonymous

Level 2:

An expert who has achieved level 2 by getting 100 points
MVP:

An expert that got 5 achievements.
Governor:

An expert whose answer got voted for 20 times.
Hot-Shot:

An expert who has answered 20 questions.

  • Expert 116 Answers
  • Posted on Jul 20, 2009
Anonymous
Expert
Level 2:

An expert who has achieved level 2 by getting 100 points
MVP:

An expert that got 5 achievements.
Governor:

An expert whose answer got voted for 20 times.
Hot-Shot:

An expert who has answered 20 questions.

Joined: Jul 19, 2009
Answers
116
Questions
0
Helped
47061
Points
343

It's only in Excel you can't scroll? Can you scroll from side to side? If you have Excel 2003, try to press the "window" tab on the top and if the freeze pane is checked, uncheck it. Or if it says unfreeze pane, press that one. Hope this helps :)

Tafi Nami

Tafi Nami

Level 2:

An expert who has achieved level 2 by getting 100 points
All-Star:

An expert that got 10 achievements.
MVP:

An expert that got 5 achievements.
Sergeant:

An expert that has over 500 points.

  • Expert 297 Answers
  • Posted on May 02, 2018
Tafi Nami
Expert
Level 2:

An expert who has achieved level 2 by getting 100 points
All-Star:

An expert that got 10 achievements.
MVP:

An expert that got 5 achievements.
Sergeant:

An expert that has over 500 points.

Joined: Sep 12, 2017
Answers
297
Questions
0
Helped
183260
Points
886

Whether knowing how to use the dollar sign in Microsoft Excel is a need-to-know or a nice-to-know for you, the sign is something that will enable you to present your corporate accounting data more accurately. The application employs the sign as a programming convention in formulas. Placing a dollar sign before the column and the row in a formula tells Excel that you don't want it to adjust the cell reference when you copy the formula. This is called an absolute cell reference. If you don't include the dollar signs, then Excel adjusts the cell reference by following the same location-based pattern as your original formula, rather than the actual formula. Most people are familiar with the conventional use of the dollar sign in Excel, which is to express monetary values.

Ad

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1helpful
1answer

Do you have a formula in Microsoft Excel that a value can convert to a word...(Ex. 15,000 then it will convert to in words fifteen Thousand..)thanks. need immediate reply.
Hi enelrah_mel0,

You can create a function called SpellNumber using the Visual Basic Editor in the Microsoft Excel to spell the number.

  1. Please Open Microsoft Excel. Then press Alt + F11 to open the Visual Basic Editor.
  2. Then, click "Insert" option above the Visual Basic Editor window and select "Module".
  3. Then, in the Book1 Module1 (Code) window, paste the below code there. (pasted in the next post separately for your convenience)
  4. Then, press Alt+Q to close the Visual Basic Editor window.
  5. After that, please type the formula " =SpellNumber( * )" in the Excel Sheet and press the Enter Key.
  6. Then, save the Excel Sheet.
eg: =SpellNumber(A1)

Where A1 is the first cell in the excel sheet.


Good Luck!

Please post back the result and let me know if you require further assistance.

Thanks for using Fixya.
Read full answer
Oct 29, 2010 • IBM ThinkPad T30 2366 Notebook
1helpful
1answer

Copy data that contains formula and paste it to a new sheet minus the formula: is this possible?
Sure is - depending on your version of Excel.

1) right click on the cell with the formula
2) go to where you want to paste the value - minue the formula
3) right click and select paste special
4) click values (as seen in image below)

and that's it done.

If this helped you, then please help me and vote kindly.
Read full answer
Oct 09, 2009 • Microsoft Excel for PC
0helpful
1answer

Want to copy formula into multiple excel sheets
why not? however, you can also insert an apostrophe (') at the start of the equation before copying the entire formula so that the formula will be treated as a text thus preserving all cell references. dont forget to remove the apostrophes after you have pasted them though for the formulas to work again.
Read full answer
Jul 29, 2009 • Computers & Internet
2helpful
2answers

Excel 2007
  1. Select all cells (either press Ctrl+A or click on the small upper left square on the edge of the worksheet)
  2. In the menu bar, go to Format - Cells
  3. In the popup menu that opens, click on the Protection tab (it should be the last one on the menu)
  4. Deselect the small box tagged Locked
  5. Click on OK. Now all your cells can be overwritten, regardless the protection status of the worksheet.
  6. Select only the cells containing formulas that you want to hide (If you need to perform multiple selection, you can press and hold down the Ctrl key, while clicking on each cell you want to select)
  7. In the menu bar, go to Format - Cells
  8. In the popup menu that opens, click on the Protection tab
  9. Tick the small box tagged Hidden and the Locked box as well. If you don’t tick the Locked box, other users of your worksheet would be able to overwrite the formula cells, without even knowing that they contain formulas (as they become invisible following this operation).
  10. Click on OK
  11. In the menu bar, go to Tools - Protection - Protect Sheet
  12. If you want, you can input a password for unlocking the worksheet. This will prevent others from unlocking it. If you don’t want to do that, leave the password field blank and press OK.
  13. Now click on one of your cells containing formulas and look at the formula bar. It should be empty, although the formula is still there. The cell would remain locked, but it would be automatically updated when changing the content of its precedents relating to the contained formula.
Read full answer
Jun 25, 2009 • Computers & Internet
0helpful
1answer

EXCEL SHEET TO MAKE LATTER
>this may help you
http://office.microsoft.com/en-us/excel/HP052001271033.aspx
Read full answer
Apr 14, 2009 • Microsoft Excel for PC
0helpful
1answer

Unprotect an Excel sheet
Print or convert it to pdf then you may copy/paste from the pdf to a new unprotected sheet.

Doesnt work for formula.
Read full answer
Feb 18, 2009 • Computers & Internet
4helpful
5answers

How to use vlookup in openoffice using different sheets
=VLOOKUP(A2;Sheet1.$A$3:D27;2;0)

The cell I created this formula in was Sheet 3 Cell C9 - to show the different sheets
A2 is the cell I want to look up
Sheet1.A3:D27 is the range of cells that contains the data I want to return, The first column relates directly to cell C9 is Sheet 3. I locked the first cell in my range as I wanted to apply the same formula across other cells hence the $
2 is the number of the column that has the data I want to return, I had a choice in this formula of 4 columns
0 is the value to complete the formula
Read full answer
Feb 11, 2009 • Microsoft Excel for PC
0helpful
2answers

Excel formulas
type in "=" and then go to the cell in the 2nd sheet and click on the cell that contains the value you want carried to sheet 1. Then drag copy the forumula in sheet 1 to all the cells you want it to relate to. Now, if you place a value in e.g. A1 of sheet 2, then that same value will appear in A1 of sheet 1.
Good luck.
Read full answer
Sep 13, 2008 • Microsoft Computers & Internet
0helpful
5answers

How many formulas we can use at a time in Excel
That depends on which version of Excel you are using.
Excel 2003 supports up to 65,335 formulas
Excel 2007 has no limit.
you can communicate between the worksheets which are contained by one workbook (one excel-file).
Communicating between files cannot be done with formula's.
Read full answer
Apr 04, 2008 • Microsoft Excel for PC
Not finding what you are looking for?

View Most Popular

ThinkPad T42 Notebook

  • Computers & Internet

Related Question

Do you have a formula in Microsoft Excel that a value can convert to a word...(Ex. 15,000 then it will convert to in words fifteen Thousand..)thanks. need immediate reply.

  • IBM ThinkPad T30 2366 Notebook

Related Topics

3,972 views

Ask a Question

Usually answered in minutes!

Popular Questions

My asus laptop wireless switch does not work

IBM ThinkPad T40 2373 Notebook

Ibm thinkpad t42 switch for wireless network

IBM ThinkPad T42 Notebook

DRIVER REQUIRED FOR rELIANCE DATA CARD MODEL MC315+

IBM ThinkPad R40 2722 Notebook

How do you repair a keyboard button that has popped off

IBM ThinkPad T42 Notebook

Dell latitude d620 bios password removal

IBM ThinkPad T43 Notebook

Check Out the Mobile Browsers Report
Check Out the Mobile Browsers Report

View all Fixya Reports

Top IBM Computers & Internet Experts

Brad Brown

Level 3 Expert

19187 Answers

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

ExpressFiX
ExpressFiX

Level 2 Expert

691 Answers

Are you an IBM Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...