Using Images in Mac Numbers Spreadsheets
HTML-код
- Опубликовано: 14 июл 2024
- macmost.com/e-2890 You can use photos and other images in your Numbers spreadsheets, but not as values in cells. Learn how you can decorate a sheet with them, or use them in a clever way in a table to display a featured image.
FOLLOW MACMOST FOR NEW TUTORIALS EVERY DAY
▶︎ RUclips - macmost.com/j-youtube (And hit the 🔔)
▶︎ RUclips Email Notifications - macmost.com/ytn ⭐️
▶︎ MacMost Weekly Email Newsletter - macmost.com/newsletter ✉️
SUPPORT MACMOST AT PATREON
▶︎ macmost.com/patreon ❤️
00:00 Intro
00:30 Images Directly On the Sheet
01:04 Images Inside Shapes
01:34 Remove Background
02:00 Images As Cell Backgrounds
03:51 A Visual Representation of Data In a Row
04:34 Text Over the Image
07:51 Show Only One Image From a Set
#macmost #mactutorial 
Наука
Sometimes your ideas are just ... genius!!!
Happens a lot of time that I don't use the products you mention, but I just watch your videos because the ideas are usually super inspiring!
Great video as usual, Gary. I use images in cells often when I have inventories that need to be conducted. It helps people to identify the items that they are going to sign for when there’s a picture to go along with the serial number.
This is gold, thanks!!!
A very useful and informative video tutorial today! Thank you, Gary! 👏🏻❤️
Great stuff!
You can also hide the image by conditional highlighting the cell.
Excellent video! I have been looking for this for a while, I am new using numbers and this trick is useful, thanks
as always your knowledge and sharing is impressive - Thanks Gary
Brilliant! Thank you for this!
MacMost is continuing to save my bacon. Thanks again!!! 👍
Oh right now to do this on a phone.
Thanks for all your videos that helped.
THANK YOU SO MUCH!
Excellent thank you very much
Thanks for this video. So, just to be clear, there is no way to programmatically add images into a cell like we can with Google Sheets =Image() function?
Right. That's not something Numbers does.
After you place an image inside a cell, in addition to resizing the image, can you also move it around inside the cell like you can inside a shape? Or is it only centered?
No, you are very limited with what you can do as it is just a cell background, not the contents of a cell.
When you place an image into Numbers, is the image embedded into the file - which would increase the file size? Or is the image linked so that you can reference the actual image file on your desktop? Adobe Illustrator gives you the option to embed or link images, so I wanted to know if Numbers - as well as Pages, Keynote and Freeform - does too.
Embedded.
Is there a way for users of the spreadsheet to temporarily view a larger version of the image (by clicking on it or some other means) and then it go back to the regular thumbnail type size?
No, there's nothing like that in Numbers. But you can link to a file if you are willing to put in a lot of work ruclips.net/video/I8PAWVWm9h8/видео.html
@@macmost Thank you!
Hi Gary, I am new to Mac. I would like to add my small business logo to cover across 10 columns and 5 rows. At the same time I would like to lock it so when scrolling down the logo still stays in place. i that possible or just wishful thinking?
If you want a logo that big, I would suggest adding it to the sheet itself, not inside a table. If you have some special reason you want it in a table, you can always merge those cells and then add it as a background to the whole merged cell. But you can't make it lock when scrolling unless that happens to be the 5 rows that are part of the header.
Hi
Please how to calculate "âge" from date of birth ? Thanks
Hi, Gary. I started an art inventory spreadsheet last year, with a row for each painting. The left column holds a thumbnail images for each painting. The thumbnail images are not anchored at all, and this is becoming unmanageable. How do I bring it in as an image fill? (I don't want to go hunting all over my image files in my computer; is there a way to copy the unanchored photos and insert them so they are anchored into the cell?) Or, do I give up and buy Excel? (Truth be told, I find Numbers very unintuitive and harder to manage than Google sheets or Excel.)
Copy and paste, yes.
@@macmost Thanks so much! I just cleaned that mess up in a jiffy.
Gary, could you help me please? I am doing the exact same type of spreadsheet with a photo of a painting on each row. I added 195 photos before I realized that if I sort them by another column, the photos don't move with the sort!! I'm so frustrated. If my request is impossible, could you suggest another way to make an inventory on my Mac that will let me sort by different columns? Thank you!
@@kerryklaassen could you explain what you did and if you are now able to sort by different columns and the picture moves with each row? Thank you.
@@GayellenJohnson Yes. My images were not anchored in the spreadsheet, so clicked on each image, coped, then pasted into the cell. Now the images stay with the correct rows when I sort them. Thanks so much for your help!
Can you you help me about developing school management system in java.
🤩
how can i find (text to Speech Tab) in Ventura 13.2 System sittings?
Accessibility, Spoken Content
@@macmost thanks.. but there is nothing about speaking text on enter
@@macmost i want to know how to let Excel speakes content of a cell on enter ,or in a specific CONDITIONS
@@montasralkady You'll need to look through the Excel help for that. Not sure if that exists.
I need to create an inventory of a set of historic documentary photos as I wish to transfer the copyright for them and an inventory is needed. Unfortunately this video did not help me at all. Being able to do the things presented in the video is not relevant to me, alas! I want to know if I can copy, say, 100 pictures, sized to be thumbnails, and get them to flow into a column of cells or if I have to do a tedious 'Insert' for each image. Something as basic as this is not showing up in Searches I have been doing. Now I will have to explore myself!
No. Images are just cell backgrounds in Numbers. I don't know of a good way to do what you want. Maybe in a Pages document instead? But you'd still be working with 100 images and it will take a lot of work.
Many thanks Gary for clarifying the situation with Numbers. I found the same problem in Pages. I have over a 1000 images to log and possibly have found a solution, still time-consuming but not as bad as doing an Insert action over and over again, plus having to put the filename in another column.
Using Finder Icon view, arrange the image thumbnails with their filenames as I need, take a screenshot of the assembly, convert the png in Preview to be PDF, open the first one in Preview and add subsequent PDFs so that I get a single PDF document. As there are so many images, I would likely create several Inventory docs rather than one gigantic one. The files have to be part of the copyright transfer document as an Appendix I presume.
@@Video2Webb If you want that, why not bring them all into Photos (create a new local library just for this project) and then use the Print function in Photos to print a contact sheet?
@@macmost Thanks for the suggestion, will give it a test. Could be much faster, I hope so!
How can I add a link to a picture in my computer instead? … like receipt to transactions
To a file external to the spreadsheet? You can't.
I lament the demise of the database app, Bento. Is it possible to use Numbers to recreate the simple relational databases I had built with Bento?
Depends on what you want to do, specifically. Many database things can be done in spreadsheets, but some things cannot and others are more difficult. There are a few database apps in the App Store if you look.
@@macmost Thank you. Do you have any experience with Ninox? Do you feel that a graphic designer without any coding experience could happily use Ninox as a replacement for Bento to track clients, prospects, projects, contracts, invoicing and payments?
@@markoehlschlager3862 No, sorry, never heard of it.
I miss Bento too!!
plz , how to add bills or receipts inside my table?
Not sure what you are asking. Are you looking to add scans of paper into your Numbers documents? I would scan them but keep them as PDFs or images as files elsewhere. Just have the data (date, amount, etc) in the spreadsheet table.
You can do this with the “Image Gallery” function. It allows you to add pictures from your library, scan receipts, or take new pictures. And you can just keep adding to it and scroll through them. I use this feature for an HSA expenses database I created, and scan all the medical receipts.
Without knowing for sure, I'm certain that Numbers cannot do this. It just seems like something only Excel could do. ...can Numbers pull an image from a website into Numbers on Mac? I have a column of hyperlinks that go to different profile pics. I'd like to pull those images into specific cells so staff don't have to click on the hyperlink to see who is who.
No, Numbers can't do it.
Thanks. I didn't think it could. Ah that Apple "innovation" that I keep seeing in all of their departments. @@macmost
Like your videos but I become out of breath about midway.