Using Disk Utility. The easiest way to format a disk in Mac OS X is using Disk Utility. It’s Mac’s native disk maintenance tool. To format a USB flash drive, simply plug the drive into your Mac, and choose it from Disk Utility’s sidebar menu. Then choose the Erase tab from the top bar. A pop-up menu will appear.

Inserting the AutoSum formula. The sum is 63. This shortcut is very useful if you have a tendency to use the AutoSum feature of Microsoft Excel for Mac a lot. Instead of taking your hands off the keyboard and clicking the AutoSum button on the toolbar you can execute this 3 key shortcut and move onto your next task seamlessly. Top 5 Excel Shortcuts for the Mac. Excel Shortcuts; center align, delete, Excel for Mac, filter, font size, Mac Excel shortcuts, sum formula; Leave a comment; Many of you are transitioning to Excel for the Mac, and have asked us what our favorite Excel Mac shortcuts are. Mac shortcut. If you select just the cells you'd like to sum, SUM formula(s) are placed below the selection. If you select empty cells to the right and Excel will place SUM to the right and SUM horizontally. If you select empty cells below and to the right, Excel will add SUM formulas to cells below and to the right. Keyboard shortcuts in Excel for Mac - Use function key shortcuts On the Apple menu, press System Preferences. Select Keyboard. On the Keyboard tab, select the check box for Use all F1, F2, etc. Keys as standard function keys. The following table provides the function key shortcuts for Excel for. Mac excel shortcut for sum.

Your USB Drive or External drive not showing on Mac or Can’t format on macOS Mojave, high Sierra, EI Capitan running on iMac, MacBook, Mac Mini. Here are the alternate options for delete/ Format USB Drive on Mac Mojave using terminal/ cmd or without cmd command. In some case you need to format your drive, Pendrive showing full but you can’t show data inside there. The format in windows quite easily compared to OS X, For the new users haven’t any idea about how to format USB Drive on Mac. But you can do it easily through below steps format USB Drive on Mac OS X.

Drive Preparation 1. Open Disk Utility in your Utilities folder.

After DU loads select your hard drive (this is the entry with the mfgr.' S ID and size) from the left side list.

Click on the Partition tab in the DU main window. Under the Volume Scheme heading set the number of partitions from the drop down menu to one. Click on the Options button, set the partition scheme to GUID then click on the OK button. Set the format type to Mac OS Extended (Journaled.) Click on the Partition button and wait until the process has completed. Select the volume you just created (this is the sub-entry under the drive entry) from the left side list.

Click on the Erase tab in the DU main window. Set the format type to Mac OS Extended (Journaled.) Click on the Security button, check the button for Zero Data and click on OK to return to the Erase window.

Click on the Erase button. The format process can take up to several hours depending upon the drive size.

Steps 4-6 are optional but should be used on a drive that has never been formatted before, if the format type is not Mac OS Extended, if the partition scheme has been changed, or if a different operating system (not OS X) has been installed on the drive. There is only one universal format, FAT32 or MSDOS.

If the flash drive is formatted as such already then you need do nothing to use it on a Mac. If it's formatted NTFS, then: Drive Preparation 1.

Open Disk Utility in your Utilities folder. After DU loads select your hard drive (this is the entry with the mfgr.' S ID and size) from the left side list. Click on the Partition tab in the DU main window.

Under the Volume Scheme heading set the number of partitions from the drop down menu to one. Click on the Options button, set the partition scheme to MBR then click on the OK button. Set the format type to MSDOS. Click on the Partition button and wait until the process has completed. Dadlewis wrote: This is a simple 4GB usb formated on a MS PC and I just want to reformat it in universial format. It's likley already formatted FAT32 by default and will work on a Mac or PC just fine. Since it's only 4GB you can't put larger than 4GB sized files on it, so there is no need to format it exFAT on a PC or OS X Extended Journaled on a Mac for larger than 4GB sized files.

Just use it like it is FAT32/MSDOS and if it's NTFS, then use Disk Utility to format it: Partition 1, Option: MBR, Format: MSDOS. I too had the same problem. On a PC, you simply right click and select 'format.' The reason I wanted to do this on the mac is because I have an 8gb usb flash drive that for some strange reason, when I deleted all the files it still showed only 1.5 gb available making it impossible to put any more than 1.5 gigs of new data on it. I went to utilities like the previous posters said and simply clicked 'erase.' No need to partition, don't understand why you would need to do all of that to do a simple format.