Attend IT Blog

Attend IT Limited has been serving the Brentford area since 2003, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

Tip of the Week: Freezing Panes in Your Excel Spreadsheets

Tip of the Week: Freezing Panes in Your Excel Spreadsheets

Microsoft Excel is a great tool for keeping data and figures organized…until, that is, you need to scroll down at all, leaving some important headers out of sight. Fortunately, there is a way to keep your headings in view: freezing the panes they are present in. Let’s go over how to do so.

Let’s say you were working with the following data, outlining the departments each of your employees are a part of, along with when they were first hired and their current pay rate.

As you scroll down this list, you might find it useful to have a reminder of what each column is describing—and this only becomes more the case as your spreadsheets grow larger and more complicated. Luckily for us, Excel makes it easy to have certain data remain on screen.

How to Freeze Panes in Excel

Freezing a pane simply means that you’re telling Excel to keep that data visible as you scroll, and again, it’s laughably easy to do.

First, select the row immediately below or the column immediately to the right of the data you want frozen. In our example, since we want to keep Row 1 in sight, we’d select Row 2.

With the appropriate row or column (in this example, row) selected, you’ll next access the View tab in the ribbon and select Freeze Panes. You’ll then be presented with three options: Freeze Panes, Freeze Top Row, or Freeze First Column.

For our purposes, we’ll be selecting Freeze Panes (although Freeze Top Row would also work in this context). Once you’ve done so, you can then scroll freely, with your top row remaining in sight.

And just like that, you have continued access to critical context for your data! What else would you like to know how to do with your essential business software? Reach out to us at 020 8626 4485 and let us know, or to learn more about how we can generally make your IT maintenance a non-issue for your business.

Why Your Business Needs Cyber Insurance (and What ...
Update Your Business Continuity Plan for 2023
 

Mobile? Grab this Article!

Qr Code

Tag Cloud

Security Technology Business Computing Network Security Productivity Best Practices Cloud Tip of the Week Managed IT Services Data Backup Hackers IT Services Disaster Recovery Data Business communications Data Recovery IT Support Privacy Hosted Solutions VoIP Innovation Backup Small Business Cybersecurity Malware Mobile Devices Software Business Continuity Efficiency Computer Hardware Cloud Computing Phishing Internet Email Outsourced IT Saving Money Business Management Productivity Microsoft Automation Collaboration BDR Internet of Things IT Support User Tips Information Technology Smartphones Ransomware Upgrade Server Smartphone Risk Management Managed IT Budget Workplace Strategy Compliance Managed IT services Users Mobility Mobile Device Management Communication Meetings Workplace Tips Covid-19 Network Artificial Intelligence Training Save Money Managed Service Provider BYOD Quick Tips Remote Windows 7 Remote Workers Passwords Avoiding Downtime Wi-Fi Human Resources Spam Gadgets Mobile Device Google Information Chrome Remote Work Content Filtering Employee-Employer Relationship Instant Messaging Printing Wireless Project Management Data Management History MSP Windows 10 Hosted Solution VPN Time Management Microsoft Office Managed Service Computers Remote Computing Android Firewall Password Networking Cost Management Document Management Virtual Private Network Business Technology Value Laptop Personal Information Devices Encryption Help Desk Software as a Service Saving Time Recovery Audit Conferencing Data Breach Marketing Wireless Internet Video Conferencing Government Computing Managed Services Data Security Telephony Telephone Systems Router Big Data Office Automobile Hacker Machine Learning Voice over Internet Protocol End of Support Maintenance IT Service Monitoring Redundancy Paperless Office Manufacturing Hard Drives Tech Term Social Media Hybrid Cloud Printer Mobile Office Printers Employer-Employee Relationship Mobile Backup and Disaster Recovery Solid State Drive Windows Server 2008 Application Inventory Management Update SMB Active Directory Entertainment Copier Samsung Disaster PCI DSS Legal Blockchain Development Financial Technology Office 365 Infrastructure Professional Services Workers The Internet of Things Break/Fix Window 10 Hiring/Firing Connectivity Save Time Smart Technology Downtime Unified Communications Employees Battery WPA3 Two-factor Authentication Employer/Employee Relationships Administration Proactive Commerce Windows Server Browser HIPAA Online Storage Wasting Money Regulations Compliance Electronic Medical Records Wireless Technology Lifestyle Upgrades Videoconferencing Travel Virtualization Remote Monitoring RMM Business Intelligence Social Engineering Streaming Media Leadership PDF E-Commerce Spyware Copiers File Storage Cost Colocation Company Culture Customer Relationship Management Amazon Going Paperless Money IoT AI Streaming Dark Web Shadow IT Payroll Windows 11 File Sharing App Content Filter Black Market Payment Cards Apple Voiceover Internet Protocol Bandwidth Outsourcing Current Events Gamification Outsource IT Analysis Virtual Assistant Flexibility Antivirus Telephone Vendor Management iPhone intranet SaaS Managed IT Service Transportation Bitcoin Microsoft Outlook Evernote Vulnerability Regulation User Error OneNote Business Telephone Chromebook Windows 10 Cybercrime Nanotechnology e-waste Fiber Optics Proactive IT Private Cloud Education Alexa for Business Cleaning Facebook Data Protection Azure Workstations Holiday Customer Service Operating System Word Mobile Computing Applications Cabling Troubleshooting Going Green Management Work/Life Balance Finance Data Loss Smartwatch Computer Repair Smart Tech Vendor Remote Working Hacking Advertising Cybersecurty Students Phone System Utility Computing Root Cause Analysis YouTube 2FA Mobile Security Organization Worker Internet Exlporer Sales Virus IT Management Gmail Wasting Time HaaS Windows Ink Device Security Alert Environment Windows Cortana Unified Threat Management Screen Mirroring CRM Music Keyboard Shortcuts Social Google Docs Ciminal Settings Server Maintenance Inventory Reviews Print FAQ Windows 10s Outlook Myths Workstation Augmented Reality Holidays Identity Humor Retail PowerPoint Net Neutrality Accessory Work Google Maps 5G Workplace Strategies Search Identities Cast Keyboard Robot Display Computer Accessories Updates Computer Fan Telework Analytics Microsoft Excel Business Strategy Investment Communitications Testing Database Best Practice Adobe Wireless Charging Hard Disk Drive Shortcut Threats OneDrive Data Privacy Point of Sale SSD How To Websites Security Cameras Processor Peripheral Medical IT Safety Legislation Consultant Micrsosoft Google Assistant Co-Managed Services Tablets Microsoft Word Miscellaneous Financial Audits Relocation ROI Hosted Desktop Identity Theft Camera Biometrics How To Apps WannaCry Excel Scams Tech Support Television CrashOverride Sabotage Hard Drive Gifts Data Theft Emails IT Solutions Benchmarks Politics Access Control Authentication Law Enforcement Charger eCommerce Managing Stress Policy Emergency Print Management Comparison Language HBO Digital Signage Twitter Computer Tips NFL Computer Care USB Bring Your Own Device Solutions Books Supply Chain Video Games Storage Windows Server 2008 R2 Smart Devices Worker Commute Projects Scam Text Messaging Licensing Employee Managed Services Provider Fraud PC Innovations Remote Management Webinar WIndows Server 2008 Memory Internet Service Provider Experience Admin Windows 8.1 Reputation Unsupported Software Files App store Procedure Healthcare Scalability Specifications Touchscreen Computer Forensics Hyperlink eWaste Virtual Reality Health Sports IT budget WiFi Data Storage Office Tips iOS Sync Facebook Privacy Edge Telephone System Credit Cards IT solutions Patch Management Google Drive Voice