I have the new 2013 MacBook Pro. I have purchased Microsoft Office for Mac, which is what I'm using when I say 'Mac Excel' I am a power excel user in PC Excel but am having a hard time in Mac's excel, as many of the Mac excel shortcuts don't work. Jump to Get started - Shortcut conflicts. On the Apple menu, press System Preferences. Press Keyboard. In the tabs, press Shortcuts. Click Mission Control. Clear the check box for the keyboard shortcut that you want to use. For instance, to edit active cell, in Windows its an easy 'F2' shortcut, in Mac excel, ^+U (shift +U) isn't working. In fact, none of the shortcuts (with the exception of the most basic like cut and paste (Ctrl+C, Ctrl+V in Windows) are working. ![]() I switched my command button to be my control button, since I'm so used to the PC keyboard layout, but I always press Mac's CONTROL when a shortcut indicates to use the squigly square COMMAND button. I just don't understand why the most basic shortcut like ^+U to edit an active cell isn't working in my Mac excel. So frustrating! Thank you for any tips on how to fix the Mac excel problem with Mac shortcuts not working. I have just done a little experimenting and I think I have some idea of why you're having a problem. I opened up Mac Excel 2011 and selected a cell. I pressed Control-U and I was able to edit it. I also pressed F2 and I was again able to edit it. So I'm starting to think that there is a configuration problem somewhere on your Mac. On Control-U: I am wondering if this no longer works on your Mac because you remapped Command to Control. Because in Mac Excel, Command-U (apply underline formatting) and Control-U (edit selected cell) are two different features, so if you remapped Command to Control at the system level, Excel now behaves such that all Command-modifier shortcuts are now Control. Therefore, Command-U (underline text) is now Control-U, and whatever was Control-U before (edit active cell) is disabled since a shortcut can only mean one thing at a time. That's my theory on why Control-U stopped working for you: You told the Command-U feature (underline text) to replace the former Control-U feature (edit active cell). One possible way to fix this is that because remapping Command to Control eliminates access to Control key shortcuts, you could also remap Control to Command so that you can regain access to shortcuts that need the Control key like Control-U. Basically you would be swapping the two keys. (I think that would work, anyway) But ultimately my recommendation is that if you bought a Mac intending to commit to the Mac.then really commit to the Mac. Stop trying to use the Control key and learn the Command key so that in applications that make use of both Command and Control shortcuts, you don't lose an entire set of shortcuts when you remap. On F2: If pressing F2 changes your screen brightness instead of editing the active cell, then there is a setting you can change. Open System Preferences, click the Keyboard icon, click the Keyboard tab in there, and select the setting 'Use all F1, F2, etc. Keys as standard function keys.' When you do that, F2 will now function as F2 and not as screen brightness adjustment. (I like some F keys to be function keys and other F keys to be hardware keys, so I use a utility called to set the behavior of each F key separately.) The other way to do that is to not change the 'Use all F1, F2.as function keys' setting but instead press Fn+F2, because adding the Fn key always makes a function key do the opposite of whatever the 'Use all F1, F2.'
0 Comments
They say that a picture is worth a thousand words. And if that’s the case, then a lot of pictures must be worth a lot more words, right? Sure they are. Whether it’s commemorating special occasions like weddings, birthdays and graduations, capturing the beauty of nature, wildlife etc., or even the hipster popularized current fad of on a daily basis and posting them on social networks, pictures have always been the best way of immortalizing memories and expressing ourselves, and that’s still the case. Almost all of us have quite a sizable collection of pictures (and of course videos, which are sort of extensions of pictures) on our computers, smartphones, or whatever, that we like to revisit on a frequent basis. But I’m sure you’ll agree, that clicking through a listing of photos (and videos) time and again often gets a little monotonous. And that’s where slideshow maker tools come into the picture. These fun little software and online tools let you transform your favorite images (and video clips) into stunning looking slideshow videos, complete with stuff like background music, wicked cool transition effects, and even captions. Sounds dope, doesn’t it? Read on, as we run down the listing of some of the best slideshow makers out there. For your convenience, we have subdivided the list in Desktop based software and online tools. ![]() ![]() We’ll first discuss the software and then move onto web apps. Best Slideshow Makers – Desktop Applications Movavi Slideshow Maker Powerhouse applications don’t always have to be cumbersome to use, and Movavi Slideshow Maker is solid proof of that. However, this slideshow can’t be further transferred online or burned to a CD. So you can’t do without a good slideshow maker which outputs slideshows in a video format. We collected for you the best tools which will help create amazing slideshows free and easily. It cannot be used on Mac. Doesn’t come with much sound tracks. VideoPad Video Editor. Features: This DVD slideshow maker for Mac supports a number of video edit tools which would let you come up with lively and interesting slideshows. This software can run on all versions of Mac OS X. A well rounded program, it makes creating slideshow videos, in its own words, as easy as 1-2-3. You can add as many photos and videos as you want, either individually, or as entire folders. After that, you can upload either multiple audio files of your choice, or use some of the pre-installed sound effects. Finally, select one (or all) of the included transition effects to be applied to the added photos and videos, specify parameters like output directory and format, and that’s about it. What’s more, you can individually apply basic edits like auto enhance, volume leveling, rotate etc. To the added media before creating the slideshows, and the preview window on the right makes it simple to preview the changes and adjust them, thanks to the playback buttons. Movavi supports a plethora of input and output formats, including BMP, GIF, PNG (Images); 3GP, MP4, MKV (Video); and AAC, FLAC, MP3 (Audio). Pros: Surprisingly easy to use for a feature loaded application, Lots of audio/video/image formats supported, Basic edits can be applied to added media before creation, Custom output profiles for different purposes. Cons: Occasional random crashes, Full-screen functionality is a little clunky, “Trial version” text overlaid on created slideshow videos. Compatibility: Windows 10, 8, 7 and XP. Pricing: $29.95 for the full version. 7 day trial available. Taking a look at ProShow Gold for the first time can be a little intimidating, given the barrage of sub-windows, settings, and other stuff that its UI is composed of. However, once you get the hang of all that, things get a lot easier. The professional grade slideshow maker application boasts a healthy collection of features. You start off by adding the photos and videos to be used for the slideshow via the Folder List column on the left, upon which they are added to the Slide List/Timeline bar at the bottom. You can also use the Import option to add content directly from social networks such as Facebook, Twitter, and Picasa. Once added, each photo/video added can be extensively tweaked, and you can add everything from slide montages, to transition effects, to themes to them. And of course there are options to add background music, captions, and stuff like that. The changes can be previewed in the preview window on the right. If you are a Hackintosh user in desktop visualization software, then VMware Workstation is a must so as to make USB installer, restore images and many more. For doing all these on your VMware Workstation, it is mandatory to have “VMware unlocker” which is a necessary utility to run Mac OS X guests. VMware Workstation is a hypervisor that enables users to set up one or more virtual machines (VMs) on a single machine, and use them simultaneously along with the actual machine. ![]() If you’ve never ever tried the Mac OS X Operating system using VMware, then you need to know that we use a patch called VMware Workstation Unlocker that helps to unlock the option to create virtual machines in Mac OS X. Unlocker utility is capable of replacing few VMware program files which allow you to install VMware and run the latest 11, 10.10, 10.19 and earlier versions of Mac OS X guest virtual machines. Here are the download links of perfectly working unlocker for latest VMware Workstation 11, 10, and other series versions that works on Windows 10, 8.1, 8 (64 bit) and Windows 7 (32 bit) physical computer. Unlocker Utility Unlocker utility is a patch which is used to unlock the option to create virtual machines in Mac OS X. By unlocking it using Unlocker utility, you can easily create virtual machines in Mac OS X as guest operating systems. There are many virtual machines such as Yosemite, Mountain Lion and Mavericks that can be used as guest operating systems on VMware workstation. Now, this unlocker utility patch is required if you want to install and use the above mentioned Mac OS X virtual machines as guest Operating Systems on VMware workstation 11 or 10. MacOS Sierra v10.12 VMWare Image Free Download Latest Version for Windows. Its full offline installer standalone setup of MacOS Sierra v10.12 VMWare Image. MacOS Sierra v10.12 VMWare Image Overview. MacOS Sierra v10.12 VMWare Image is an awesome operating system where Siri has made its debut on Mac OS. ![]() Earlier, there were some versions of Mac OS X like Snow leopard 10.6 and leopard 10.5 that run on VMware desktop virtualization products even without using this unlocker utility patch. But now, the latest versions of Mac OS X requires patching. How to patch (or) unlock VMware workstation 11 using Unlocker 2.0.2 in Windows 10, 8.1 & 7 Before unlocking or patching VMware workstation using the unlocker utility, you need to download and install the latest version of Unlocker 2.0.2 from the official website given below: (Requires Free Registration) (No Registration Required) Step 1: Initially, make sure that VMware is installed on your system. Before Unblock or patch, it looks this way as shown in the image: Step 2: Download the Unlocker Utility version 2.0.2 from the above links. Step 3: Now, you need to extract the archive & open the folder. Step 4: Make sure that you close all the virtual machines and VMware workstation program that are currently running on your system. Right click on ‘win-install.cmd’ and select Run as administrator. Step 5: You need not do anything for few seconds as the Terminal window will be opened so as to run that particular unlocker file. In the command prompt, you can see some scripting stuff that stops the VMware services and some other scripting stuff. Then, it will start the VMware services. Step 6: Once it has successfully patched the VMware workstation 11, you will be then able to see the Mac OS X guest support as shown in the image below: That’s it. You have successfully patched or unlocked the virtual machine that you wish to run it on the VMware workstation. The below image shows the working Mac OS X 10.10.1 on Windows 8.1 with VMware workstation 11. Samsung's first Gear 360 was a promising product, but one that fell short of expectations in real-world use. Despite capturing pretty decent 360-degree video, it was hampered by limited smartphone compatibility and shoddy software support. Samsung took note of criticisms when creating the 2017 edition of the Gear 360 ($229.99). It addresses those issues, adding support for iOS and macOS devices. We originally recommended the camera only for desktop editors and Samsung phone owners, but improvements to the iOS app have broadened its appeal, making it our Editors' Choice among 360-degree video cameras. The was a fist-sized globe with a tripod mount. This one has a smaller camera globe, set atop a finger-length stalk that contains the battery. It measures 3.9 by 1.8 by 1.8 inches (HWD) and weighs 4.6 ounces. Connect with the Samsung Gear 360 app to enjoy various features. With the Samsung Gear 360 app, you can create, view, and share 360 content on your smartphone, and enjoy various features by connecting Gear 360. ※ This app is compatible with Gear 360 (2017). Main features: - Connect to and disconnect from Gear 360. Hi, I am the new user of Gear 360, Does anyone got this problem when converting the photo? Please help and assist, I have no idea with this, thank you very much. A rubbery ring can be placed around the base to keep it in place, where the old camera would have rolled away without a tripod. There's also a standard tripod socket, so you can use the support of your liking—a or other support with flexible legs is a good match, as it will let you attach the camera to places where a normal tripod wouldn't have a leg to stand on. The camera is IP53 rain resistant, but not waterproof. ![]() It charges and syncs via a USB-C port, and records to a microSD memory card. The battery is sealed in, but you can use it while it's plugged in and charging. In our tests the battery was good for 90 minutes of recording in 4K, but you can expect longer use if you opt for a lower resolution—about two hours when shooting in 2K. Wireless file transfers also take a toll. Transferring a seven-minute clip dropped the battery by about 15 percent and took 25 minutes if you use a recent smartphone like the Galaxy S7 or iPhone 7 Plus. If you have an older phone, expect the transfer to take longer, as video processing is part of the process—the same clip took about an hour to transfer to an iPhone 6 Plus. You can use the camera without an app. ![]() It has a small monochrome information LCD that shows the current shooting mode, as well as Menu, Power/Back, and Record buttons. It's easy enough to start and stop video with Record, and you can switch between image and video modes using the physical controls. Pairing the Gear with your phone gets you a Live View feed, as well as more robust controls, including exposure and white balance. The two lenses are closer together on the new model, reducing stitching problems, and they record 4,096-by-2,048 4K video at 24 frames per second; no other frame rate options are available at full resolution. Hi JL, I have got the updates from the related team that this is working as expected. The dialog showing the number of duplicates will appear after the action of 'remove duplication' is taken. If you just want to know the number of the duplicates, you can click undo. I understand it works as you expected in 15.41 version. But the feature has changed from 16.9 version. ![]() If you do expect to get the desired feature back, the best way to influence the product is to share you ideas. Our team is listening to customer's feedback there and will consider updating/adding features based on customers' constructive comments. We appreciate your understanding. ![]() In Excel, there are several ways to filter for unique values—or remove duplicate values: To filter for unique values, click Data > Sort & Filter > Advanced. To remove duplicate values, click Data > Data Tools > Remove Duplicates. To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab. To remove duplicates, you must remove both the outline and the subtotals first. Select the range of cells, or make sure that the active cell is in a table. On the Data tab, under Tools, click Remove Duplicates. Select one or more of the check boxes, which refer to columns in the table, and then click Remove Duplicates. Uninstall coconutBattery 3.7.2 Successfully From Mac: Steps To Clean coconutBattery 3.7.2 From Mac OS X Quickly. It is true that several times use faces difficulty when try to uninstall coconutBattery 3.7.2 from their Mac machine. If you use the online service coconutBattery Online, anonymized battery information is sent to this server. This access is treated in the same way as access via a web browser. Upgrade to coconutBattery Plus. Of course there's a free trial where you can try the features of the Plus-Upgrade for 14 consecutive starts of coconutBattery. Download The battery of a MacBook is, like that of any other laptop, less powerful when he gets older. Unfortunately, it is in MacBooks is not possible to have the battery replaced. An Apple Store may have a replacement run. How strong the capacity of the battery by the time reverse is gone, it is usually a matter of feeling, but there are also tools to the state of the battery is really transparent. An example of such a free program is CoconutBattery. CoconutBattery is a free tool for the MacBook that the battery status can be checked. You can both the history and the current status of the battery. This is not only to the time that the battery will last, but also the temperature and the amount of time that it is charged. With the online service CoconutBattery Online you can select your battery capacity compare with that of other users. Has the following characteristics: • current state-of-charge (in mAh), • maximum laadststatus (in mAh), • current capacity of the battery (in mAh), • capacity of the battery is in new condition (in mAh), • the model of the MacBook, • the age of your MacBook (in months), • battery recharge cycles, • current battery temperature (in degrees), • energy consumption in Watts. ![]() ![]() CoconutBattery screenshots You can free download CoconutBattery and safe install the latest trial or new full version for Windows 10 (x32, 64 bit, 86) from the official site. Devices: Desktop PC, Laptop (ASUS, HP, DELL, Acer, Lenovo, MSI), Ultrabook OS: Professional, Enterprise, Education, Home Edition, versions: 1507, 1511, 1607, 1703, 1709, 1803, 1809 Categories. It shows you live information about your battery such as how often it was charged and how is the current maximum capacity in relation to the original capacity your battery had when it left the factory. Ou are also able to save the current maximum capacity of your battery. So you can see the changes of your battery health over time. With the online service 'coconutBattery Online' you can now compare your battery capacity with others. CoconutBattery is and will always be freeware. If you like it, a donation is always very welcome. Easy Barcode Creator 3.1.3 lets you make professional, ready-to-print barcode graphics. You don't need to know anything about barcodes to use Easy Barcode Creator! Whether you need a quick solution or a custom-shaped barcode to meet your specific needs, Easy Barcode Creator generates ready-to-print vector EPS graphics for use in industry-standard products like Adobe Illustrator, InDesign, and Photoshop -- or just import into Word or a drawing program. Easy Barcode Creator offers a fast, user-friendly interface with a WYSIWYG preview of the barcode you're creating. Select the barcode you need, or browse Symbology Info to decide what kind of bar code you need. Easy Barcode Creator supports industry standards like EAN, ISBN (Bookland EAN), UPC, I2of5 (Interleaved 2 of 5), Code 39, Code 128, EAN-13, UPC-A, and more! Easy Barcode Creator's integrated barcode generator will build the barcodes you need in a snap! Leading Barcode Software for Windows, Mac, Linux, UNIX, SAP R/3. 1D+2D Barcode Generator, Label Software, Barcode Printing, Reporting Software, Data Acquisition. Clever apps to scan barcodes straight into Microsoft Office, for inventory control and for wireless data collection. Cloud Barcode Scanner - Scan-IT to Office. Businessbarcode.com is global provider of Business Barcode software to design printable price stickers, asset tags for commercial products for retail business industries, healthcare, packaging and supply, manufacturing industries etc. Click here for MAC ID Card Maker Software. ![]() Best of all, Easy Barcode Creator is affordable and reusable! No longer will you need to pay expensive fees for barcode generation services or required software renewals; with Easy Barcode Creator, simply try it out, buy a license, and it's yours to use as you wish, as often as you wish. When you order online, you'll get your activation key instantly, so you can save your first bar code instantly. That OS X asks for the old apple id is probably because you didn't do a clean install. You could make a backup of all your data with time machine and start your mac in recovery mode (press cmd+r) on startup. Macworld reader Arthur is trying to download updates via the Mac App Store, but is stymied, because an Apple ID associated with the previous owner of the machine appears prefilled in the Sign In dialog and can’t be changed. He wonders what to do. IDG Apps purchased or downloaded with another Apple ID will persist in prompting you for that account’s password when they need to be updated. Apple associates app purchases with the account that made the purchase. This includes “free” apps, because such apps can have in-app purchases, which would also be associated. If you bought, inherited, were given, or found on the street a Mac that was previously owned and not wiped clean, you can wind up with apps installed that are registered to a previous user. Because it’s a design feature, not a bug, there’s no way to get rid of this without deleting all the apps that were purchased or downloaded under that other Apple ID. However, when you update individual apps, the login for an Apple ID other than your own shouldn’t appear unless that app was purchased or downloaded by that other party. That could help you sort out which ones to remove. Or you could ignore updating those apps. This can be a real problem with apps like Pages and Numbers, which are free for everyone with a Mac, but are registered to a specific user. You should be able to delete them and then re-download while logged into your own Apple ID account in the App Store, and the apps should then be registered to your Apple ID. ![]() Ask Mac 911 We’ve compiled a list of the questions we get asked most frequently along with answers and links to columns: to see if your question is covered. If not, we’re always looking for new problems to solve! Email yours to including screen captures as appropriate, and whether you want your full name used. Every question won’t be answered, we don’t reply to email, and we cannot provide direct troubleshooting advice. Apple has announced the Mac OS Sierra as the next version of Mac system software. During its presentation that took place at the WWDC 2016 conference, the new macOS sierra was versioned as Mac OS X 10.12 and will be accessible as a free copy for all compatible Macs. The Mac OS 10.12 final comes with a lot of amazing features. One major feature is the debut that Siri makes on the Mac. Siri has been designed with new capabilities for the Mac desktop. This is the only way to make the Mac desktop a smart device. Now, You can install macOS Sierra on Windows. VirtualBox is capable of installing a macOS on your computer as an application. It works perfectly well with Sierra and in order to run macOS on windows, you need a computer with windows that has to be 64-bit, at least 4GB RAM and a dual-core processor. Installing macOS Sierra in VirtualBox is very easy; you download virtual disk and open it with VirtualBox, then create a new virtual machine. Here are the steps to install macOS Sierra on VirtualBox on Windows. Latest preview: 10.12 Final (16A323). Download Image: Google Drive (One Full): Google Drive (5 of 5): Fix Download Limit: Code for VirtualBox (New): VirtualBox: Steps to Use macOS 10.12 Sierra on VirtualBox on Windows Step 1: Extract Image File with Winrar or 7zip Install, Select Image file, Right click then select “Extract Here”. ![]() Download Virtual Machine For faster installation on operating systems where there is no pre-built binary ( RPM-based Linux releases, older OSX releases, or if you are unable to install the latest XCode on OSX), it is possible to install OpenModelica on a virtual machine. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2019
Categories |