View All Data in Worksheet: MS Excel
by Carol Bratt on September, 22 2006 at 08:09AM EDT
An Excel worksheet is packed with hundreds, and sometimes thousands, of cells containing data. You can either view the complete data region (the area where you have input data) in the worksheet, or magnify / reduce the selected data region to the size of the window using the following method:
- Select the current region.
- Press Ctrl + *.
- Choose View | Zoom.
- Select Fit selection.
- Click OK.
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 (from the Excel menu), and uncheck the selection of Formula Bar and Status bar.
- Select any one of the toolbars ad right-click. From the shortcut menu, clear the check boxes beside each of the toolbars displayed.
Only the title row is displayed and more rows are now visible.
To quickly increase or decrease the percentage of the screen magnification: select cell A1 and press Ctrl, then roll the mouse wheel forward or backward.
Visit Carol's web site to learn more tips like this one!
Filed under:
Rate this article:
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?
Do you need Tech Support?

I can help! Send me a message on the bottom left of the screen (using the Zopim Chat button), or click my picture to read more about how I can fix your computer over the Internet. Optionally you can read all about my credentials, here.

I can help! Send me a message on the bottom left of the screen (using the Zopim Chat button), or click my picture to read more about how I can fix your computer over the Internet. Optionally you can read all about my credentials, here.
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?