• 4

The title basically gives the gist of what I am curious about, but to explain more: I wanted to set up a system where I track various things, such as my habits, mood, and tasks every day. I was planning to keep all of this in an Excel spreadsheet. I thought that it would be great if I could make the document where I keep track of this easily visible, so I will remember to edit it every day, and also because it would be easier to access and edit.

Through Googling, I found that at one point in time it was possible to embed an interactive spreadsheet as your desktop wallpaper in Windows. It involved saving the Excel spreadsheet as a webpage (.htm or .html), checking an option called "Add Interactivity", and the document could be set as the desktop background, and it would be editable from there (allegedly). The feature(s) that allowed this in Excel back then don't seem to be available in the 2016 version of Excel for Mac. So, is there a different way to do this now? Or is there some type of desktop Widget I could use as a Spreadsheet? I'm flexible about solutions, so any ideas would be appreciated!

I don't think there's anything that directly involves Excel, but you could look in the Apple Dashboard Widgets store. Then again, Apple could be phasing out the Dashboard, considering how tricky it is to enable it in Sierra. Other than that, keeping a small window or a separate desktop open is the only option I'm aware of.

  • 1
Reply Report
  1. On your Mac, choose Apple menu  > System Preferences, click Desktop & Screen Saver, then click Desktop.


  2. On the left, find a picture or color:

    • Pictures and colors that come with your Mac: Click the disclosure triangle next to Apple, then select Desktop Pictures or Colors to see thumbnails of available pictures and colors.

      Dynamic Desktop pictures automatically change throughout the course of the day based on your current location. If Location Services is turned off in Privacy preferences, the picture changes based on the time zone specified in Date & Time preferences.

      Some dynamic desktop pictures may provide still images so the desktop picture doesn’t distract from the light or dark appearance. For example, if you chose the dark appearance during macOS setup, the desktop picture is set to a dark still image. To use or stop using a still image (if available), click the dynamic desktop thumbnail, then choose an option from the pop-up menu that appears.

    • Your pictures: Click the disclosure triangle next to Photos (or iPhoto if available). If your pictures are in the Pictures or another folder, click the triangle next to Folders, then select a folder.

      To add a folder, click the Add button , navigate to and select the folder, then click Choose.

      If you don’t see anything when you select the folder that contains your pictures, they might not have the right file format—JPEG, PICT, TIFF, PNG, or HEIC. To change a picture’s format, open it in the Preview app, then save it in the new format. If pictures look fuzzy, try using larger ones, such as 1024 x 768 pixels.

  3. On the right, click the picture you want to use.

    The desktop immediately changes, so you can see how the picture looks. When you use one of your own pictures, you can choose to have it fill the screen, be centered, or otherwise arranged. It’s easy to click around and try different pictures and arrangements until you find the one you like best.

    To use all the pictures in a folder, select the “Change picture” checkbox, then choose how often you want the picture to change—for example, every hour. The pictures are shown in the order they appear in the folder, or you can choose to show them in a random order.

To quickly use a picture you have in the Photos app, select the picture in Photos, click the Share button in the Photos toolbar, then choose Set Desktop Picture.

You can use a picture you see on the web as your desktop picture. Control-click the image in the browser window, then select Use Image as Desktop Picture.

  • 1
Reply Report