Computers & Internet Logo

Related Topics:

A
Anonymous Posted on Sep 30, 2014

Microsoft excel 7 disable scrool lock fuction

1 Answer

ali_zulfikar

Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Vice President:

An expert whose answer got voted for 100 times.

Governor:

An expert whose answer got voted for 20 times.

  • Expert 156 Answers
  • Posted on Sep 16, 2017
ali_zulfikar
Expert
Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Vice President:

An expert whose answer got voted for 100 times.

Governor:

An expert whose answer got voted for 20 times.

Joined: Nov 04, 2008
Answers
156
Questions
0
Helped
50296
Points
377

First locate SCROLL LOCK key in keyboard (Normally it in function keys in laptop, and separate on desktop keyboard).
Now press:-
1. SCROLL LOCK Key
or
2. Fn + SCROLL Lock key (if it is colored as the color of Fn key in laptop)

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1helpful
2answers

What did I do, excel is frozen, can not scroll up?

It might be as simple as Frozen Panes.
Go Window / Unfreeze Panes and see whether that fixes your problem for you.
0helpful
1answer

Cell freeze 3 rows together at a time.

Freeze a Row in Microsoft Excel
Microsoft Excel 2010 can freeze, or lock, a top row as you scroll down the worksheet.
For example, you may need to keep the top row of column titles visible at all times.
The "View" tab on the command ribbon contains the "Freeze Panes" button in the "Window" group.
A single row or a range of rows can lock through the "Freeze Top Row" or "Freeze Panes" options.

Open the Excel worksheet.
Click the top row heading.
The row heading displays a number just left of the first column of cells. The selected row appears shaded.


Click the "View" tab on the command ribbon.
Click the "Freeze Panes" button in the "Window" group.
A list of options appears.

Click the "Freeze Top Row" option.
A black horizontal line appears on the worksheet.
This line indicates the locked row that stays on the screen as you scroll down the worksheet.

http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP010342542.aspx?CTT=1
Freeze or lock rows and columns
also
Use Freeze Panes in Excel
Scrolling down to look at a number and then scrolling up to make sure the number you looked at is under the header you expected is not an efficient way to view a spreadsheet.
The Freeze Panes feature of Excel allows you to freeze the labels of your data in place while you review the data.
Follow the instructions in Section 1 to freeze the top row or the left column.
Freeze multiple rows, multiple columns, or rows and columns, by following the instructions in Section 2.Freeze the Top Row or Left Column
1
Open the Excel spreadsheet.
2
Navigate to the "View" tab on the top menu.


3 Click on "View," then click on "Freeze Panes." A drop-down menu opens.

4

Select the "Freeze Top Row" option to freeze the top row.

5

Select the "Freeze Left Column" or "Freeze First Column" option to freeze the left column.

6

Freeze the top row by using the keyboard and sequentially pressing the keys "ALT, W, F, R." Ignore Steps 3 through 7 if using this choice.

7

Freeze the left column using the keyboard by sequentially pressing the keys "ALT, W, F, C." Ignore Steps 3 through 7 if using this choice.

8

Unfreeze panes by repeating Steps 3 through 5 and selecting "Unfreeze Panes" or sequentially press the keys "ALT, W, F, F."

Freeze Rows and Columns, Multiple Rows, Multiple Columns, or Multiple Rows and Columns
9

Open the Excel spreadsheet.

10

Freeze column(s) and row(s) at the same time by selecting the cell to the right of and below the location you want to freeze.

11

Freeze multiple rows only by selecting the cell in the left (first) column below the rows you want to freeze.

12

Freeze multiple columns only by selecting the cell in the top row to the right of the columns you want to freeze.

13

Navigate to the "View" tab on the top menu.

14

Click on "View," then click on "Freeze Panes." A drop-down menu opens.

15

Select the "Freeze Panes" option. You have now frozen the columns or rows, or columns and rows you designated.

16

Freeze panes using the keyboard by sequentially pressing the keys, "ALT, W, F, F." Ignore Steps 5 through 8 if using this choice.

17

Unfreeze panes by repeating Steps 5 through 7 and selecting "Unfreeze Panes" or sequentially press the keys, "ALT, W, F, F."



http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP001217048.aspx
Freeze or lock rows and columns
http://office.microsoft.com/en-us/excel-help/demo-hide-or-unhide-rows-and-columns-HA010241040.aspx
Hide or show rows and columns
1helpful
1answer

I am using microsoft excel 2007, the code is not running, the macro was disabled.. How to enable the macro...?

From the excel help file

  1. Click the Microsoft Office Button o12filemenubutton_za10077102.gif, and then click Excel Options.
  2. Click Trust Center, click Trust Center Settings, and then click Macro Settings.
  3. Click the options that you want:
    • Disable all macros without notification Click this option if you don't trust macros. All macros in documents and security alerts about macros are disabled. If there are documents with unsigned macros that you do trust, you can put those documents into a trusted location. Documents in trusted locations are allowed to run without being checked by the Trust Center security system.
    • Disable all macros with notification This is the default setting. Click this option if you want macros to be disabled, but you want to get security alerts if there are macros present. This way, you can choose when to enable those macros on a case by case basis.
    • Disable all macros except digitally signed macros This setting is the same as the Disable all macros with notification option, except that if the macro is digitally signed by a trusted publisher, the macro can run if you have already trusted the publisher. If you have not trusted the publisher, you are notified. That way, you can choose to enable those signed macros or trust the publisher. All unsigned macros are disabled without notification.
    • Enable all macros (not recommended, potentially dangerous code can run) Click this option to allow all macros to run. This setting makes your computer vulnerable to potentially malicious code and is not recommended.
    • Trust access to the VBA project object model This setting is for developers and is used to deliberately lock out or allow programmatic access to the VBA object model from any Automation client. In other words, it provides a security option for code that is written to automate an Office program and programmatically manipulate the Microsoft Visual Basic for Applications (VBA) environment and object model. This is a per user and per application setting, and denies access by default. This security option makes it more difficult for unauthorized programs to build "self-replicating" code that can harm end-user systems. For any Automation client to be able to access the VBA object model programmatically, the user running the code must explicitly grant access. To turn on access, select the check box.
0helpful
1answer

How do i turn on a macro disabled file in excel

http://office.microsoft.com/en-us/excel-help/enable-or-disable-macros-in-office-documents-HA010031071.aspx?CTT=5&origin=HP010096919#BM12
  1. Click the Microsoft Office Button za010077102.gif, and then click Access Options.
  2. Click Trust Center, click Trust Center Settings, and then click Macro Settings.
  3. Enable all macros (not recommended, potentially dangerous code can run) Click this option to allow all macros to run. This setting makes your computer vulnerable to potentially malicious code and is not recommended.
0helpful
1answer

AutoRecover has been disabled for this session of Excel

Hi,

Please install service pack 1 for office from belo microsoft site.
Microsoft Update (recommended)

Microsoft Update (recommended)
To download the service pack from Microsoft Update, visit the following Microsoft Web site:

http://update.microsoft.com/microsoftupdate (http://update.microsoft.com/microsoftupdate)
Office Update

To download the service pack from Office Update, visit the following Microsoft Web site:
http://office.microsoft.com/en-us/downloads/FX101321101033.aspx

(http://office.microsoft.com/en-us/downloads/FX101321101033.aspx)
Note If you experience issues installing the latest Office 2003 service pack from Office Update, click the following article number to view the article in the Microsoft Knowledge Base.

304498 (http://support.microsoft.com/kb/304498/ ) How to troubleshoot failures updating your Office installation from the Office Update Web site
Hot fix information:-

If problem still there then please try Hotfix provided by Microsoft.
A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem.

http://support.microsoft.com/contactus/?ws=support
1helpful
1answer

My scrollbar won't stop scrolling down on my Toshiba L305d laptop. I tried using a mouse instead of the scrollpad but it still keeps goin down all the time.

You need to go into DEVICE manager and uninstall the Scrool pad or better yet have it fixed. the issue here is the scrool pad is worn out and now is too sensitive the best fix is have it replaced untl then Device manage, uninstall or disable.

diagnosis bad touch pad
prognosis Replace or disable.

Do not shoot the messenger and leave some postive feedback and ratings for your free answer today.

Btw, I’m available to help over the phone in case u need at https://www.6ya.com/expert/edwy_1a56970cf1ea4620

0helpful
2answers
0helpful
1answer

Excel

The Data Analysis Add-in has a Moving Average fuction and wizard. Moving Average
Not finding what you are looking for?

215 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

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

Answer questions

Manuals & User Guides

Loading...