#How to turn off scroll lock excel 2010 windows

From the View tab, Windows Group, click the Freeze Panes drop down and select Freeze Panes. Select the row that is immediately beneath the last row you want frozen. Excel inserts a thin line to show you where the frozen pane begins.Select either Freeze Top Row or Freeze First Column.From the View tab, Windows Group, click the Freeze Panes drop down arrow.Select the cell in the upper-left corner of the range you want to remain scrollable….To freeze the top row or first column: How do I fix columns when scrolling in Excel? You can scroll across the worksheet while continuing to view the frozen column on the left. The column will be frozen in place, as indicated by the gray line. To freeze columns: On the View tab, select the Freeze Panes command, then choose Freeze Panes from the drop-down menu. How do I freeze a cell until I scroll past a certain point in my worksheet? Now select only the cells or columns, rows that you want to protect. Go to the Protection tab and uncheck Locked option and click Ok. Press the Keyboard Shortcut Ctrl + A to select all the cells of the sheet. And now, follow the already familiar path, i.e View tab > Freeze panes > and again Freeze panes.For example, if you want to freeze the first 3 columns (A – C), select the entire column D or cell D1. Select the column to the right of the last column you want to freeze.How do you lock a table in Excel when scrolling? Select View > Freeze Panes > Freeze Panes.Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.How do I lock multiple cells in Excel when scrolling?

#How to turn off scroll lock excel 2010 password

How do you password protect columns in Excel?.

How do I lock certain cells in Excel 2016?.

How do I freeze only 4 columns in Excel?.

How do I fix columns when scrolling in Excel?.

How do I freeze a cell until I scroll past a certain point in my worksheet?.

How do I lock certain columns in Excel?.

How do I freeze the first 3 columns in Excel?.

Why is Excel not freezing the panes that I select?.

How do you lock a table in Excel when scrolling?.

How do I lock multiple cells in Excel when scrolling?.

#How to turn off scroll lock excel 2010 update

In a world of constantly evolving technology, where many feel the need to update their skill-sets to fit new fads and trends, we can all learn a lot from the Scroll Lock key, finding new and exciting ways to apply our talents. The Scroll Lock key is a vestige of an older time that has remained a standard since the dawn of the keyboard, and managed to carve out relevance, staying useful long after its original purpose expired. For example, if I wanted to create a New Incognito Window in Google Chrome, I could hit CTRL+SHFT+N or I could remap the whole shortcut to the Scroll Lock and have it be done in one press. What this means is that people will remap the key to perform other functions and macros. This allows for more advanced users to have both hands on the keyboard at all times, decreasing the time it takes to use the spreadsheet.Īnother popular use for the Scroll Lock key is as a “Free” key. However, when the Scroll Lock key is toggled, the arrow keys will now scroll the entire spreadsheet either vertically or horizontally. In Excel, the arrow keys navigate cells by default. There are two very popular uses for the Scroll Lock key today: Toggling the Scroll Lock key would disable scrolling with the arrow keys, and allow you to move your typing cursor through the page.īut mice are widespread now, so why is the key still there? Back then, the arrow keys were used to move your typing cursor, or to scroll the page. Today when when typing documents, we can use our mouse to point and click to move the typing cursor. Today, we explpore the Scroll Lock key.īack when the Scroll Lock key was first invented, mice and graphical operating systems were still not mainstream like they are today. Most have changed key placements and adding, combining or removing keys due to evolving technological needsīut there is a key that has managed to hang on through history, despite most people not knowing what it even does. However, the keyboard has evolved much over the 36 years since its creation. It came with a set of 83 keys which have since become industry standard.

#How to turn off scroll lock excel 2010 Pc

Long ago in the year 1981, IBM released their original PC keyboard.