Soluții pentru problemele tale IT
Have you heard of Power Query in Microsoft Excel but always thought that it’s only intended for Excel experts? Let me stop you there because, actually, Power Query is designed to be user-friendly and, most importantly, save you a lot of hassle when organizing your data.
[mai mult...]Splitting the contents of a cell into more than one column manually in Microsoft Excel would take too much time and likely result in errors.
[mai mult...]Over time, as you keep creating new custom Quick Actions, your Mac’s Quick Actions can become cluttered due to too many Quick Actions. You can prevent this by disabling the Quick Actions you don’t use regularly.
To manage Quick Actions on your Mac, launch the “System Settings” app. Go to “General,” scroll down, and select “Login Items & Extensions”.
Scroll down to the “Extensions” section and click the “i” button next to “Finder.” You should see a list of all the built-in and custom Quick Actions you currently have on your Mac. Flip the toggle next to a Quick Action off to disable it and hit “Done”.
In the future, if you need to use this Quick Action again, you can enable it. Head back to the same page and toggle on the switch next to it.
[mai mult...]As soon as you create a Quick Action—using either method—it’s automatically added to the Quick Actions menu on your Mac, ready to use.
Alternatively, you can click on the Quick Action you want to use in the Preview pane. You need to enable the Preview pane for this to work. Open Finder and go to View > Show Preview, or press the Command+Shift+P shortcut.
Similarly, if your Mac has a Touch Bar, you can execute Quick Actions from it as well. However, you’ll need to configure it first from the Touch Bar settings.
Depending on what Quick Action you just used, it may work in the background, apply changes to the selected files, and save them automatically. Or it may ask for your input. The Convert Image Quick Action is a great example of this. When you run it, you’ll see prompts on your screen asking you to select the desired output format, among other things. Make the appropriate selections, and the Quick Action will complete the operation and save the file.
Unless you’ve opted to preserve the original file while creating a workflow (in Automator or Shortcuts), the Quick Action will overwrite the original file and save it in the same location.
[mai mult...]Automator is a built-in macOS app that lets you create workflows to automate repetitive tasks on your Mac. While creating workflows often requires a good understanding of programming languages, Automator employs a simple approach, wherein you drag and drop actions to stitch them together and create workflows.
To create a Quick Action, launch the Automator app under Applicatons > Utilities. Click “New Document,” and when prompted to set the document type, select “Quick Action” and hit “Choose.”
In the workflow area, set the Workflow Receives Current action to “Image Files” in “Finder”
Now, in the Actions sidebar, select “Files and Folders” and drag and drop the “Get Selected Finder Items” action to the workflow area on the right.
Once done, in the Scale Images action, enter the size (in pixels) you want your images resized to in the text field next to the “To Size” dropdown. Note that this value is essentially the maximum size of the longest side of the image, meaning it could be the width (for a landscape image) and length (for a portrait) image.
Finally, with all the actions added, save the Quick Action. Go to File > Save, or press the Command+S keyboard shortcut. Give a name to this service and click “Save”
If you ever want to edit the Quick Action in the future, open the Finder app and press the Command+Shift+G shortcut to access the Go to Folder window. Type in ~/Library/Services, and you’ll see all your Automator Quick Actions.
[mai mult...]