View All Data in a Worksheet: MS Excel
An Excel worksheet is packed with hundreds or thousands of cells containing data. You can either view the complete data region in the worksheet or magnify or reduce the selected data region to the size of the window.
Follow the steps below:
- Select the current region an press CTRL + *.
- Choose View | Zoom.
- Select Fit selection.
- Click OK.
You can increase the amount of data that appears in the window by hiding window elements such as the sheet tabs, toolbars, formula bar and status bar.
- Choose Tools | Options.
- Select the View tab.
- Clear the check boxes for Row & column headers. Horizontal scroll bar, Vertical scroll bar, Sheet tabs, Formula bar and Status bar.
- Click OK.
Select View and uncheck the selection of Formula Bar and Status Bar.
Select any one of the toolbars and right-click. From the shortcut menu, clear the check boxes beside each of the toolbars displayed.
Now only the title row is displayed and more rows are now visible.
Visit Carol's web site to learn more tips like this one!
Most popular articles
- Which Processor is Better: Intel or AMD? - Explained
- How to Prevent Ransomware in 2018 - 10 Steps
- 5 Best Anti Ransomware Software Free
- How to Fix: Computer / Network Infected with Ransomware (10 Steps)
- How to Fix: Your Computer is Infected, Call This Number (Scam)
- Scammed by Informatico Experts? Here's What to Do
- Scammed by Smart PC Experts? Here's What to Do
- Scammed by Right PC Experts? Here's What to Do
- Scammed by PC / Web Network Experts? Here's What to Do
- How to Fix: Windows Update Won't Update
- Explained: Do I need a VPN? Are VPNs Safe for Online Banking?
- Explained: VPN vs Proxy; What's the Difference?
- Explained: Difference Between VPN Server and VPN (Service)
- Forgot Password? How to: Reset Any Password: Windows Vista, 7, 8, 10
- How to: Use a Firewall to Block Full Screen Ads on Android
- Explained: Absolute Best way to Limit Data on Android
- Explained: Difference Between Dark Web, Deep Net, Darknet and More
- Explained: If I Reset Windows 10 will it Remove Malware?
My name is Dennis Faas and I am a senior systems administrator and IT technical analyst specializing in cyber crimes (sextortion / blackmail / tech support scams) with over 30 years experience; I also run this website! If you need technical assistance , I can help. Click here to email me now; optionally, you can review my resume here. You can also read how I can fix your computer over the Internet (also includes user reviews).
We are BBB Accredited
We are BBB accredited (A+ rating), celebrating 21 years of excellence! Click to view our rating on the BBB.