Mac Excel Library Folder

07.04.2020
99 Comments

The Library folder for the users on a Mac is always hidden as Apple just doesn’t want you to access it as it thinks you don’t need access to it. However, macOS does provide an option to see this folder and access its contents, but you should only do that if you know what you are doing as a single mistake may mess-up everything in there.

We already have a guide that shows how you can quickly access the Library folder on your Mac, but what it doesn’t do is it doesn’t let you unhide the folder. That way, you can access the folder, but it will not always be visible in the file explorer – the Finder app – on your Mac.

Mac Excel Library Folder Pdf

Oct 03, 2018  Inside the home folder on your Mac is a Library folder that stores app-specific files and settings, personal settings, and some data. The files and settings in the Library folder should be left alone for the most part. But, you may want to tweak the settings for an app, which may require accessing the Library folder. Before going ahead with the steps to Access the Hidden Library Folder on your Mac, you need to be aware that /Library Folder contains important Data and Files related to Mac User Accounts. Hence, make sure that you are accessing the Library Folder for a good reason and you do know as to what you are trying to achieve. Apr 16, 2018  Open the Library folder. Note The Library folder is hidden in MAC OS X Lion. To display this folder, hold down the OPTION key while you click the Go menu. Open the Preferences folder. Click View, and then click Arrange by Name. Look for a file that is named 'Com.microsoft.Excel.plist.' Locate the file, move it to the desktop. Home. How-To. How To: Unhide User Library Folder Mac OS 10.9 Mavericks In the past few versions of the Mac OS, Apple has taken to hiding the User Library folder. Whatever their reasons, Apple thought it best to hide that Library folder from everyone; regardless of your tech experience, or lack thereof.

Mac Excel does not have a default directory until you set one in Excel preferences General Preferred File Location. But you can use MacScript like this if you want to get the path of your Documents folder or other special folders on your Mac. Change the NameFolder string to the special folder name that you want to get from the system. Jan 12, 2020  The Library folder contains many of the resources that installed applications need to use, including application preferences, application support documents, plug-in folders, and ever since OS X Lion, the files that describe the saved state of applications.

Show Library Folder Mac

Mac

So, if you really want to open the Library folder using the Finder quickly, you can’t do as the folder is not visible anywhere in the app. If you happen to access the folder occasionally, you should not have any issues as you can just use any temporary method to get access to the folder, however, if you happen to use the folder now and then, you will need a permanent solution to quickly accessing the folder.

In the guide below, we’re going to show you how you can unhide the Library folder on your Mac. That way, the folder will start to appear in the Finder beside the other folders, and you should be able to access it with a single click.

If that’s what you would like to do, here’s all you need to do to get that:

Using the Shift key to Launch the Folder

One of the ways to access the Library folder is to use the Shift key. When you hold down Shift on your keyboard, some extra options appear in your regular menus that let you access to some special content such as the Library folder.

Here’s how to use this method:

Get inside a Finder window so that you can access its options. Going to your Mac’s desktop is the best way to do that.

Once you are on the desktop of your Mac, you should see the Finder options on the top of your screen. What you need to do is find the menu labeled as “Go” and click on it.

As you can see above, the Library folder just doesn’t exist there although it does exist on your system. To enable it in this menu, hold down the “Shift” key on your keyboard, and the folder will appear in the menu. Clicking on the folder will take you to the current user account’s Library folder.

So, that was a nice way of accessing the Library folder as all it needed was a press on the Shift key and you were ready to go.

Unhiding the Library Folder Permanently on Your Mac

While the method above lets you access the Library folder for your user account, the option for the folder will go away as soon as let go of the Shift key. If you would like for the option to continue to be there, you need to do the following procedure to make it stick there:

Go to the desktop area of your Mac so that you are inside a Finder window.

Click on the “Go” menu at the top and select the option that says “Go to Folder.” This option allows you to jump to any directory on your Mac and you just have to input the path to the directory.

Enter in the following path into the box on your screen and hit “Go” to go there. Make sure to replace Mahesh with the username of your Mac’s account.

/Users/Mahesh/

When the user folder opens, and you can see your files, click on the “View” menu at the top of your screen and it will reveal the Finder’s view options. Click on the option that says “Show View Options” to see the settings that control what should be shown in the Finder windows. Alternatively, you can press the “Command + J” key combination to access the option.

The view options will appear on your screen, and you can now modify them however you want. What we’re interested in is the option that says “Show Library Folder.” You need to checkmark this option and it will make the Library folder to appear in the regular menu of the Finder app. Just checkmark the box and close the panel.

From now on, you should be able to access the Library folder from any window of the Finder app. To do that, you just have to pull down the Go menu and click on “Library,” and you should be inside the Library folder for your user account.

So, that was a permanent method to enable the Library folder in the Finder menu on your Mac. The option for accessing the folder should now always be visible in the Finder, and you are just a click away from getting to that folder on your machine.

Unhiding the Library Folder Using Terminal on Your Mac

Mac Excel Library Folder Template

Another way to enable the Library folder in the Finder is to use a command in the Terminal app. The command does exactly what you did in the above section, but this uses fewer steps as you just have to enter the command in the Terminal app and hit Enter and you are all set. Here’s how to do that:

Launch the Terminal app on your Mac by clicking on Launchpad in the Dock and searching for and clicking on “Terminal.” The app should launch.

Mac dyld shared cache. I have to go back and see if I can find the details.

When Terminal launches, type in the following command and press Enter.

chflags nohidden ~/Library/

As soon as you press Enter, the command will get executed, and it will unhide the Library folder in the Finder menus on your Mac.

You are all set.

Mac Excel Library Folder Template

So, above were some of the ways to access the Library folder on your Mac. The last two methods let you permanently enable the folder in the Finder, so you don’t need to hold down Shift key or do anything else to access the folder as the folder is now always visible in the Finder menus.

You might also be interested in:

Have something to say? You can contribute to this tech article by leaving a comment below.

Your home folder contains many files and folders that apps on your Mac have permission to read or modify. If you use Get Info or other methods to change those permissions, you could experience issues such as these:

  • Changes that you make in System Preferences aren't saved after you quit System Preferences.
  • Changes that you make to the Dock aren't saved after you log out of your user account.
  • Windows that were open the last time you logged out or quit an app (before you changed permissions) open again after you log in or open the app.
  • You're asked for an administrator name and password when moving certain items in the home folder.
  • You repeatedly get a message that macOS needs to repair your Library to run applications.
  • When saving changes to an item, you get a message that the file is locked or you don't have permission to save.
  • Preview, TextEdit, or other sandboxed apps unexpectedly quit when opened.
  • You get an alert that the startup disk has no more space available for application memory.
  • Activity Monitor shows that Safari or SafariDAVClient is using a large amount of system resources.
  • Your Mac performs slowly.
  • iTunes says that your device cannot be synced.
  • Photos and videos that you import into Photos or iPhoto don't appear within the app, but do appear in Finder. Or your library needs to be updated or reselected each time you open Photos or iPhoto.

Reset permissions

If the issue started after changing the permissions of items in your home folder , use these steps to reset permissions.

  1. Turn on or restart your Mac, then immediately press and hold Command (⌘)-R to start up from macOS Recovery.
  2. You might be prompted to enter a password, such as a firmware password or the password of a user who is an administrator of this Mac. Enter the requested password to continue.
  3. When you see the macOS Utilities window, choose Utilities > Terminal from the menu bar.
  4. Type repairHomePermissions in the Terminal window, then press Return. The Repair Home app opens.
  5. Select your user account, click Next, then enter your administrator password. Click Next unlock the volume and begin resetting permissions on your home directory.
  6. When done, click Exit to return to the macOS Utilities window.
  7. Select Reinstall macOS, then click Continue and follow the onscreen instructions to reinstall macOS.

If the issue persists

If resetting permissions doesn't resolve the issue:

  1. Make sure that you have a backup of your Mac, then erase your startup disk.
  2. When done, reinstall macOS.
  3. After installation completes and your Mac restarts to the setup assistant, create a new user account using a different name than the one you were using before. Any difference in spelling is enough.
  4. If you made a Time Machine backup, use Migration Assistant to restore all your files from the backup.