0

Subjects>Electronics>Computers

What formula makes Excel show the desired cells no matter where you scroll?

Anonymous

∙ 15y ago

Updated: 11/10/2022

There is no formula that does that. It is an option called freezing the pane. In Excel 2007 you can get to the option from the View tab on the menu ribbon in the Window section. Click on Freeze Panes and select the option you want.

Wiki User

∙ 15y ago

What else can I help you with?

Related Questions

What is it when Excel displays titles on screen no matter how far you scroll?

Freeze Pane

What is best feature of Microsoft Excel?

That you can scroll down forever.

What do you have to put in a cell to denote an equation in Excel?

In Excel an equation can be a formula. All formulas in Excel must start with the equals sign. That is what tells Excel it is a formula.

Where is the formula error button in Excel 2007?

There is no formula error button in Excel. However, there is an Error Checking button on the Formulas ribbon in the Formula Auditing section in Excel 2007.

What is the formula for PVIFA in Excel?

The PVIFA formula in excel refers to Present Value Interest Factor of Annuity. This is able to be calculated in an excel document.

What is replicating a formula in Excel?

Replicating means copying. So replicating a formula in Excel is copying a formula. This is a very common activity that is done in Excel. You create one formula and then use it in other places on the worksheet.

What are sheet tab scroll buttons in Microsoft Excel?

When you have a lot of Sheet tabs you can scroll through them or quickly go to the first or last one using the scroll buttons.

Can an Excel formula include more than one operation?

Yes, an Excel formula can include more than one operation. You can use a combination of arithmetic, comparison, and text functions within a single formula to perform multiple operations on data. Just make sure to use appropriate syntax and order of operations to get the desired result.

What will let you scroll up or down in Microsoft Excel?

You can scroll up and down using the scroll bars. You can also use the mouse or the Page Up and Page Down keys.

What is a rule in excel?

it is a formula

Formula for the calculation of gratuity?

Excel Arrears calculation Only Formula Download Excel Arrears calculation Only Formula Download but free download Excel Arrears calculation Only Formula Download but free download not option

Where Excel displays the formula that is in a cell IS WHAT?

The formula bar.

Trending Questions

How does a field mouse survive in its envirment? Where is the Android app store on the Android tablet? What utility shows the route that a packet takes to get to its destination? Is Windows 7 an MS-DOS operating system? How many miles are there between Danville KY and Richmond KY? How many ounces of fluid in a droplet of fluid? Return an opened ink cartridge to Argos because it is the wrong one? How do you get caps lock alert off? Is there any good montage making software for MW2? How long are items stored in the recycle bin once you delete them? What does cropping on a computer mean? What command allows you to troubleshoot DNS information from the command line? Can you add a thunderbolt port to an older MacBook Pro? What is halfway between Tulsa ok and clarksville tn? If I am buying a hard drive to back up music and other files which is best to get a portable or other Hard drive what memory would I need? Can you send bubble mailers through regular mail? What software should be on the computer of a person planning to enroll in an online course or webinar? What are Application of keyboard? What do newborn mice if they do not have a mom? What is process control system in Management information system?

Resources

Top Categories

Product

Company

Copyright ©2025 Answers.com. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Answers.