Knowledge Base Logo

Information Technology Services

  • Home
  • Glossary
  • Accounts
    • E-lists
    •  Mail Merge
  • Apporto
    • Add Apporto in Canvas
    • Accessing Microsoft SQL (MSSQL) on Apporto Virtual Lab
  • Cal Lutheran Web Learning Center
    • Canvas
      • Cal Lu Canvas Support
        • Respondus Lockdown Browser for Faculty
        • Respondus Lockdown Browser for Students
      • Course Dog
        • Scheduling
          • Curriculum
            • Create a Course Proposal
            • Proposals Overview
            • Submit IDEAS (GE) Proposal
          • Events
            • Event Requests
            • Search Rooms
          • Catalog
            • FAQ
            • Video Tutorials
          • Cybersecurity
            • CyberSecurity Glossary of Terms
            • Anti-Virus Software Updates
            • Fraudulent Emails & Dangerous Attachments
            • Secure Access to your Computer
            • Passwords
            •  CyberSecurity Workshop #1 "You've been Hacked"
            •  CyberSecurity Workshop #2 "The Nigerian Prince"
            •  CyberSecurity Workshop #3 "Virus and Malware"
            •  CyberSecurity Workshop #4 "Think Like a Hacker"
            •  CyberSecurity Workshop #5 "Perspective"
            • In- App Browsing
          • Email
            • Apple
              • Apple Mail for Cal Lutheran Gmail
              • Faculty-Staff iOS setup for Exchange email
              • iOS settings for students and alumni
              • Outlook App for iOS
            • Android
              • Faculty and staff Android setting for Exchange email
              • Students and alumni Android settings for CLU e-mail
            • Outlook
              • Faculty & Staff
                • Outlook PC Configuration for Faculty & Staff
                • OWA (Outlook Web Access) for iOS
                • Outlook 2019 for Mac
              • Students & Alumni
                • Outlook 2011 Mac Settings for CLU Gmail
              • Manually Add Delegate / Shared Mailbox in Outlook
              • Miscellaneous
                •  Touring the Interface
                •  Working with Address Books
                •  Working with Contacts
                •  Working with Delegates
                •  Working with Tasks
                •  Navigating Calendars
                •  Searching Calendars
                •  Drag and Drop Mail and Tasks to Calendar
                •  Drag and Drop Files into Outlook Mail
                •  Moving Contacts into Folders
                •  Google Calendar and Overlay Mode
                •  Opening Shared Calendars
                •  Creating Appointments Events and Meetings
                •  Follow up Flags and Reminders
                •  Organizing Mail into Folders
                • Sharing your CLU Outlook Calendar
                •  Color Coding Important Email
                • Setting up Microsoft Outlook at Home
                •  Quick Parts
                •  Mail Merge
                •  Out of Office Auto Reply
                •  Searching Email
                •  Categories
                •  Peeks
                • Setting up Outlook at home - PC
                • Setting up Outlook at Home - Mac
            • Gmail
              • Forwarding CLU Gmail to another account for students and alumni
              • Stopping CLU Gmail auto-forward
          • FTP Server
            • Connecting to the Cal Lutheran FTP Server
            • FTP Server
          • Hardware
            • Computer Requirements
            • Digital Media Players (Apple T.V, Blu-Ray, Roku, etc)
            • Gaming Consoles
            • Locating your MAC address
            • Disabling Random MAC Address
          • Internet
            • Clear Your Browser Cache
          • MyCLU
            • Login and Password Settings
            • Rearrange Modules in MyCLU
          • Printing
            • Canon Printer
          • Purchases
            • College Buys
            • Personal Computer Purchase
          • Self Service
            • Self Service Leave Request for Exempt personnel
            • Self Service Time Entry for Non-Exempt Personnel
            • Self Service Password Reset (SS-P Reset)
            • Grade Entry for Faculty
          • Setting Up Drives
            • Setting up Access to your Campus Drives - PC
            • Setting up Access to your Campus Drives - Mac
          • Software
            • Accessing free software through Microsoft Azure
            • Anti-Virus
            • Disabling a pop-up blocker
            • Adobe
              •  Adobe Acrobat DC Pro Overview
            • EndNote
            • Excel
              • Locking Cells in Excel
              • Power Query
              • Goal Seek, One Click Charts and Quick Tips
              • IF Function, Track Changes, Move Columns, Forecast Sheet
              • Quick Analysis Tool
              • Named Ranges
              • Slicers, People Graph, Show Formulas
              • If and SUMIF functions
              • Remove Duplicates, Paste Special Values
              • Absolute v Relative values, Advanced Transpose, Flash Fill, Hide Cells
              • Advanced Filtering Data
              • Images in Charts
              • VLOOKUP
              • Printing in Excel
              • Tables and Links, Convert Text to Columns, Formatting a List as a Table
              • Conditional Formatting, Named Ranges
              • Transpose
              • Finding Duplicates
              •  New Excel Features in Office 365
            • Operating system updates for PC and Mac
            • Outlook Web Application in Exchange 2013 (OWA)
            • Trillian Instant Messenger
            • Changing your Signature in Outlook Online
            • Installing SPSS
            • Accessing a PDF document attached to an email on an iPad
            • Google Apps
            • ChemDraw
            • Accessing a PDF document attached to an email on a Fire (or other) Android tablet
            • Using Google Drive for Electronic Signatures
            • Microsoft Office
              • Using Microsoft Office
            • Installing EndNote (Windows)
          • SpectrumU
            • Spectrum U Streaming Service
            • Spectrum U - TV Streaming Service
            • Spectrum Channel Lineup
          • Telecom/Phones
            • Changing your voicemail password
            • Conference Calling (Video)
            • How to access your voicemail from off campus
            • Setting up Out of Office Auto-Replies
            • How to create an out of office greeting using another phone
            • How to create speed dials
            • How to forward voicemails
            • Changing your phone "State" remotely
            • How to listen to deleted voicemails
            • How to remove speed dials
            •  Overview of Shoretel IP 485 Phone (Video)
            • Overview of Shoretel IP 655 Conference Phone (Video)
            • Recording a personal greeting on your 485 phone
            • Recording your name on your 485 phone
            • Recording your out of office greeting
            • Reference phone guide
            • Shoretel Advanced Phone Features
            • Transferring Calls (Video)
            • Changing your Office Phone "State"
            • Transferring your office phone to your cell phone
            • Using Mitel Connect to Answer your Office Phone from your Home Computer
            • Mitel Software and Shoretel Phones
          • Videos
            • Shoretel Phones
              • Conference Calling (Video)
              • Overview of Shoretel IP 485 Phone (Video)
              • Overview of Shoretel IP 655 Conference Phone (Video)
              • Transferring Calls (Video)
            • Training
              • Using the Extron System (Video)
              • Using the Brighlink Easy Interactive Toolbar
              •  Keychain Reset - Mac computers
              •  Connecting a Gaming Console
              •  Disabling the Pop-up Blocker for most Browsers
              •  Zoom Tutorial
              •  Colleague 5.0 Tutorial
              •  VPN 2 Factor Authentication
              •  Student Online Planning Tutorial
              •  Roland Broadcast Center Operations Tutorial
              •  Mapping the V Drive
              • Events Booking
            • Guest Speakers
              • Chief Google Education Evangelist- Jamie Casap
          • Work From Home
            • VPN Connect Client
            • Setting up Access to your Campus Drives - PC
            • Setting up Access to your Campus Drives - Mac
            • Scanning and digitizing documents to PDF
            • Reconnecting your Campus Drives after a Password Change
            • Change Default Duo Authentication Method
            • Password change issues when using a campus owned computer from home
            • Work From Home Resources rev. 1.0
          • Zoom
            • Zoom Teleconferencing
            • Using Multiple Zoom Accounts
            • Downloading the Zoom Client
            • Zoom Polling
            • Zoombombing
            • Outlook Zoom Plug-in
            • Zoom Breakout Rooms
            • Zoom Virtual Backgrounds
            • Zoom Waiting Rooms
            • Zoom - Assigning Scheduling Privileges
            • Zoom breakout rooms - manual assignment
            • Allowing others to Share their screens in Zoom
            • Zoom Installation and Tutorial - PC and Mac
            • Correcting your display name in Zoom
          • ITS Internal (Test)
            • Home
            • Software

            Excel

            Articles

            Locking Cells in Excel
            When locking individual cells or rows or columns, you must first unlock all the cells in the worksheet. By default all cells are "locked" (this does not mean they are locked for data entry, just that they must first be unlocked to select individual ...
            Power Query
            ...
            Goal Seek, One Click Charts and Quick Tips
            ...
            IF Function, Track Changes, Move Columns, Forecast Sheet
            ...
            Quick Analysis Tool
            ...
            Named Ranges
            ...
            Slicers, People Graph, Show Formulas
            ...
            If and SUMIF functions
            ...
            Remove Duplicates, Paste Special Values
            ...
            Absolute v Relative values, Advanced Transpose, Flash Fill, Hide Cells
            ...
            Advanced Filtering Data
            ...
            Images in Charts
            ...
            VLOOKUP
            ...
            Printing in Excel
            ...
            Tables and Links, Convert Text to Columns, Formatting a List as a Table
            ...
            Conditional Formatting, Named Ranges
            ...
            Transpose
            ...
            Finding Duplicates
            ...
             New Excel Features in Office 365
            ...
            About this Article
            • Created: 05/20/2025 12:48 am PDT
            • Last updated: 05/20/2025 12:48 am PDT
            Related Articles
            Was this article helpful?
            Most Popular
            • Computer Requirements
            • Disabling a pop-up blocker
            • How to remove speed dials
            • VPN Connect Client
            • Accessing free software through Microsoft Azure
            • See more....
            Newest
            • Installing EndNote (Windows)
            • Accessing Microsoft SQL (MSSQL) on Apporto Virtual Lab
            • Disabling Random MAC Address
            • Respondus Lockdown Browser for Students
            • Events
            • See more...
            Recently Updated
            • Disabling Random MAC Address
            • Using Microsoft Office
            • EndNote
            • Installing EndNote (Windows)
            • Accessing Microsoft SQL (MSSQL) on Apporto Virtual Lab
            • See more...