Question about Computers & Internet

1 Answer



I am chetan shah from ahmedabad, I want to know how to use scroll bar in excel format. I have select scroll bar tool, I also have set some property, I am little confuesed about usage of some property like link range.

Pl tell me in detail how to use scroll bar tool in xls file and how to link with datacell to scroll. my email address is

Posted by on


1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 7 Answers


You can make a link into cell that you want by right mouse click
Heperlink, link to , place in thins document , on the feild type the cell reference (A22 ,E56) ...etc , & link where is the cell that you want link to . & in which sheet it is .

i hope good luck

Posted on Feb 08, 2008


1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


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



Related Questions:

1 Answer

When you select some data in excel , you can come to know the count , sum , average , range ,min ,max .The same appears below scroll bar . It has suddently disappeared from my workbook .Hence very...

I don't have 2010, but I do have 2007. Now, provided that status bar is still there, right click on it and check the boxes you want to show on your status bar, such as sum, count, etc.

If you status bar is not there, make sure your are in NORMAL view and not Full Screen View. Hit the escape key a few times to get back to Normal. It would also be a good idea to click on the View ribbon menu to see what view you are in.

After that, I am at a loss to assist you.

Feb 24, 2011 | Microsoft Excel for PC


How can I create a Barcode for Free in Microsoft Excel?

<p>Placing barcode equipment or other things makes it easier to keep track of them. Instead of entering a long number, a quick scan with a bar code reader eliminates keystrokes. There are many different types of barcodes. The most famous is the Product Code or UPC Universal, in almost all items sold at retail in the United States. The UPC format only supports encryption of the songs. Other formats such as Code 39 (also known as Code 3 of 9) support letters and numbers. <br /> <p><br /> <p>1. Find a free TrueType font to the desired shape of the bar code. For example, the Code bar code format is 39 different TrueType font packages available free. Use an Internet search engine and type "Code 39 TrueType fonts" available in a free font found. Some specialized formats may not be available for free as a result of copyright or other restrictions. <br /> <p><br /> <p>2. On your Windows PC, select the Start menu and click Control Panel. Within the Control Panel, click Switch to Classic View "and appearance of the panel. Find the" Fonts "icon and double click to open it. On the File menu, select" Install New Font. "This opens a menu dialog asking you to change the font to install. Navigate to the folder that contains the downloaded TrueType font file. Select the font and click OK when prompted to install it. The source of new bar code will be available in Excel. <br /> <p><br /> <p>3. Start Excel and enter "98765" in cell A1. This value is converted to a bar. <br /> <p><br /> <p>4. In cell B1, type the following formula: "= CONCATENATE ("*", "*")" A1 and press enter. The result should be "* 98765 *". Code 39 format requires an asterisk at the beginning and end of the text to be encrypted. Bar code format other will have different rules. <br /> <p><br /> <p>5. Change the font in cell A1, choosing a different font from the drop-down menu at the top of the screen in Excel. Under the menu "Home", scroll down to "three of the nine free" source and select it. The text in the cell will now appear as a barcode. Increase font with a minimum of 28 points, so a scanner can pick up the scanning needs. <br />

on Jun 26, 2011 | Computers & Internet

1 Answer

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.

Oct 29, 2010 | IBM ThinkPad T30 2366 Notebook

1 Answer

Good morning, please i need to close the scroll bar in excel 2007

  1. On the Tools menu, click Options, and then click the View tab.
  2. Select or clear the Horizontal scroll bar check box and Vertical scroll bar check box.
Hope this will help you...Thank you...

Oct 28, 2009 | Microsoft Excel for PC

1 Answer

How to add hours:minut subtract from time time time diff. 01:00 02:00 1:00 16:00 18:00 2:00 ----------------- total hours

go to Microsoft excel click format in the tool bar then click cells then select time in the category scroll box

Jul 29, 2009 | Microsoft Office Standard 2007 Full...

1 Answer

I want the all excel formulas

You will never find a fully comprehensive list anywhere because there are literally hundreds in the basic Excel application and thousands that can be added in as you go via macros. More are being added every time a new version of Office comes out.

But, the easiest way however to get a basic list of functions if your not printing is to hit the function button and simply scroll down the list. The syntax (an example of the method by which you should be formatting the formula) and a definition will list in the bottom of the dialog as you select each function.

That said, you are better solving individual problems as you learn Excel then trying to memorize all the functions themselves. Many, such as mathematical operations are common sense anyway.

Jun 19, 2009 | Microsoft Computers & Internet

1 Answer

Mouse scrolling probalem

I believe you and I had the same problem. I just figured it out, actually by accident!

In MS-Excel, on the top tool bar (File, Edit, View etc etc.) there should be a tab next to the Help tab, called Window.
Click Window, then look through the drop down until you see UnFreeze Panes (Note that the problem will be fixed if you click UnFreeze Panes, if indeed our problem was the same.)
If you do not see that option "UnFreeze Panes" and instead see Freeze Panes... then I haven't the foggiest how to help. -___-;; 

Good Luck!

Feb 25, 2009 | IBM Lenovo Mouse 76H6618

1 Answer

Count , sum ect below scroll bar disappeared

Excel 2007 - This is called the status bar, right click on it if it is blank and put click to put a click next to the options you require.
Previous Versions - Click View --> Status Bar

Jan 17, 2009 | Microsoft Excel for PC

1 Answer

Scroll lock in excel 2007

When SCROLL LOCK is on, "SCRL" appears on the Excel status bar. If you press the arrow keys when SCROLL LOCK is on, you scroll one row up or one row down. Or, you scroll one column to the left or one column to the right. To use the arrow keys to move between cells, you must turn SCROLL LOCK off.

Sep 18, 2008 | Microsoft Office Professional 2007 Full...

2 Answers


Yes of course, if you have a little background of visual basic programming that's possible you can enhance your requirements.

Please see link

Nov 29, 2007 | Microsoft Excel for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

329 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers


Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

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

Answer questions

Manuals & User Guides