What if you only want to protect a single, or several single cells, in an entire Excel worksheet and allow users to edit or input data in the rest of the sheet?
Let’s say you have a worksheet like this:
You would like your department members to edit the “data” in the black text cells, but you want to protect the “data” in the red text boxes from accidental changes.
First, you need to unprotect the entire worksheet. That sounds counterintuitive.
But Excel protects all cells in the worksheet by default whenever you set protections, so we need to turn that off in order to only protect individual cells.
To do this:
Save your worksheet and close it.
Now anyone who opens the worksheet will only be able to select and edit those cells that are not locked.
(Need Info on Initiating Calendar Process – Unavailable at this time but will go here!)
Importing Schedules from Oracle
Exporting Your Oracle Calendar Data
Importing the Oracle Data to Google
Sharing Your Calendar
You can access Google Calendar on your mobile device.
- Enter http://www.google.com/calendar in your phone’s web browser
- You can view your agenda, add events, and invite others
You can also stay connected via your mobile device by setting up SMS reminders for your events.
With this feature enabled, Google will send you a text message (you have control over how far in advance) with the name, time, and location of an event.
Click here to learn about setting up and enabling SMS messaging for your Google Calendar.
Google Calendar Quick Ref Guide
Google Calendar Quick Start Page
Save Time and Energy Uploading Multiple Files Simultaneously
Much of the time, users create a single post or page in WordPress and upload any images or documents at the same time.
However, there are times when a user might want to upload all their images or documents first, and then insert them as they create pages and galleries over time.
This is easy to do in WordPress.
Adding “@colby.edu” to a List of Simple Usernames
What do you do if you need to send out a mailing and all you can have is an excel list of simple usernames: no @ sign, no “colby.edu”.
Will you have to edit each one by hand? No!
These easy steps will save you a ton of work:
Are you tired of having to scroll up and down through a very long Word file to find where you want to edit some text? Word’s Document Map view is for you!
Document View in Word will display a list of all the headings in your document down the left-hand side of your document. You can easily move up and down through your document by clicking on headings in this display. To use this feature, headings need to be formatted using the built-in heading styles (Heading 1, Heading 2, etc.).
To display the Document Map:
- This will display the document map along the left side of your document
To Display Thumbnails Rather than Headings:
- Click on the down-arrow next to “Document Map” at the top of the view and select “Thumbnails“
- Word will then display thumbnails of the pages
If you wish to use the outline form to rearrange sections of text in your document, you must use Outline View.
Creating an Internal Hyperlink
- Launch Excel and open the workbook to which you want to add an internal hyperlink.
For demonstration purposes, we will have a workbook with four worksheets: (Resources, Team Members, Budget and an Overview page like this:
- Select the cell you want to make your hyperlink.
- Insert > Hyperlink from the Ribbon
Click Place In This Document on the left
Specify the text you want the linked cell to display in the Text To Display text box
(Go to Worksheet)
Select a worksheet
- Your sheet will now look like this:
- Clicking on the link will take you to the top-left of the Resources worksheet.
If you wanted to go to a specific cell on that worksheet, such as D12, you can specify that cell in the hyperlink dialog:
- Now you sheet would look like this:
- Clicking on the cell link will take you to that exact cell on the referenced worksheet
- Hyperlinks can also be used to quickly move around a single sheet which has many entries and categories
We all know we can link to a video that is sitting somewhere on the Internet from PowerPoint. But what do we do when: 1) An Internet connection is not available (or fast enough) where we are presenting or 2) The video we want has unexpectedly been moved or deleted or 3) The video is one we created and is not on the Internet.
Not a problem! Just follow these steps:
(Instructions for PC ~ Instructions for Mac ~ Presentation Issues)
For PCs ONLY – go here for Mac instructions.
|1||Create the slide from which you want to play the video. I am calling this slide “An Example of Stop-Action Video“.|
|2||Make sure the “Developer” tab is being displayed.
Click on the Windows “Button“, then click on PowerPoint Options.
|Check the box in front of “Show Developer Tab“. Click OK.|
|3||Click on the Developer Tab|
|4||Click on “More Tools“.
Scroll through the list and select the Windows Media Player.
This will give you a mini-player right inside PowerPoint that allows you to start, stop and replay the video.
|5||Your cursor will now look like a cross-hair on the slide.
While holding the LEFT mouse button down, draw a rectangle of the size you want your player to be. When you release the LEFT mouse button, your slide will look like this:
|If you accidentally release the button before you have drawn the rectangle, just start again at step 4.|
|6||Once you h ave the player inserted, Right-Click on the player. Click on “Properties“.|
|7||At the top of the Properties input dialog, click on the “…” button in the “Custom” row.|
|8||Browse to find your video file in the Windows Media Player Properties dialog.
You can also set other variables in this box. For the purposes of this tutorial, we are taking all default settings.
|Click on the small “x” at top-right to close the Properties input dialog.
Your slide will now automatically play the embedded video when it is displayed.
Click here to save a short, 3-slide PowerPoint show that illustrates this task. Save the file to your computer and then double click on it to run the show.
There are many issues that you can run into when presenting PowerPoint shows with embedded or linked files. These include:
- Your presentation can’t find the file
- Your presentation slows down significantly
- Your video won’t play
These almost always relate to:
- What version of Windows or Mac OS you are running
- Where you linked files physically reside
- Whether you are using the same machine you created the PowerPoint on to display the presentation
The permutations of factors makes it impossible to list specific solutions for any situation. However, here are some hints that MicroSoft offers:
- If possible, always run your presentation from the SAME machine you create it on
This eliminates almost ALL issues
- If you have to use another machine, be sure you TEST the presentation before you show it
This gives you plenty of time to troubleshoot issues before you go “live”
- Always LINK files that are larger than 50MB
- EMBED files that are 50MB or smaller
- If you have to present on a “stranger” machine (such as equipment in a convention hall) PACKAGE your presentation for CD in order to keep all linked files where your presentation expects to find them