How to lock a row in excel

column and row

column and row headers radcalendar ui for winforms documentation .

column and row

columns and rows in excel and google spreadsheets .

column and row

column and row headers settings radcalendar for asp net ajax .

column and row

transpose excel data from rows to columns or vice versa techrepublic .

column and row

highlight the active row and column in a data range in excel .

column and row

how to convert a row to a column in excel the easy way .

column and row

rows and columns in excel 2010 .

column and row

how to display or hide row column headers in excel .

column and row

how to tell the difference between a row and column penjee learn .

column and row

column row headers commonlook office for ppt 508 accessibility .

column and row

creating a table .

column and row

insert a column or row column row workbook worksheet microsoft .

column and row

how to convert a row to a column in a microsoft word table .

column and row

microsoft excel tutorials rows and columns .

column and row

difference between a row column vector study com .

column and row

creating a header with multiple rows or columns .

column and row

how to sum based on column and row criteria in excel .

column and row

how to print the gridlines and row and column headings in excel .

column and row

transpose in excel convert rows to columns and vice versa .

column and row

column and row ideal vistalist co .

column and row

print row and column headings excel .

column and row

column row headers 508 accessibility compliance .

column and row

row and column spaces wikipedia .

column and row

matrices rows columns elements solutions examples videos .

column and row

working with tables .

column and row

column major vs row major arrays does it matter the craft of coding .

column and row

how to transpose a values in a row to column using formulas .

column and row

defining row and column models sap documentation .

column and row

hybrid row column stores a general and flexible approach teradata .

column and row

excel formula highlight row and column intersection exact match .

column and row

moving excel 2010 data from rows to columns and back again .

column and row

entire rows and columns in excel vba easy excel macros .

column and row

dynamic chart display values from a table row or column .

column and row

google sheets modifying columns rows and cells full page .

column and row

faq locking freezing heading rows in openoffice calc and freezing .

column and row

adjusting column width row height in excel video lesson .

column and row

how to write both row and column indexes in a table java nested .

column and row

find data with excels row and column functions .

column and row

less columns more rows more speed powerpivotpro .

column and row

table column and row highlight by using jquery css youtube .

column and row

solved error in excel insert column or row in excel solution provided .

column and row

managing with rows and columns for syncfusion essential windowsforms .

column and row

page builder plugins that offer to add nested rows columns or row .

column and row

row and column spaces wikipedia .

Related text  How to raise credit score fast

column and row

freeze panes to lock rows and columns excel .

column and row

microsoft excel tutorial lesson 4 the cells of a spreadsheet .

column and row

columns and rows any difference tableau public .

column and row

sap hana tutorial .

column and row

row and column css .

column and row

excel wont insert a column or row auditexcel co za .

column and row

get the active cells column or row vba code examples .

column and row

matrix multiplication column by row youtube .

column and row

row and column indexing video matlab .

column and row

calculated columns row context profunda analytics .

column and row

table column and row highlight by using jquery css webslesson .

column and row

program to find row sum and column sum of a matrix .

column and row

what is a row .

column and row

row and column spaces wikipedia .

column and row

switch rows and columns in a chart .

column and row

difference between a row column vector study com .

column and row

pivot c array or datatable convert a column to a row with linq .

column and row

left handed right handed up vector column vector row vector .

column and row

how to tell the difference between a row and column penjee learn .

column and row

how to delete a table row or column in microsoft word youtube .

column and row

column and row headers radcalendar ui for winforms documentation .

column and row

understand the cassandra data model introduction to cassandra .

column and row

switch rows and columns in a chart .

column and row

a complete guide to grid css tricks .

column and row

column row expansion .

column and row

for seniors how to insert and delete rows and columns in an excel .

column and row

column and row generator stage in datastage .

column and row

how to sum based on column and row criteria in excel .

column and row

transpose excel data from rows to columns or vice versa techrepublic .

column and row

insert or delete cells rows and columns excel .

column and row

column row groups jformdesigner java swing gui designer .

column and row

bbc gcse bitesize columns rows and cells .

column and row

rows vs columns difference between .

column and row

switching rows and columns in an indesign table indesignsecrets .

column and row

highlight both column and row on hover in css only in html and css .

column and row

configuring the layout of the cross tab rows and columns .

column and row

convert column to row in excel excel pivot columns to rows .

column and row

microsoft excel highlight the current row and column thomas miniblog .

column and row

excel 2013 modifying columns rows and cells full page .

column and row

transpose feature in excel 2013 convert horizontal row data into .

column and row

hide and unhide columns and rows in excel .

column and row

how to quickly and easily delete blank rows and columns in excel .

column and row

flip columns and rows in excel column row excel excel quick tips how .

column and row

c delete selected row column in datagridview stack overflow .

column and row

excel sum formula to total a column rows or only visible cells .

column and row

excelmadeeasy vba disable insert row or column in excel .

Related text  How to make hamburger patties

column and row

grids rows and columns in the wolfram language wolfram language .

column and row

switch rows and columns in a chart .

Hiding whole rows or columns

If the spreadsheet contains a row or column of data purely used for calculations, hiding it is the quickest and easiest way of preventing the data from being easily accessible. Simply right click on the row number or column letter, and select Hide from the dropdown menu that appears. To unhide the hidden row or column, highlight the rows or columns either side of the hidden data, right click again and select Unhide from the drop-down menu.

hiding information image 1

Protecting cells and hiding formulas

To prevent the content of cells being edited, or formulas being visible, it is necessary to set cell protection in the Format Cells menu. To access this, select the cell (or group of cells) that are to be protected and right click within the selection. From the dropdown menu that appears, select Format Cells. A dialog box will appear; select the Protection tab from here.

Hiding information image 2

There are two options here, Locked and Hidden. Ticking the box next to Locked will lock any cells that are selected. This means that it will not be possible to make any changes to their content. Data cannot be changed or deleted. Ticking the box next to hidden will hide any the information in the formula bar, preventing users from seeing the workings behind the data.

Once finished, click OK. So that it is still possible to work on the spreadsheet, neither of these changes will come into effect until the sheet has been protected.

Using Protect Sheet

To protect the sheet, click on the Protect Sheet icon on the Review ribbon. There are lots of options here, and depending on how much functionality the end user is to be left with, it is possible to tick all, none, or some of the available options.

Hiding information image 3

To lock cells and hide formulas, make sure the checkbox above the password field is ticked. This will only be applied to cells where cell protection has been turned on.

It is not necessary to enter a password if the intention is to just prevent the sheet from being accidentally modified, however, if the intention is to stop it from being changed deliberately, entering a password will prevent other users from being able to unprotect the sheet and make changes.

Related text  How to make chicken gravy

The options below the password field allow for users to have access to certain tools on the worksheet. By default, the only two that are ticked are Select locked cells and Select unlocked cells. This means that users can click on any cells within the sheet, allowing them to do things like copy and paste their content into another sheet or a Word document.

Format cells governs whether the user is able to change the appearance of the font, as well as the cell itself i.e. borders and backgrounds. It also allows access to the Format cells menu where options such as the type of number, or number of decimal places can be set. Format columns and Format rows allows column width and row height to be adjusted, and also lets users hide and unhide columns and rows.

The insert and delete options should be self-explanatory.

If Use AutoFilter is left unchecked, the arrow representing the AutoFilter dropdown will still appear, however, users will be unable to click on it. If it is checked, users will be able to filter the data, but will not be able to use the sort features on AutoFilter, unless the Sort option has also been ticked to allow users access.

Ticking Use PivotTable & Use PivotChart will allow the user to manipulate any PivotTables or PivotCharts in the worksheet. They will still appear if it is left unticked, but they will just function as tables i.e. the user will be unable to manipulate their content.

The Edit objects option controls whether the user is able to make changes to objects embedded into the worksheet, including things like images, charts, buttons and comments. In the case of objects with macros assigned which act as buttons, the user will still be able to click to run the macro, but will be unable to edit or delete the object.

Protecting scenarios by leaving Edit scenarios unticked will prevent changes being made to existing scenarios, but will not prevent new scenarios from being created.

Hope you enjoyed this lesson! Thanks again to Nick who works as a tutor on www.acuitytraining.co.uk’s Excel courses for putting it together.

This entry was posted in Quick Tips. Bookmark the permalink.

Like this post? Please share to your friends: