 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Setup / September 2006XL2003, how can I set the view to show only the cells with data
In Excel 2003, how can I set the view to show only the cells with data in them and the rest of the spreadsheet be hidden or just show a blank area with no cells showing?  SignatureS Thomas You can hide the rows and columns that you are not using. Imagine you are using columns A to F - highlight column G by clicking the "G" at the top of the column, then hold the <Shift> key down and press <End> once followed by <Right-arrow> then release <Shift>. This will have highlighted all the columns from G to IV, then select Format | Columns | Hide. Do a similar thing for the rows - if you make use of 30 rows, for example, highlight all the rows from 31 to the bottom and hide them. You will have a grey area outside your used range. Hope this helps. Pete > In Excel 2003, how can I set the view to show only the cells with data in > them and the rest of the spreadsheet be hidden or just show a blank area with > no cells showing? That did the trick. I was already trying to do that but was trying the Ctrl key instead of the shift key. Thank you! SignatureS Thomas You're welcome - thanks for feeding back. Pete > That did the trick. I was already trying to do that but was trying the Ctrl > key instead of the shift key. Thank you! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.