I use mac and I have 'Excel for Mac 2011'. I need to exact some data from a file. I can open the file, but can't see any data of it. I am afraid I need to do some setting so that I can see the data, but I don't know what should I do. View 1 Replies View Related Excel 2011:: Using Macros To Export / Archive May 2, 2013. I'm using Excel 2011 on a MacBook Pro.

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 Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, _ ByVal 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. 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.

First, make sure you have followed the steps to add the network printer here: Please note that going forwad, Ricoh MFP running on Mac's will be setup to print via the IP port rather than through the server print queue. This document shows how to set a job code on a Ricoh / Lanier multifunction printer In order to set a job code for a Ricoh MFP on a Mac, you need to set a custom preset for the printer. Ricoh c2550 driver for mac sierra. • After installing the printer, open up any program and go to file print.

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.

By Knowing how to make radio buttons in Excel 2011 for Mac is just as important as knowing how to make check boxes. Radio buttons (also called option buttons) are similar to check boxes, but you use radio buttons when only one of several choices is allowed. You put a group box around each group of radio buttons that answer a given question so that Excel 2011 for Mac knows which radio buttons answer which question. Each group has a single cell link for all the radio buttons within the group.

You can put as many radio buttons as you want within a group, but you do need a minimum of two radio buttons to make the choices work. First you make radio buttons and then you group them. To finish up, you make the cell links. Making a radio button in Excel 2011 for Mac Take these steps to make a radio button. • While your form is unprotected, click the Radio Button control on the Developer tab of the Ribbon.

• Drag diagonally and then let go of the mouse. A radio button appears and is selected on your worksheet. Repeat Steps 1 and 2 for each radio button you need. If you don’t make the right number of controls, you can always make more of them or delete them any time.