Can we create a viewport in Excel like Autocad?

  • Thread starter Thread starter Alireza Nejad
  • Start date Start date
A

Alireza Nejad

I have a very huge spread sheet and i want to see only some specific areas in
other tabs, something like viewport in autocad, could somebody please help?
 
Those of us who don't work with Autocad don't know what a "viewport" is,
although we can make assumptions.

By "spreadsheet" do you mean a workbook with multiple worksheets or a workbook
with one worksheet that is "huge"?

If the latter, chack out Data>Filter>Autofilter to get specific data.

You can create a Custom Views under View>Custom Views.


Gord Dibben MS Excel MVP

On Wed, 30 Jan 2008 11:17:01 -0800, Alireza Nejad <Alireza
 
Back
Top