If you want to move to another cell in the same row (without changing the highlight), you can use Tab to move to the right and Shift Tab to move to the left. Color Index = xl None End With End If r = Selection. is your source for cost-effective Microsoft Excel training.If you prefer to have Excel automatically highlight the row, you must rely upon a macro. This tip (2457) applies to Microsoft Excel 97, 2000, 2002, and 2003. Protect End If End Sub Perhaps this may be useful to your readers Kind regards Derek OK, there was still a slight issue with the Microsoft part after looking at it, so this now is fully correct.After selecting a cell or group of cells, use the Format Cells dialog as above to lock or unlock it.Then select your next cell(s) and hit F4 to repeat your last action.
This is very annoying when we don’t need the blanks and want to paste non-blank cells only.You've worked hard on your spreadsheet and now you want to make sure anyone you share it with doesn't inadvertently change cells that shouldn't be changed. When you or anyone else tries to edit any of the locked cells, this message will come up: The cells can only be unlocked when the sheet is unprotected (by going to the Review tab again, choosing "Unprotect Sheet," and entering the password, if required).Thankfully, Microsoft Excel 2016 and earlier versions let you lock cells to protect them from being modified. In the Protect Sheet window, enter a password that's required to unprotect the sheet (optional) and any of the actions you want to allow users. There might be times when you want to lock certain cells from being changed but still allow users to adjust other cells in a worksheet.You can lock all the cells in a worksheet or specific cells, allowing some parts of the spreadsheet to be changed. By default, when you protect a sheet or workbook, all of the cells will be locked. In our example, in an inventory list you might allow unit prices and stock quantities to be updated, but not the item IDs, names, or descriptions.This means they can't be reformatted or deleted, and the content in them can't be edited. As mentioned above, all cells are locked by default when you protect the sheet. These will be the cells that can be edited even after the sheet is protected. Right-click on your selection, select Format Cells, and click on the Protection tab.