Having trouble printing an Excel spreadsheet to one page? Is your printer cutting off valuable information? Luckily, there’s a quick solution. What it comes down to is setting your Page Size and Print Scale:
Setting Page Size
1. Select Page Layout in the Excel ribbon.
2. Select the Size button.
3. Next, choose your desired page size. For this scenario, I’m choosing a Standard Letter Size.
Setting Print Scale:
1. Staying on the Page Layout ribbon, click the Scale to Fit Launcher.
2. Choose your scaling option from this section of the Page Setup Dialogue window. To make the spreadsheet fit to one page, click Fit To and then press Okay.
Your Excel spreadsheet should now fit to one page. If you choose, you may also fit the spreadsheet to more pages by simply increasing the amount in the Fit To field.
Time is precious. If you’re not using the following Windows keyboard shortcuts, you should definitely start.
Tech Tip Tuesday: 5 Underutilized Keyboard Shortcuts
*Note: "WIN" refers to the key and “+” means to press the designated key simultaneously with the following key.
1. CNTRL+L - Find the Address Bar
Once you’re ready to go to a new website, simply press CNTRL+L to automatically return to the address bar rather than using your mouse.
2. WIN+D – Minimize & Open All Windows
Working with sensitive information? Instead of going through each window and selecting the minimize button, pressing WIN+D will quickly hide every program open on your desktop. Ready to view them again? Just press WIN+D a second time.
3. CNTRL+F – Go to Find Bar
With access to a number of different web-browsers, it can become easy to forget where the Find Bar is located. The Find Bar is used to look up specific text within a webpage. Just press CNTRL+F and begin searching.
4. WIN+L – Lock your Computer
Need to get up from your desk quickly while making sure your computer isn’t vulnerable? Press WIN+L and your account will be locked until you’re ready to log on.
If you’re like me, you keep a number of tabs open on your web-browser while surfing the Internet. By pressing CNTRL and any number 1 through 9, the browser will rapidly switch between tabs, making it easier to get the information you need as quickly as possible.
Photo courtesy of www.itjive.com.
Do you use Google Drive? Instead of accessing Google Drive from a web-browser, install Google Drive to your computer and save files directly to the cloud! This will save you the hassle of opening a website and transferring files every time you back up documents. Just remember to keep sensitive files on a Columbia College backed location, such as your personal I:Drive, department drive, etc. See below for installation instructions:
Installing Google Drive to Your Computer
Saving Files to Your Google Drive
That’s it! You can now save directly to Google Drive rather than pulling up the Google Drive or Docs on a web-browser.
Tech Tip Tuesday: Document Check Out in SharePoint
Document check out allows you to check out a document while you edit it, making sure no one else can edit. When you have the file checked out, you can edit it online or offline, and save it multiple times. When you finish editing and check the file back into the library, other people can see your changes and edit the file, if they have permission. And, if you decide not to make or keep any changes in the file, you can simply discard your checkout so you don’t affect version history.
For more about checking out documents, visit the Microsoft Help Center here.
About VersioningWhen versioning is enabled in site lists, you can track and manage information as it evolves. You can look at earlier versions and recover them, if necessary. That is very handy, for example, when people realize that earlier versions of an item might be more accurate than later ones. Some organizations retain multiple versions of items in their lists for legal reasons or audit purposes.
When you enable and configure versioning, you can retain versions each time an item it is edited. You need to decide how many versions you allow, and whether you want all site users to see all draft versions, or only be visible only to the originator and specific people in your organization. By default, versioning is turned off. To turn it on and implement your versioning decisions, you must either have Full Control or Design permissions.
Enable and Configure Versioning
1. In a list or library, in the list or library tab, select Settings
Schedule a Skype for Business Meeting with Outlook
Follow these instructions for setting up a meeting through Skype for Business by using the Outlook desktop server or the webmail app.
Set up an online meeting using Outlook server
1. Open Outlook, and go to your calendar.
2. On the Home tab ribbon, click New Skype Meeting.
3. Set up the meeting as you typically would, fill out the invitee section, subject, and the start and end time. If you’ll have in-person attendees, you can use Add Room to schedule a location. For a time that will work for everyone use the Scheduling Assistant.
4. In the meeting area, you can type an agenda or other information about the meeting. Be careful not to change any of the online meeting information.
5. Click Send.
Set up an online meeting using Outlook Web App
1. Login to the Outlook Web App
2. Click Calendar to open the Calendar app.
3. Click the plus sign or New just below the app launcher, and fill in the meeting information as usual.
4. In the middle of the meeting window, above the message area, click Online meeting.
5. Set up the meeting as you typically would, fill out the invitee section, subject, and the start and end time. If you’ll have in-person attendees, you can use Add Room to schedule a location. For a time that will work for everyone use the Scheduling Assistant.
6. In the meeting area, you can type an agenda or other information about the meeting. Be careful not to change any of the online meeting information.
7. At the top of the meeting window, click Send.
Outlook Permission Levels
Outlook has many different permission levels for sharing parts of your account, such as your tasks or calendar. These levels are the same throughout all parts of Outlook.
Full permission means the user can Read, Edit, and Delete a file or folder. The following three Permission Levels allow the granted person to delete files in the folder you give them access to. Use with caution.
The following two Permission Levels allow the granted person to edit/delete only files they have created.
The following four Permission Levels grant minimal access to your folder.
HOW TO TAKE A SCREEN CAPTURE
Sometimes it's easier to show someone what you're seeing on your computer screen instead of explaining it. Both Mac and PC provide solutions for this with the ability to screenshot or screen capture.
Screen Capture with PC
1. Press the PrtScn key on the keyboard. This copies an image of the screen to the clipboard.
2. Open Paint by clicking the Start button > All Programs > Accessories > Paint
3. In the Paint menu click Paste or Ctrl + V on the keyboard.
4. Save the image.
Screen Capture with Mac
1. Press Command + Shift + 3
2. Find the screen capture as a .png file saved on your desktop.
PDF version of this tech tip:
CONNECT A SHAREPOINT CALENDAR TO OUTLOOK
Open a SharePoint calendar in Outlook for the ability to create events and make edits in both SharePoint and Outlook. Outlook provides the ability to work with a SharePoint calendar offline.
How to Connect Your SharePoint Calendar to Outlook
1. Make sure Outlook is open
2. Open Internet Explorer
3. Navigate to the SharePoint calendar you want to open in Outlook
4. Select the Calendar ribbon in the top right menu
5. Click Connect to Outlook
6. In the pop up window, select Allow
7. If Outlook doesn’t come up automatically, go to the Outlook window and select Yes in the pop up window
8. The calendar will show on the left sidebar with the SharePoint site name, listed under My Calendars
View this tech tip in PDF or video version: