![Excel selecting multiple cells problem Excel selecting multiple cells problem](http://drawingwithnumbers.artisart.org/wp-content/uploads/2017/03/2017-03-11-16_17_44.gif)
Keyboard shortcuts allow you to quickly complete commands and functions without using a mouse. Many of the shortcuts that use the Ctrl key on a Windows keyboard also work with the Control key in Excel 2016 for Mac. Most of the times we use CTRL + Click to select the non-adjacent cells in our excel spreadsheet. Selecting non-continues cell ranges is not a rocket science To select the non-adjacent cells most of the times you use CTRL + Click.
Microsoft Excel allows you to create a drop-down list that gives you the ability to choose values or items listed in one cell. This can be used with your business reports or invoices.
An inactive list displays one value; a list activated by clicking an arrow button displays the whole list of values. Excel’s Data Tools give you options to display a message as the mouse hovers over the cell or show an error alert icon that prevents invalid data from being entered. Your drop-down list provides a streamlined set of choices without cluttering your worksheet. Insert Drop Down Box in Excel Open a new Excel worksheet and type a list of entries in one column or row. For example, type in Column A, Rows 1 to 7 and leave no blank cells.
Select all the entries, right-click the entries and choose “Define Name” from the context menu to open the New Name dialog box. Type a name in the Name field. This name will help you link the entries to your drop-down list. For example, ColorOptions can be the list name of this source. Click in the worksheet cell where you want to insert your drop-down list. You can select a different worksheet so the source list will not be visible. Click the “Data” tab on the command ribbon and click “Data Validation” in the Data Tools group to open the dialog box.
Click the “Settings” tab on the Data Validation dialog box and click “List” in the Allow field. Type the “=” sign in the Source field followed by the name typed in the Name field for your list. For example, “=ColorOptions” includes the equal sign and your list name with no spaces. Select 'In-cell dropdown.' Select 'Ignore' if users can leave the worksheet cell empty. Click the “Input Message” tab on the dialog box. To display a message when someone selects the cell, select “Show input message when cell is selected.” Type a title and a message in the fields.
To choose no message, leave the check box clear. Click the “Error Alert” tab in the dialog box and select “Show error alert after invalid data is entered. Select “Stop,” “Warning,” or “Information” from the Style list.
Type a title and error message in the fields. You can choose no error alert by keeping the check box clear.
Click “OK” to close the Data Validation dialog box. Test the drop-list by clicking the cell and the arrow button. The selected value will display in the cell.
By using the SHIFT and/or the CTRL keys you can select non-contiguous ranges. However, if you select a cell or area by mistake, there is no built in way to remove that from the selection without losing the entire selection and having to start over. Describes to VBA procedures, UnSelectActiveCell and UnSelectCurrentArea that will remove the Active Cell or the Area containing the Active Cell from the current selection. All other cells in the Selection will remain selected. Your best bet would be to add these to your Personal Macro workbook so that they are available to all open workbooks in Excel. This procedure will remove the Active Cell from the Selection.
Sub UnSelectActiveCell Dim R As Range Dim RR As Range For Each R In Selection.Cells If StrComp(R.Address, ActiveCell.Address, vbBinaryCompare) 0 Then If RR Is Nothing Then Set RR = R Else Set RR = Application.Union(RR, R) End If End If Next R If Not RR Is Nothing Then RR.Select End If End Sub This procedure will remove the Area containing the Active Cell from the Selection. Sub UnSelectCurrentArea Dim Area As Range Dim RR As Range For Each Area In Selection.Areas If Application.Intersect(Area, ActiveCell) Is Nothing Then If RR Is Nothing Then Set RR = Area Else Set RR = Application.Union(RR, Area) End If End If Next Area If Not RR Is Nothing Then RR.Select End If End Sub. A more robust way for deselecting multiple cells is described in this. It does include an extra prompt, but you can deselect an arbitrary number of cells/selections at once (instead of deselecting only the active cell or area) I'm posting the script here, with a small usability improvement (conditionally removed the redundant first prompt from the original post): Sub DeselectCells Dim rng As Range Dim InputRng As Range Dim DeleteRng As Range Dim result As Range xTitleId = 'Deselect Cells' Set InputRng = Application.Selection If InputRng.Count.