People are too paranoid. As long as you havent transferred like a mega huge file within the last 5 minutes or so, i'd say it's safe to just unplug it. That's all I ever do. Share this post Link. How to disconnect the drive: Please follow the directions below to disconnect your external hard drive to a Mac computer system using eSATA. Please ensure that any files residing on the external hard drive are closed and no programs are accessing the hard drive. Click on the Apple icon and then click on Shut Down. I just get the message 'The device My Passport USB HDD could not be removed. Please close all running programs and try again later." The… I am not able to remove MY PASSPORT using the “Safely Remove My Passport” facility. Wd my passport for mac software.

I’m trying, with Excel 2013, to hide and unhide rows when a cell is a certain value. It's a form which should expand based on answers given. When C16 = YES hide rows 18:22.

If your job (or even your personal life) requires you to do anything substantial with numbers, chances are you use a spreadsheet app to do it. As a Mac user, you’ve got plenty of choices among spreadsheet apps, but for most of us the choice comes down to three:;; and the browser-based.

The one to use is really a personal choice, and that decision is not the focus of this article. (I personally prefer Excel, possibly because ). But regardless of the app you use, the question here is: How well do you know how to use it, really? As a spreadsheet vet, I gave that question some thought and came up with the following list of things that I think every savvy spreadsheet jockey—not beginners, but people who’ve been using one of these apps for a while—should know. I’m not talking about any specific task.

Rather, these are the techniques and concepts that I think you should know in order to graduate from casual to serious user. Format Numbers Because numbers can take many forms (decimals, integers, percentages), you need to apply formatting to make it clear what they mean.

For example, most people would find it easier to understand 25% as opposed to 0.25. So, after you enter the number in a cell and select that cell: Excel: Many often-used number formatting options are visible in the Home ribbon. You can also use the Format > Cells menu, then click Number in the dialog box that appears. All number formats are listed down the left edge of the dialog box; select one, and its options appear on the right. The Custom option (recently added to Numbers as well) is especially useful, as you can combine text with your formatted number. For example, a format of #,##0.00 'widgets' would format your number with a comma if needed, two decimal places, and the word widgets after the number. Your cells will still be treated as numbers for use in calculations, but they will display with the defined text.

Numbers: Click the Format icon (the paintbrush) in the toolbar, then select the Cell entry in the resulting sidebar. Select the option (Automatic, Number, and so on) you want to use from the pop-up menu. You may need to set other values: For example, if you choose Numeral System, you’ll need to set values for Base, Places, and how to represent negative numbers. (Numbers also includes special number formats such as Slider, Stepper, Pop-up Menu, and more; these can be used to create intuitive data entry forms.) Numbers offers a bunch of specialized number formats, including Slider. Sheets: All number formats can be found in the Format > Number menu; each formatting option appears in its own submenu. As in Excel, you can create custom number formats that mix text and numbers—but you have to find the option first, as it’s buried in the Format > Numbers > More Formats submenu. Merge Cells Another useful formatting trick is to merge cells.

Cracked quicken deluxe download for mac. Merged cells are what they sound like: two or more cells merged into one. This is a great way to center a header above a number of columns, for example. Merged cells are a powerful way to get away from the strict column-and-row layout of a typical spreadsheet. To merge cells, you want to have a value only in the first cell you intend to merge, as values in any other cells will be wiped out by the merge. Select the range of cells to merge, by clicking on the first cell (the one containing the data) and dragging through the range you wish to merge. Excel: Click the Merge entry in the Home ribbon, and then select one of the Merge options that appear in the pop-up menu—Merge and Center is what I use most often. Numbers: Select Table > Merge Cells.

Merging two cells into one is handy for creating column headers. Sheets: Select Format > Merge Cells, then choose one of the Merge options, such as Merge Horizontally. You can also merge cells vertically, which can be useful in tables where you have a parent cell (Salesperson, for instance) that contains multiple rows of data (for example, Product Sold and Units Sold). Use Functions You probably already know how to use basic formulas to do basic arithmetic on cell contents.

But functions, which let you manipulate text and numbers in many other ways, are how you really unlock the potential of spreadsheets. If quantity mattered most, then Excel would win, with (if I counted correctly) 398 unique functions. Google Sheets comes in a close second with 343, and Numbers has 282.