ojrtaste.blogg.se

I won't create any comments or provide a hyperlink base, which would allow me to shorten links within the document. Then for Keywords, I'll say inbound, marketing, and inquires. And for the Category I'll call that inbound, for inbound marketing, in other words, the number of people who reach out to us. And the title for this document, which is just used for internal reference, I'll make it Monthly Inquires. And you can see that I have my name, the author, and then also the name of my company. So there we have the Properties dialog box, and you see that we have the type, where it's stored, size, when it was created, when it was last modified, and so on. But in this case I'll go to the File menu and the last item is Properties. I could also have worked with the menu while is was displayed temporarily. For example, if you click the Maximize button here and all you see is the ribbon, then you can't get to the menu, except by moving your mouse pointer over the very top edge of the program window, that will temporarily display the menu and then you can bring it back entirely by clicking the Restore button here. If, however, you are working in full screen mode and you don't see the menu. Instead you need to go to the menu system, which I prefer to have displayed at the top of the screen. Setting workbook properties is one of the actions that you can't start from the ribbon.

My sample file is the Properties workbook and you can find it in the Chapter02 folder of your Exercise Files collection.

I'll demonstrate how to change a file's properties in this movie. When you store your files on a server, you can assign values to properties that make it easier for you and your colleagues to find files related to a project. If you use Excel at work, you'll probably run into situations where you're on vacation and one of your colleagues needs to find a file that contains data for a project.

These bits of information are called properties. When you create an Excel workbook, the program records your user name, the date and time you created the file, and when it was last modified.