Using Images in Mac Numbers Spreadsheets
Ғылым және технология
macmost.com/e-... 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
▶︎ KZread - macmost.com/j-y... (And hit the 🔔)
▶︎ KZread Email Notifications - macmost.com/ytn ⭐️
▶︎ MacMost Weekly Email Newsletter - macmost.com/ne... ✉️
SUPPORT MACMOST AT PATREON
▶︎ macmost.com/pa... ❤️
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
Пікірлер: 59
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.
Great stuff! You can also hide the image by conditional highlighting the cell.
Oh right now to do this on a phone. Thanks for all your videos that helped.
MacMost is continuing to save my bacon. Thanks again!!! 👍
This is gold, thanks!!!
A very useful and informative video tutorial today! Thank you, Gary! 👏🏻❤️
Brilliant! Thank you for this!
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
THANK YOU SO MUCH!
Excellent thank you very much
Thank you. Very useful. But these features are not use on Number Icloud
@macmost
22 күн бұрын
You mean the web version of Numbers? Yes, they probably aren't there.
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?
@macmost
5 ай бұрын
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?
@macmost
Жыл бұрын
No, you are very limited with what you can do as it is just a cell background, not the contents of a cell.
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.)
@macmost
8 ай бұрын
Copy and paste, yes.
@kerryklaassen
8 ай бұрын
@@macmost Thanks so much! I just cleaned that mess up in a jiffy.
@GayellenJohnson
5 ай бұрын
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!
@GayellenJohnson
5 ай бұрын
@@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.
@kerryklaassen
5 ай бұрын
@@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!
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.
@macmost
Жыл бұрын
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?
@macmost
5 ай бұрын
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 kzread.info/dash/bejne/e2yEo7mPh9CfmJs.html
@Ke11yyy
5 ай бұрын
@@macmost Thank you!
Hi Please how to calculate "âge" from date of birth ? Thanks
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?
@macmost
9 ай бұрын
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.
Can you you help me about developing school management system in java.
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!
@macmost
11 ай бұрын
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.
@Video2Webb
11 ай бұрын
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.
@macmost
11 ай бұрын
@@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?
@Video2Webb
11 ай бұрын
@@macmost Thanks for the suggestion, will give it a test. Could be much faster, I hope so!
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?
@macmost
Жыл бұрын
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.
@markoehlschlager3862
Жыл бұрын
@@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?
@macmost
Жыл бұрын
@@markoehlschlager3862 No, sorry, never heard of it.
@GayellenJohnson
5 ай бұрын
I miss Bento too!!
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.
@macmost
5 ай бұрын
No, Numbers can't do it.
@charliesrandomchannel
5 ай бұрын
Thanks. I didn't think it could. Ah that Apple "innovation" that I keep seeing in all of their departments. @@macmost
How can I add a link to a picture in my computer instead? … like receipt to transactions
@macmost
Жыл бұрын
To a file external to the spreadsheet? You can't.
how can i find (text to Speech Tab) in Ventura 13.2 System sittings?
@macmost
Жыл бұрын
Accessibility, Spoken Content
@montasralkady
Жыл бұрын
@@macmost thanks.. but there is nothing about speaking text on enter
@montasralkady
Жыл бұрын
@@macmost i want to know how to let Excel speakes content of a cell on enter ,or in a specific CONDITIONS
@macmost
Жыл бұрын
@@montasralkady You'll need to look through the Excel help for that. Not sure if that exists.
plz , how to add bills or receipts inside my table?
@macmost
Жыл бұрын
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.
@Jonny_C73
Жыл бұрын
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.
🤩
Like your videos but I become out of breath about midway.