Best Answer: Here is a simple way to just add a 'check mark' to any cell in a specified column just by double clicking the cell. This was created in Excel for PC, but Excel 2011 supports macros/event handlers created in Excel. The following example uses column 'A' (1) as the column to return the check mark in. If your column is not 'A', change the '1' to the number representing your column, i.e. A = 1, Z = 26. Then, copy the following code, modified if needed, to the clipboard: Private Sub WorkbookSheetBeforeDoubleClick(ByVal Sh As ObjectByVal Target As Range, Cancel As Boolean) If Target.Column = 1 Then ActiveCell.Font.Name = 'wingdings 2' ActiveCell.Font.Size = 12 ActiveCell.Font.Bold = True ActiveCell.Value = 'P' ActiveCell.HorizontalAlignment = xlCenter End If End Sub Select the sheet you wish to use this in and right click the sheet tab.
Select 'View Code' Paste the event handler into the white editing area to the right. Close the VBE and return to the worksheet.
One click to insert checkbox symbol or checkbox (content control) in Word. In general, you can insert a checkbox symbol with finding it from symbol library, or insert a checkable checkbox control with enabling Developer tab and adding such a content control.
Double click any cell in your specified column and the check mark will be entered. Note: the accessing of the VBE in Excel 2011 for Mac may be different than indicated above. Not sure, I don't have a Mac. Garbo7441 Your reply was simple but very good, just that I needed for my spreadsheet. Excel Help is not very good, but if you word it correctly you get the right answer. Switch rows of cells to columns or columns to rows Data from the top row of the copy area appears in the left column of the paste area, and data from the left column appears in the top row.
Select the cells that you want to switch. Select the upper-left cell of the paste area.
The paste area must be outside the copy area. On the Edit menu, click Paste Special.
Select the Transpose check box. Tell us some more. Upload in Progress. Upload failed. Please upload a file larger than 100x100 pixels. We are experiencing some problems, please try again.
You can only upload files of type PNG, JPG, or JPEG. You can only upload files of type 3GP, 3GPP, MP4, MOV, AVI, MPG, MPEG, or RM.
You can only upload photos smaller than 5 MB. You can only upload videos smaller than 600MB. You can only upload a photo (png, jpg, jpeg) or a video (3gp, 3gpp, mp4, mov, avi, mpg, mpeg, rm). You can only upload a photo or a video. Video should be smaller than 600mb/5 minutes.
Photo should be smaller than 5mb. You can only upload a photo.